Microsoft Courses:
Microsoft Office Excel 2007: New Features Training Course

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.

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

   (excl.VAT)

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk