Zen and the Art of Excel Efficiency

This is a list of my brainstormed ideas for posts in no particular order. Feel free to request a topic by commenting.

Macros

• recording, editing, writing
• relative references
• shortcut keys
• saving in or out of the workbook
• custom button

Help

• help files
• f(x) button

Add-ins

Functions

• lookups (vlookup, hlookup, lookup)
• index
• match
• eomonth
• if()
• nested functions
• sum(), sumif()
• count(), counta()
• sumproduct() -> weighted averages

Formatting and Design

• conditional formatting
• outlines
• filters
• column/row widths
• borders
• fills

Links

• linked cells
• w/o F4
• edit links

Paste Special

• transpose
• values
• formulas
• operator
• link

Array Formulas

Statistical Analysis

Named Ranges

Drag fills

Using external data

Charts

Menu Functions

• Validation
• Security/Protection
• Goal seek
• Pivot Tables

And much more!