O'Reilly logo

Excel Formulas and Functions For Dummies, 3rd Edition by Ken Bluttman

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

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 ...

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