Microsoft Office Tutorials and References

In Depth Information

**Excel Lesson 5: Building Formulas and Functions**

Lesson 5

What you’ll learn

in this lesson:

•
Understanding Excel

formulas

•
Function types

•
Building an AutoSum

formula

•
Defining and using range

names in a formula

Building Formulas

and Functions

In this lesson, you will discover how to build basic formulas and

functions in Excel spreadsheets.

Starting up

You will work with several i les from the Excel05lessons folder in this lesson. Make

sure that you have loaded the Oi ceLessons folder onto your hard drive from

www.DigitalClassroomBooks.com/Oi ce2010
. See “Loading lesson i les” on page XXIV.

5

See Lesson 5 in action!

Use the accompanying video to gain a better understanding of how to use some of

the features shown in this lesson. The video tutorial for this lesson can be found at

www.DigitalClassroomBooks.com/Oi ce2010.