Chapter 8
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
Understand Functions
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. ...
Get Office 2019 For Seniors For Dummies 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.
