Excel Advanced 2003
Two Day Course

Course Overview

This course is designed to give delegates an understanding of some of the more advanced features and functions within Excel. The course is entirely 'hands on', so those attending will get practice in using advanced features to manage, automate and customise workbooks.

Delegates Requirements

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

Who Should Attend

Existing users of 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

Review

Creating formulae

Applying and Copying Formats

Working with multiple sheets

Using Short Cut Keys

Using common Statistical Functions

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 Custom Formats

Creating Custom Format

Applying Custom Formats

Creating a Template

Applying and Editing a Template

Working with Multiple Workbooks

Creating Custom Views

Creating and using Workspace Files

Linking Workbooks

Creating Formulae to Link Data

Excel Tools

Creating Scenarios

Show Auditing Tools

Trace and Remove Precedents

Trace and Remove Dependents

Logical Functions

Creating an IF Function

Using the AND Function

Applying the OR Function

Pivot Tables and Charts

Creating Pivot Tables

Changing Pivot Tables

Creating Pivot Charts

Changing Pivot Charts

Creating Charts

Amending Charts

Using the Shortcut Key to Chart

Lookup and Reference Functions

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

Creating a Macro Button

Assigning a Macro to a Toolbar

Button

Image Editor

Working with Long Data Entries

Appling Multiple Sorts

Using Subtotals

Applying Filters

Advanced Filters

Using Data consolidation

Validating Data

Applying Conditional Formatting

Database Functions

    Using dmax

Using dmin

Applying daverage

Using dcount

Text and Date Functions

Using the Left Function

Using the Right Function

Applying the Text Function

Concatenating Text

Using the Dated if Function

TO BOOK A COURSE
Telephone 01794 521449