Part II

Performing Calculations and Presenting Data

In this part of the book, you get up to speed with formulas, functions, charts, and graphical elements such as pictures and sparklines.

In Chapter 5, we go over what formulas and functions are, and what the difference between the two is. This chapter then teaches you how to create your own formulas using Excel's calculation operators, starting with straightforward formulas that use a single calculation operator each, and then moving on to more complex formulas that use multiple calculation operators. You also learn how to override Excel's default order for evaluating operators and how to troubleshoot common problems that occur with formulas.

In Chapter 6, you learn how to insert functions ...

Get Learn Excel 2011 for Mac 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.