0800 019 6882

 
 
 
Home |Course Schedule |Onsite training  |FAQ | Book |Offers |Contact |Reputation |Season Ticket |Guarantee  
 

Excel 2003 - Advanced level

This one day course can be booked according to our course schedule, or alternatively you can book a trainer to visit you.  Contact us for more details!

Objectives 

After completing this course you will know how to:

Use named ranges in formulas

Use LookUp functions

Link multiple workbooks

Import data

Use Pivot Tables and charts

Use Templates and styles

Analyse data

Create and use macros

Protect a spreadsheet

Consolidate a workbook

Pre-requisites 

Experience of Windows 2000 or later.

Attendance on Excel 2003 Intermediate course or equivalent 

Course Contents

Naming Ranges
Define named ranges

Use named ranges in formulas

VLookUp and HLookUp Functions
Using VLookUp

Using HLookUp

Linking Multiple Workbooks
Use formulas to link workbooks

Create a workspace

Importing Data
Import from external sources

Using Microsoft Query

Pivot Tables and Charts
Creating a PivotTable

Changing field settings

Creating a chart

Templates and Styles
Working with templates

Working with styles

Macros
Creating macros

Adding custom controls

Analysing Data
Using GoalSeek

Using Solver

Using Data Tables

Scenario Manager

Security and Proofing

Protecting Excel files

Worksheet protection

Using data validation

Using text to speech

Customising Excel 2003

Customising toolbars

Customising the environment

 Collaboration and Consolidation

Sharing workbooks

Sending workbooks

Consolidating data

View as PDF

Register for our newsletter to receive details of current special offers!

 

Excel advanced courses Bristol, Bath, Somerset, Gloucester, SW, South West, London, Swindon

 
Home |Course Schedule |Onsite training  |FAQ | Book |Offers |Contact |Reputation |Season Ticket |Guarantee  

Tel:0800 019 6882 Ts and Cs

Web: www.computertrainingsolutions.co.uk

We accept card payments via telephone

 

visa visa electronsecpay lloyds tsb cardnetmastercard maestro

Information Pages

Public scheduled courses

Microsoft Office Training

Onsite training

Inhouse training

FAQ

Training schedule

 

Applications

Excel training

Powerpoint Training

Word training

Access training

Visio training

Project training

Dreamweaver training

Additional links

Training in Bristol

Training in Solihull

Training in Bracknell

Training in Birmingham

Google AdWords Training

 

View sitema