Microsoft Office Excel Level 3

Course Description

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 Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Lesson 4: Analyzing Data
Create a Trendline
Create Sparklines
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