Chapter 1

Tapping into Formula and Function Fundamentals

In This Chapter

arrow Getting the skinny on workbooks and worksheets

arrow Understanding the parts of a worksheet

arrow Working with cells, ranges, named areas, and tables

arrow Applying formatting

arrow Figuring out how to use the Help system

arrow Writing formulas

arrow Using functions in formulas

arrow Using nested functions

Excel is to computer programs what a Ferrari is to cars: sleek on the outside and a lot of power under the hood. Excel is also like a truck — it can handle all your data, lots of it. In fact, in Excel 2013, a single worksheet has 17,179,869,184 places to hold data. Yes, that’s what I said — more than 17 billion data placeholders. And that’s on just ...

Get Excel Formulas and Functions For Dummies, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.