O'Reilly logo

Office 2010 Made Simple by Guy Hart-Davis

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 13

Performing Calculations with Formulas and Functions

In this chapter, you'll learn to use formulas and functions to perform calculations with your data.

First, you'll learn what functions and formulas are and what the difference between them is. Then we'll go over how you refer to cells and ranges in formulas and functions. After that, I'll show you how to create your own formulas, using Excel's calculation operators. You'll find it easy to get started, as Excel provides plenty of help, but we'll also look at how to troubleshoot common problems that occur with formulas.

In the second half of the chapter, I'll show you how to insert functions in your worksheets using the various tools that Excel provides, how to find the functions ...

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