Exploring Microsoft Excel 2007

Objectives: The aim is to ensure that attendees can find the new location of all the facilities they have used in earlier versions of Microsoft Office.

Pre Requisites: Previous experience of Microsoft Excel would be a benefit

Duration: 1 day

The topics covered are as follows:

1 The New User Interface
• The Ribbon
• Dialog Box Launchers
• Quick Access Toolbar
• View Selector/Zoom
• Keyboard Shortcuts

2 The Office Button
• Creating/Saving Documents
• New File Formats
• Version Compatibility
• Excel Options

3 The Home Tab
• Cut, Copy and Paste
• Font and Alignment
• Number and Styles
• Cells / Editing

4 The Insert Tab
• Tables and Illustrations
• Charts
• Links
• Text objects

5 The Page Layout Tab
• Themes and Page Setup
• Scale to Fit
• Sheet Options
• Arranging Graphic Objects

6 The Formulas Tab
• Function Library
• Defined Names
• Formula Auditing
• Calculation Options

7 The Data Tab
• Get External Data
• Connections (Links)
• Sort & Filter
• Data Tools and Outline

8 The Review Tab
• Proofing (Spelling & Grammar)
• Comments
• Tracking Changes

9 The View Tab
• Workbook Views
• Show/Hide
• Zoom and Window
• Macros

microcomputing serves the Tyne & Wear, Northeast England region, with software training courses arranged for all types of companies in Sunderland, Washington, Gateshead and Newcastle as well as County Durham, Northumberland and the Teeside area with courses for organisations in Middlesbrough, Darlington and Stockton.