Microsoft Office Tutorials and References
In Depth Information
Excel Lesson 7: Analyzing Excel Data
Lesson 7
What you’ll learn
in this lesson:
Understanding data lists
Setting data validation
rules
Converting a range to a
table
Creating a data table
Summarizing data with
subtotals
Analyzing Excel Data
In this lesson, you’ll discover how to use Excel to analyze data.
When you analyze data, you apply tools to organize, study, and
reach conclusions about a collection of information.
Starting up
You will work with several i les from the Excel07lessons 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.
7
See Lesson 7 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.
 
Search JabSto ::




Custom Search