|
|
Lesson 1: Calculating Data with Advanced Formulas |
Manage Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions
|
|
Lesson 2: Organizing Worksheet and Table Data |
Create and Modify Tables
Format Tables
Sort or Filter Worksheet or Table Data
Calculate Data in a Table or Worksheet
|
|
Lesson 3: Presenting Data Using Charts |
Create a Chart
Modify Charts
Format Charts
|
|
Lesson 4: Analyzing Data Using PivotTables and PivotCharts |
Create a PivotTable Report
Analyze Data Using PivotCharts
|
|
Lesson 5: Inserting Graphic Objects |
Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects
|
|
Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment |
Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates
|
|
|
