|
View our full
Excel Course Schedule or call 0800 019
6882 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:
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 0800 019 6882, or email us at
sales@computertrainingsolutions.co.uk
Excel advanced courses Bristol, Bath, Somerset,
Gloucester, SW, South West, London, Swindon
|