Microsoft Excel 2007: Upgrade New Features

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.

This Microsoft training course will help you stay competitive, sharpen your skills and could enhance your Microsoft career prospects.

Related Courses

• Microsoft Excel 2007: VBA Introduction
• Microsoft Excel 2007: Formulae & Functions
• Microsoft Excel 2007: Charts, Pivot Tables & Macros
• Microsoft Excel 2007: Introduction for Beginners (1 day)
• Microsoft Excel 2007: Visual Basic for Applications (VBA) Programming (2 day)
• Microsoft Excel 2007: Advanced
• Microsoft Excel 2007: Advanced (1 day)
• Microsoft Excel 2007: Intermediate (1 day)
• Microsoft Excel 2007: Intermediate (2 day)
• Microsoft Excel 2007 or 2010: Advanced - Validate & Summarise

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