Getting Started

The course will begin by teaching participants how to open and interact with Excel. They will also learn about Excel’s new features. This section also describes how to view and use tabs on the ribbon, how to customize the Quick Access toolbar, and how to create and customize ribbon tabs.

New Workbook Features

This section will begin with a complete overview of Excel’s new printing features. We will also discuss methods of saving files in different formats and tools that can help ensure file consistency. Next, this section will introduce students to SharePoint Server 2010 and Microsoft OneDrive, and how these sharing features interact with Excel 2010. Finally, participants will learn about new picture and image-based features. Topics include screenshots, picture-based SmartArt, artistic image effects, the new background removal tool, and equations.

New Formatting and Data Management Features

In this section, participants will learn about the new Sparkline feature, improved conditional formatting tools, and the enhanced Solver add-in.

Pivoting Data

The final section of this course will explore how PivotTables and PivotCharts have changed in Excel 2010. The new PowerPivot add-in will also be discussed.