New Horizons Computer Learning Center
410-597-9722

Excel 2007 - New Features

Course Length: 1/2 Day

Overview:
In this course, students will be introduced to the new features in Microsoft Office Excel 2007.

Prerequisites:
Experience with previous versions of Excel

Course Objectives:
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

Course Content

• 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

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com