Excel 2007: New Features

Learning Outcomes:

• Customize the Excel Interface to fit your workplace needs.
• Analyze the enhancements in Excel spreadsheets and select those that will improve particular applications.
• Apply a Formula, use the enhanced Function Wizard, calculation options and the Function Library to improve the usability of a spreadsheet.
• Work with enhanced chart tools, chart templates and the SmartArt Gallery to improve the appearance and readability of a spreadsheet.
• Create enhanced PivotTables and PivotCharts.

In this half day course, students will learn additional features to improve the management, presentation, and distribution of your spreadsheets with new enhanced features of Excel 2007.

• Exploring the Excel Environment
• Organizing Data
• Analyzing Data
• Presenting Data
• New Features


Excel 2007: New Features

This workshop will focus on working with the MS Office Button, the Ribbon, the Quick Access Toolbar, the Contextual tab, the Excel Galleries, and the MS Office Window Frame. Customize the Excel Interface to fit your workplace needs. Explore the enhancements in Excel spreadsheets. Work with the enhanced tables, format tables. Use the Conditional Formatting Button, the Conditional Formatting Categories, and the Conditional Formatting Rules Manager Dialog Box. Sort and Filter data. Apply a Formula, use the enhanced Function Wizard, calculation options and the Function Library. Work with enhanced chart tools, chart templates and the SmartArt Gallery. Create enhanced PivotTables and PivotCharts.

Class targeted to: Designed for the experienced Excel user who has worked with earlier versions of Excel, ideally Excel 2003 and who have upgraded or will upgrade to Office 2007.

Prerequisites: Experience with some version of Excel preferably 2003 or XP and some familiarity with the Internet. Due to the nature of the course, and short timeframe, some of the more advanced new features are not covered in depth.