Click here if you
would like to
book a course
Save 5% by paying for the course by card at the time of booking!
If you have more
than 3 delegates
you may benefit
from a tailored course!
click here to find out more
Excel 2003 - Advanced level
View our full Excel Course Schedule for course dates or call 0845 485 1173 today for more details
You can view this course outline as a PDF for printing
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
If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk
If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk





