O'Reilly logo

Office 2019 For Seniors For Dummies by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8

Doing the Math: Formulas and Functions

IN THIS CHAPTER

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required