Module: Microsoft Excel Level 3
Lesson 1: Streamlining Workflow
Update workbook properties.
Create a macro.
Edit a macro.
Apply conditional formatting.
Add data validation criteria.
Lesson 2: Collaborating with Other Users
Protect files.
Share a workbook.
Set revision tracking.
Review tracked revisions.
Merge workbooks.
Administer digital signatures.
Restrict document access.
Lesson 3: Auditing Worksheets
Trace cell precedents and dependents.
Troubleshoot invalid data and formula errors.
Watch and evaluate formulas.
Create a data list outline.
Lesson 4: Analyzing Data
Create a trendline.
Create sparklines for data.
Create scenarios.
Perform a what-if analysis.
Perform a 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.
Import and export XML data.
Lesson 7: Integrating Excel Data with the Web
Publish a worksheet to the web.
Import data from the web.
Create a web query to import dynamic data from the web.