Chapter 1
Tapping into Formula and Function Fundamentals
In This Chapter
Getting the skinny on workbooks and worksheets
Understanding the parts of a worksheet
Working with cells, ranges, named areas, and tables
Applying formatting
Figuring out how to use the Help system
Writing formulas
Using functions in formulas
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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
