APEXT10 - Microsoft Excel 2010: Transition from 2003

You will use the new and enhanced features in Microsoft Office Excel 2010.

Click here to print this page »


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

Detailed Class Syllabus

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