Microsoft Office Excel Level 3 (Advanced) Duration: 12 – 16 hrs

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.