O'Reilly logo

Learn Office 2016 for Mac, Second Edition by Guy Hart-Davis

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

© Guy Hart-Davis 2016

Guy Hart-Davis, Learn Office 2016 for Mac, 10.1007/978-1-4842-2002-3_15

15. Crunching Numbers with Formulas and Functions

Guy Hart-Davis

(1)Barnard Castle, Durham, UK

To make your worksheets deliver the information you want, you’ll probably need to perform calculations with your data. To perform calculations, you enter formulas and functions in cells, as you’ll learn to do in this chapter.

I’ll start by going over what functions and formulas are so that you’re clear on the difference between them. Then I’ll show you how to create your own formulas using Excel’s calculation operators. You’ll find it easy to get started because Excel provides plenty of help, but you’ll also look at how to troubleshoot common problems that occur ...

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