Excel 2010 from Excel 2003 - New Features

Duration:8 hours

Overview:
In this course students will use the new and enhanced features in Microsoft Office Excel 2010

Who Should Attend:
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.

At Course Completion:
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.

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

Lesson 1: 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     

Lesson 2: Organizing Data    
Identify the Enhancements to Excel 2010 Spreadsheets
Insert Tables
Format Tables     

Lesson 3: Analyzing Data    
Apply Conditional Formatting
Sort Data in a Spreadsheet
Filter Data in a Spreadsheet
Apply a Formula   

Lesson 4: Presenting Data    
Create Charts
Format Charts
Work with Illustrations
Create PivotTables and PivotCharts
Share Excel Charts
Save Data in Compatible Formats

Lesson 5: Using Office Web Apps    
Save Excel Spreadsheets to the Web
Access and Work with Spreadsheets on the Web