|
Advanced Excel
Lesson Objectives:
Learn how to create Pivot Tables. This lesson will demonstrate how to
format data as tables, summarize data with a formula, insert hyperlinks
and manage changes to workbooks. In this lesson
you will:
Identify the
steps needed to create a PivotTable page 4
Practice using Row
Labels to filter the data
page 8
Learn how to use the
Field Settings to Count Values
page 9
Learn how to Pivot
the Table!
page 12
Practice how to
Refresh the PivotTable page 13
Identify the steps
needed to create PivotCharts
page 14
Practice how to
change, resize and move the Chart
page 17
Learn the steps to
Insert a Hyperlink
page 22
Use the Review
Ribbon to collaborate and secure data page 25 |
||
|
| ||
