O'Reilly logo

Excel Formulas and Functions For Dummies, 4th 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 the Excel basics

arrow Writing formulas

arrow Working with functions in formulas

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 2016, 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 one worksheet!

tip Opening files created in earlier versions of Excel may show just the number of worksheet rows and columns available in the version the workbook was created with.

Excel is used in all types of businesses. And you know how that’s possible? By being able to store and work with any kind of data. It doesn’t matter whether you’re in finance or sales, whether you run an online video store or organize wilderness trips, or whether you’re charting party RSVPs or tracking the scores of your favorite sports teams — Excel can handle all of it. Its number-crunching ability ...

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