Excel 2007: Skills Update - New Features

Scheduled Dates (sort by: location | date)

Course Overview

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.

Audience

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.

Prerequisites

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.

Course Outline

Exploring the Excel Environment

• Explore the User Interface
• Work with the Ribbon
• Work with Contextual Tabs
• Use the Excel Galleries
• Customise the Excel Interface

Organising Data

• Explore the Enhancements in Excel 2007 Spreadsheets
• Insert Tables
• Format Tables

Analysing 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

Excel 2007: Skills Update - New Features / MEX07-UG