|
Advanced Excel
Lesson Objectives:
Learn how to analyze data with filters, subtotals and
Lookup tables. This lesson will demonstrate how to present data
visually: sort, filter, outline and chart. You will also learn how to
look up data with a formula. In this lesson
you will:
Learn how to Filter the
data page 3
Learn how to create
Subtotals
page 6
Identify the options
to Group and Outline data page 8
Learn the steps to
Name a Range
page 16
Practice
the VLookup Function page 17
Practice the
HLookup Function page 23
Learn the steps to
calculate the bonus
page 20
Learn how to
show two sets of data on the same chart
page 21
Learn how to use
SmartArt! page
33 |
||
|
| ||
