Doing the Math: Formulas and Functions
IN THIS CHAPTER
Learn How Formulas Are Structured
Write Formulas That Reference Cells
Move and Copy Cell Content
Reference a Cell on Another Sheet
Take a Tour of Some Basic Functions
Explore Financial Functions
The main reason why people choose Excel is that it “excels” at storing and calculating numeric data. With Excel, you can create a grid of numbers, and then insert formulas that perform math calculations on them. That capability makes it possible to build complex worksheets that calculate loan rates and payments, keep track of your bank accounts, and much more.
In this chapter, I show you how to build formulas and functions in Excel, and how to put them to work to do several types of calculation-based jobs. ...