Microsoft Excel 2010: upgrade from Excel 2003 2007

Course Overview

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.

For those Microsoft students looking to improve their skills with Excel, this Microsoft training course would be a good start.

Related Courses

• Microsoft Excel 2010: Introduction for Beginners
• Microsoft Excel 2010: Intermediate Level 2
• Microsoft Excel 2010: Advanced
• Microsoft Excel 2007 or 2010: Advanced - Validate & Summarise
• Microsoft Excel 2007 or 2010: Advanced - Formulae & Functions
• Microsoft Excel 2007/2010: Intermediate
• Microsoft Excel 2010: Intermediate
• Microsoft Excel 2010: Visual Basic
• Microsoft Excel 2010: Expert 2010
• Microsoft Excel 2010: Advanced

Skills Gained

Upon successful completion of this course, students will be able to:

• identify the elements of the Microsoft Office Excel 2010 environment.
• organize data in Excel worksheets.
• analyze Excel data by sorting, filtering, and conditionally formatting it.
• present Excel data using charts, illustrations and PivotTables.
• use Office Web Apps.

Prerequisites

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

Course Outline

Lesson 1: Identifying the Elements of the Excel 2010 Environment

• Topic 1A: Identify the User Interface Elements
• Topic 1B: Identify the Ribbon Components
• Topic 1C: Use Contextual Tabs
• Topic 1D: Use Excel Galleries
• Topic 1E: Customize the Excel Interface

Lesson 2: Organizing Data

• Topic 2A: Identify the Enhancements to Excel 2010 Spreadsheets
• Topic 2B: Insert Tables
• Topic 2C: Format Tables

Lesson 3: Analyzing Data

• Topic 3A: Apply Conditional Formatting
• Topic 3B: Sort Data in a Spreadsheet
• Topic 3C: Filter Data in a Spreadsheet
• Topic 3D: Apply a Formula

Lesson 4: Presenting Data

• Topic 4A: Create Charts
• Topic 4B: Format Charts
• Topic 4C: Work with Illustrations
• Topic 4D: Create PivotTables and PivotCharts
• Topic 4E: Share Excel Charts
• Topic 4F: Save Data in Compatible Formats

Lesson 5: Using Office Web Apps

• Topic 5A: Save Excel Spreadsheets to the Web
• Topic 5B: Access and Work with Spreadsheets on the Web

• Appendix A: New Features in Microsoft Office Excel 2010
• Appendix B: Enhanced File and Compatibility Features in Microsoft Office Excel 2010
• Appendix C: Link Formatting in Tablet PCs
• Appendix D: Mobile Features