Microsoft Excel 2007 Overview

General Description

Become familiar with the new look and feel of Excel 2007. Review the ribbon, office button and quick access toolbar. Produce professional spreadsheets and time saving calculations by using new features such as cell styles, themes, enhanced conditional formatting, the name manager, tables, enhanced charting and pivot table capabilities.

Target Audience

This session is intended for participants who have used previous versions of Microsoft Excel and who wish to become familiar with the new Excel environment. 

Pre-requisites

Participants should have an understanding of using a computer including working with Windows, using a mouse, accessing the menus and file management. They should be familiar with a previous version of Microsoft Excel and the learning outcomes of the Microsoft Office 2007 Environment session.

Duration

2 hours

Delivery Style

Hands on instructor led training

Learning Outcomes

• Identify key screen elements, navigate ribbon and use contextual tabs
• Access commands and customise the quick access toolbar
• Locate file management commands on the Microsoft Office button
• Create new files using Excel 2007 templates
• Identify Microsoft Excel 2007 File formats
• Save files as PDF and XPS
• Use and create themes
• Apply and modify built-in cell styles
• Create and mange conditional formatting
• Use the formulas tab
• Create new statistical functions
• Mange defined names with the name manager
• Work with Microsoft Excel tables
• Apply improved filtering and sorting
• Insert and customise enhanced Microsoft Excel charts
• Create and modify enhanced Pivot tables