Google
 

Thursday, September 13, 2007

Tracking Formulas in Microsoft Excel

One of the first thing's you'll probably have to do once you get PerformancePoint Planning installed is try and reverse engineer some accountant's complex spreadsheet of formulas.  Mr. Excel has some invaluable tips and tricks like this one.

See all Formulas at Once
There is a grave accent on your keyboard. It is usually just below the F1 key. It looks like a backwards apostrophe. Hold down Ctrl and press the grave accent. You will see all formulas:

Tracking Formulas in Microsoft Excel

No comments: