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