CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APEXT10 - Microsoft Excel 2010: Transition from 2003

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

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

Click here for a printer-friendly version of this page

Prerequisites

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