Courses + Certifications
Professional Development | | Desktop Applications | | Technical | |
|
Home > Desktop Applications > Microsoft Excel > Microsoft Excel 2007 > Excel 2007 New Features
Excel 2007 New Features
| Print Preview | Send to a friend |
| Learning Method: |
Instructor Led |
Overview: |
| In this course, students will work with the new and enhanced features in Microsoft® Office Excel® 2007. |
Pre-requisites: |
|
An understanding of how to use MS Excel, and familiarity with the Internet.
|
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
|
|
|
|
