Publisher: Microsoft

Version: 2010
Length: 1 day
Course-ID: 084575

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.


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