O'Reilly logo

Microsoft Excel 2010 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

8. Understanding Formulas

Excel’s forte 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.

Getting the Most from This Chapter

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 are learning new things along the way.

I call them “gasp moments.”

Imagine this setting: I am in front ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required