O'Reilly logo

Excel® 2013 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 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.

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 always learn 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