Microsoft Office Tutorials and References
In Depth Information
Excel Lesson 7: Analyzing Excel Data
What you’ll learn
in this lesson:
• Understanding data lists
• Setting data validation
• Converting a range to a
• Creating a data table
• Summarizing data with
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.
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.
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