You can view this course outline as a PDF for printing

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

First Name
Surname
Company Name
Phone
Email
City
Main Course Area of Interest	AccessDreamweaver ExcelGoogle AdWords IllustratorIndesign Not Listed/OtherOutlook PhotoshopPowerPoint ProjectPublisher Word
Query
Image Verification Please enter the text from the image [ Refresh Image ] [ What's This? ]

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