Microsoft Excel 2010 Transition from Excel 2003

1 day

Course Overview

Learn the new and the enhanced features of Microsoft Office Excel 2010. This course builds on what you already have been doing with Microsoft Office Excel 2003. Learn how to use the latest release for improved data management, presentation, and spreadsheet distribution.

Target student

This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Office Excel, ideally Microsoft Office Excel 2003, and who are planning to upgrade to Microsoft Office Excel 2010.

Prerequisites

Students must have prior knowledge of Microsoft Office Excel 2003 or Excel XP on the Windows operating system.

Course Outline

Identifying the Elements of the Excel 2010 Environment

  • Identify the User Interface Elements
  • Identify the Ribbon Components
  • Use Contextual Tabs
  • Use Excel Galleries
  • Customize the Excel Interface

Organizing Data

  • Identify the Enhancements to Excel 2010 Spreadsheets
  • Insert Tables
  • Format Tables

Analyzing Data

  • Apply Conditional Formatting
  • Sort Data in a Spreadsheet
  • Filter Data in a Spreadsheet
  • Apply a Formula

Presenting Data

  • Create Charts
  • Format Charts
  • Work with Illustrations
  • Create PivotTables and PivotCharts
  • Share Excel Charts
  • Save Data in Compatible Formats

Using Office Web Apps

  • Save Excel Spreadsheets to the Web
  • Access and Work with Spreadsheets on the Web

Optional Items

  • New Features in Microsoft Office Excel 2010
  • Enhanced File and Compatibility Features in Microsoft Office Excel 2010
  • Link Formatting in Tablet PCs
  • Mobile Features