Excel: Formula Auditing, a vital tool

The vital role of Formula Auditing. An amazing but little known tool in Excel.

Trick 1) F2 Key, Shows formula in current cell (rather than looking up at the Formula Bar)
Trick 2) Ctrl ~, Show all formulas in worksheet (~ is located below the Escape key)
Trick 3) Formula Auditing, draw arrows to formulas (Add to your Quick Access Bar)

See Examples on this Video

E-Book by Andy Lanning: Microsoft Office 2010 MUST FIX LIST

NEW!! Get the MS Office 2010 MUST FIX List... Just $7.50 for an E-book that will spare you endless frustration when you upgrade to Office 2010, plus other tips & tricks. I developed this MUST FIX list as a teaching necessity. I couldn’t start class until the students could find their buttons! It’s provided here as a way to give you a jump-start with your new software. (IMPORTANT! At payment screen, when completed, click the yellow bar, labeled: ‘Return to Computer Software Training, LLC’ to initiate the download.)