Microsoft® Excel® 2010: Level 3


1 Day (6.5 instructional hours)

Excel 2010


Course Description: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, trouble shoot errors,collaborate on worksheets,  and share Excel data with other applications.

TargetStudent:This course is meant for those desiring to gain skills necessary to create macros,collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Prerequisites:To ensure success, students will need to be familiar with using personal computers and should have experience with Microsoft Office Excel 2010: Level 1 (Second Edition) and Microsoft Office Excel 2010: Level 2 (Second Edition).

Course Outline

Lesson 1: Streamlining Workflow

Topic A: Updated Workbook Properties

Topic B: Create a Macro

Topic C: Edit a Macro

Topic D: Apply Conditional Formatting

Topic E: Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

Topic A: Protect Files

Topic B: Share a Workbook

Topic C: Set Revision Tracking

Topic D: Review Tracked Revisions

Topic E: Merge Workbooks

Topic F: Administrator Digital Signatures

Topic G: Restrict Document Access

 Lesson 3: Auditing Worksheets
Topic A: Trace Cells

Topic B: Troubleshoot Invalid Data and Formula Errors

Topic C: Watch and Evaluate Formulas

Topic D: Create a Data List Outline

Lesson 4: Analyzing Data

Topic A: Create a Trendline

Topic B: Create Sparklines

Topic C: Create Scenarios

Topic D: Perform a What-If Analysis

Topic E: Perform a Statistical Analysis with the Analysis Tool Pak

Lesson 5:Working with Multiple Workbooks

Topic A: Create a Workspace

Topic B: Consolidate Data

Topic C: Link Cells in Different Workbooks

Topic D: Edit Links

Lesson6: Importing and Exporting Data

Topic A: Export Excel Data

Topic B: Import a Delimited Text File

Topic C:Import and Export XML Data

Topic B:Troubleshoot Invalid Data and Formula Errors

Topic C: Watch and Evaluate Formulas

Lesson 7: Integrating Excel Data with the Web

Topic A: Publish a Worksheet to the Web

Topic B: Import Data from the Web

Topic C: Create a Web Query

Ready for training on other Microsoft Office products? ContactExcelHelpat(800)