Chapter 8

Doing the Math: Formulas and Functions


Bullet Learn How Formulas Are Structured

Bullet Write Formulas That Reference Cells

Bullet Move and Copy Cell Content

Bullet Reference a Cell on Another Sheet

Bullet Understand Functions

Bullet Take a Tour of Some Basic Functions

Bullet 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.