Excel 2007 New Features
|
|
| DATE |
|
What is OLL?
|
|
| PRICE |
DURATION |
$365.00 ex. GST
|
½ Day |
|
|
 |
|
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. |
|
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
|
|
|
|
- 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
|
|
|
|
|
|
|
| Course Ratings | | Averaged from 809 responses. | | Overall Satisfaction |  |
|
|
|
|
|
|
|
|
|
|
|
|
CODE:0-0-3148LGEE-ILT
|
