|
|
Lesson 1: Streamlining Workflow |
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings
|
|
Lesson 2: Collaborating with Others |
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Administer Digital Signatures
Restrict Document Access
|
|
Lesson 3: Auditing Worksheets |
Trace Cells
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watch and Evaluate Formulas
Create a Data List Outline
|
|
Lesson 4: Analyzing Data |
Create a Trendline
Create Scenarios
Perform What-If Analysis
Perform Statistical Analysis with the Analysis ToolPak
|
|
Lesson 5: Working with Multiple Workbooks |
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links
|
|
Lesson 6: Importing and Exporting Data |
Export Excel Data
Import a Delimited Text File
|
|
Lesson 7: Using Excel with the Web |
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
|
|
Lesson 8: Structuring XML Workbooks |
Develop XML Maps
Import and Export XML Data
|
|
|
