Excel Advanced 2007
Two Day Course

Course Overview

This hands-on course is designed to give delegates an understanding of some of the more advanced features within Excel including managing, automating and customising workbooks.

Delegates Requirements

A working knowledge of Excel and Windows is required, either gained from attendance on a Microsoft Excel Introduction Course or from use in the workplace.

Who Should Attend

Existing users of Microsoft Excel who want to gain knowledge on how to consolidate and link worksheets, print and view specific worksheet data using outline and work with simple databases using macros.

Course Outline

What’s New in Excel 2007

Increased Workbook File Size

Cell Styles

Table Styles

New Conditional Formatting

Sort by Cell/Font Colour

New Chart Features

Page Layout View

Old Feature, New Location

Custom Formatting

Formatting Numbers and Using Custom Formats

Custom Number Format Sections and Codes

Custom Date Format Codes

Formatting SpeedKeys

Using Conditional Formats

Working with Named Ranges

Creating Range Names

Using the Go To Command

Range Names in Calculations

Importing and Exporting Data

Using Paste Special

Object Linking and Embedding

Sharing Data with Other Applications

Importing a Text File into Excel

Importing Data from Web Pages

Templates and Add-Ins

Creating Workbook Templates

Custom Templates; Storing Templates

The Default Template

Loading Add-In Programs

Working with Multiple Workbooks

Creating Custom Views

Creating and using Workspace Files

Linking Workbooks

Creating Formulae to Link Data Printing

Workbooks and Reports

Printing Multiple Worksheets

Printing Multiple Workbooks

Using the Report Manager

Lookup and Reference Functions

Using the LOOKUP Function

Using the VLOOKUP Function

Using the HLOOKUP Function

Preventing LOOKUP Errors

Working with Toolbars

Displaying Hidden Toolbars

Floating and Docking Toolbars

Customising Toolbars

Creating a New Toolbar

Using Macros

Understanding Macros

Recording a Basic Macro

Relative References

Running and Editing Macros

Assigning a Macro to a Toolbar

Button Image Editor

Macro Virus Protection

Creating Map Charts

Creating Data Map Charts

Editing a Map Chart

Adding Features to a Map

TO BOOK A COURSE
Telephone 01794 521449