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

Get Learn Office 2016 for Mac, Second 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.