Advanced Skills in Microsoft Excel 2010 (E-Learning)

Printer-friendly version

Length:2.00 hours - Excluding labs and assessments
Published:Jun 29, 2010
Audiences:Information Worker
Technology:Microsoft Office 2010 suites
Delivery method:Self-pace Course

Course Contents: 

This online course is designed to help you customize and manage the Excel 2010 interface as well as know how to manage, manipulate, and format data.

Topics covered in this course include:

Setting Excel 2010 Options
Manipulating Worksheet Data
Creating and Editing Named Ranges
Working with Solver and PowerPivot Add-Ins
Working with External Data
Creating and Editing Web Queries
Creating Sparklines and Trendlines
Analyzing PivotTable Data
Creating and Editing Macros
Running a Macro
Workbook Protection Levels


Learners must have the basic skills of using Excel 2003. These include basic tasks such as opening a workbook, formatting text, and saving a workbook. It is recommended that the learners complete the course 4697 that introduces the Fluent Interface (ribbon).

For more information on Advanced Skills in Microsoft Excel 2010 (E-Learning) please feel free to contact us online or call us at 416-513-1535.