Microsoft Excel Level 3

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.