Favorite Excel Tricks

The Excel for Models series is the best place to start for an introduction to Microsoft Excel. It includes all of the basic requirements including essential date functions and useful lookup functions. But I thought I would include a few of my favorite Excel shortcuts on one page. The links beneath the video player will take you to the original page, many of which have a template available for download.

Quickly Format Cells with F5:

posted: Excel Trick: Quickly Format Cells With F5

Using F9 to Audit Formulas:

posted: Excel: Using F9 to Audit Formulas

Exclude Zeros When Taking an Average in Excel:

posted: Exclude Zeros When Taking an Average in Excel

Sum a Specific Number of Cells with =SUM and = OFFSET:

posted: Excel Trick: Sum a Specific Number of Cells (template available)

Using CountIf with an Asterisk:

posted: Excel Hack: =CountIf with an Asterisk (template available)

Extract NonBlank or NonZero Values from an Array:

posted: Excel: Extract NonBlank or NonZero Values from an Array (template available)

Excel Trick: SumProduct & Double Minus (“–“):

posted: Excel Trick: SumProduct & Double Minus (“–“) (template available)

A couple additional links that do not have video:

Excel: =XIRR vs =IRR

Excel: =OFFSET() vs. =CHOOSE()

Commission Structure & HLOOKUP Practice