Home > Courses Certifications > Microsoft Office > Excel 2010 Level 3 synopsis

Microsoft Excel 2010 - Level 3

Prerequisites: Excel Level 2

Duration: 1 day

Lesson 1: Streamlining Workflow

• Update Workbook Properties
• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria

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
• Watch and Evaluate Formulas
• Create a Data List Outline

Lesson 4: Analysing Data

• Create a Trendline
• Create Sparklines
• 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 Workbooks with XML

• Develop XML Maps
• Import and Export XML Data