Excel’s forté is performing calculations. When you use Excel, you typically use a combination of cells with numbers and cells with formulas. After you design a spreadsheet to calculate something, you can change the numbers used in the assumption cells and then watch Excel instantly calculate new results.
Do not skip this entire chapter; one particular trick in this chapter can save you daily frustration.
I regularly entertain accountants and auditors with my Power Excel program. Although this program is a fun, laughter-filled tour through the inside tricks of Microsoft Excel, people always learn new things along the way.
I call them “gasp moments.”
Imagine this setting: I am in front ...