Hours: 4
Short Description:
You have worked with Microsoft Office Excel 2003, and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your spreadsheets. In this course, you will work with the new and enhanced features in Microsoft Office Excel 2007.
Course 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 Pivot Charts
Share Excel Charts
Save Data in Presentable Formats
|
|
