Excel 2007 - New Features

Duration: 4 hours

Overview:

In this course, students will work with the new and enhanced features in Microsoft® Office Excel® 2007.

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 have upgraded to Microsoft Office Excel 2007.

At Course Completion:

Upon successful completion of this course, students will be able to: - explore the new and enhanced Microsoft Office Excel 2007 environment. - organize data in Excel worksheets using enhanced tables and table formats. - analyze Excel data by applying enhanced conditional formatting, and generate specific information using the sort and filter options. - present Excel data using enhanced charts and illustrations, as well as work with the enhanced options of PivotTables and PivotCharts for conducting selective analysis.
 
Outline:

Lesson 1: Exploring the Excel Environment
Explore the User Interface
Work with the Ribbon
Work with Contextual Tabs
Use the Excel Galleries
Customize the Excel Interface

Lesson 2: Organizing Data
Explore the Enhancements in Excel 2007 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 Presentable Formats