Microsoft Office Excel 2007: New Features Course
Course Description
In this course, you will work with the new and enhanced features in Microsoft® Office Excel® 2007, improving the management, presentation, and distribution of your spreadsheets.
Course pre-requisites:
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. Students enrolling in this course should understand how to use some version of Excel, preferably 2003 or XP, and have some familiarity with the Internet. This course covers the commonly used new features for a typical user. Due to the nature of this course and the minimal prerequisites, there are other more advanced new features that are not covered in depth.
This course is rated as a Fundamentals Course, suitable for novice computer users and beginners.
Topics covered on the 1 day Microsoft Office Excel 2007: New Features course
Exploring the Excel Environment
- Explore the User Interface
- Work with the Ribbon
- Work with Contextual Tabs
- Use the Excel Galleries
- Customize the Excel Interface
Organizing Data
- Explore the Enhancements in Excel 2007 Spreadsheets
- Insert Tables
- Format Tables
Analyzing Data
- Apply Conditional Formatting
- Sort Data in a Spreadsheet
- Filter Data in a Spreadsheet
- Apply a Formula
Presenting Data
- Create Charts
- Format Charts
- Work with Illustrations
- Create PivotTables and PivotCharts
- Share Excel Charts
- Save Data in Presentable Formats
Appendices
- New Features in Microsoft Office Excel 2007
- Appendix B: Enhanced File and Compatibility Features in Microsoft Office Excel 2007
Course Classification:
Applications Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
| July 2010 | August 2010 | October 2010 | October 2010 | December 2010 |
| 9 | 6 | 1 | 1 | 3 |
View full schedule of Microsoft Excel 2007 courses
View full schedule of Microsoft Excel courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Excel Training and bespoke Microsoft Excel courses
The Microsoft Office Excel 2007: New Features course qualifies for the PTR Training Passport SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.