|
|
|
Lesson 1: Creating and Applying Templates |
Create a Workbook from a Template
Create a Custom Template
Working with Comments
Create a Hyperlink
Use Web-based Research Tools
|
Lesson 2: Creating and Modifying Charts |
Create a Chart
Format Chart Items
Change the Chart Type
Create a Diagram
|
Lesson 3: Working with Graphic Objects |
Insert Graphics
Create AutoShapes
Format Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Move, Copy, and Resize Graphic Objects
|
Lesson 4: Calculating with Advanced Formulas |
Create and Apply a Name for a Range of Cells
Calculate Across Worksheets
Calculate with Date and Time Functions
Calculate with Financial Functions
Calculate with Statistical Functions
Calculate with Lookup and Reference Functions
Calculate with Logical Functions
|
Lesson 5: Sorting and Filtering Data |
Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Calculate with Database Functions
Add Subtotals to a Worksheet
|
Lesson 6: Using Excel with the Web |
Export Excel Data
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
|
|
|
