Excel 2003 - Advanced level
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Excel 2003 - Advanced level

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




 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration1 day
 
£250
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).