Microsoft® Excel® 2010: Level 3

Microsoft® Excel® 2010: Level 3

< Back to Course Catalog

Duration:

1 Day (6.5 instructional hours)

Excel 2010

CourseNumber:084678S3


Course Description:

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot 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 D: 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)682-0882orvisitusonlineatwww.ExcelHelp.com

< Back to Course Catalog