Excel 2003 to 2010 Upgrade - Online Course

This series will guide you through the numerous updates and enhancements released for Microsoft Excel. Presented in a streamlined format to maximize training time, these courses are geared toward users who are upgrading from the 2003 to the 2010 version.

This online course contains 4 lessons and should take approximately 10 hours to complete.

Lesson 1: Navigating the Updated Office Interface (2.0) hours

Navigating the Updated Office Interface teaches you how to list and describe the features of the new Office 2007 user interface, change application settings in Office 2007 products, and use the Live Preview feature. This course provides information about the new user interface designed for the Microsoft Office applications. Topics include Why the big change?, The Ribbon: Command tabs and contextual tabs, The Ribbon: The Office menu, Galleries and live preview, and Other new interface features.

Lesson 2: Common Features in Office 2010 (3.0) hours

Common Features in Office 2010 teaches you how to modify and minimize the Ribbon, use Backstage view, capture windows and clippings, add artistic and color effects to images, save documents to the Web, and work with Office Web Apps. This course explores the new features that the major Office 2010 applications have in common. Topics include Modifying the Ribbon, Working with Backstage View, Capturing Windows and Clippings, Removing Image Backgrounds, Adding Artistic and Color Effects, Checking Document Accessibility, Saving Documents to the Web, Working with SkyDrive, and Using Office Web Apps.

Lesson 3: What's New in Excel 2007 (3.0) hours

What's New in Excel 2007 teaches you how to identify features of the new Excel 2007 user interface, convert Excel data into table format, use Excel 2007's Formula AutoComplete feature, analyze data in Excel 2007 using conditional formatting, create professional looking reports, insert and format charts, and work with PivotTables and PivotCharts. This course provides an overview of the new features in Microsoft Office Excel 2007. Topics include The new look of Excel 2007, Using the workbook, Creating and formatting tables, Formula features, Analyzing data using conditional formatting, Creating reports, Creating charts, and Creating PivotTables and PivotCharts.

Lesson 4: What's New in Excel 2010 (2.0) hours

What's New in Excel 2010 teaches you how to describe the new Ribbon features, show data trends with sparklines, use the slicer with PivotTables, and build equations. This course explores the new features in Microsoft Excel 2010. Topics include Reviewing the Ribbon Tabs in Excel, Showing Data Trends with Sparklines, Using the Slicer, and Building Equations.