Microsoft Office Tutorials and References
In Depth Information
Excel Lesson 5: Building Formulas and Functions
What you’ll learn
in this lesson:
• Understanding Excel
• Function types
• Building an AutoSum
• Defining and using range
names in a formula
In this lesson, you will discover how to build basic formulas and
functions in Excel spreadsheets.
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.
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