185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Excel 2010: Transition MS Excel 2003
Excel 2010: Transition MS Excel 2003

Course Code: GE | Hours: 4

Our public class schedule has upgraded. Please contact us at (212) 684-5151 or Info@CareerCenters.com to inquire about private tutoring or corporate classes. To view the offerings for current versions, see the links below.

Excel 2010: Transition MS Excel 2003 Training 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.

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

  • dentify 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 should have a basic understanding of Windows, including how to use files and folders.

Next Classes:

Related Classes:

See Also:

Microsoft Excel 2010: Transition MS Excel 2003 Training 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