Excel 2003 Advanced
Short course
In London
Description
-
Type
Short course
-
Location
London
-
Duration
1 Day
The aim of this course is to increase delegates understanding of the advanced features available within Microsoft Excel 2003. By the end of the course delegates will be able to use forecasting tools, import data from external data sources and increase efficiency by using macros and templates. Suitable for: current users of Microsoft Excel
Facilities
Location
Start date
Start date
About this course
Delegates must have a good knowledge of Excel 2003 either through experience in the work place or attendance of an Excel 2003 intermediate course.
Reviews
Course programme
Core Topics
Importing Data
· Importing Data From External Sources
· Importing Text Files
· Using Microsoft Query
· Querying Data From The Web
· Refreshing Data
Templates and Styles
· Working With Templates
· Working With Styles
Analysing Data
· What-If Analysis
· Goal Seek
· Data Tables
· Scenario Manager
· Solver
· Using Pivot Tables
Macros and Custom controls
· Working With Macros
· Running Macros
· Adding Custom Controls
Security and Proofing
· Security Features
· Protecting Excel Files
· Worksheet Protection
· Working With Digital Signatures
· Checking Spelling
· Using Data Validation
· Using Text To Speech
· Documentation
Customising Excel 2003
· Configuring Excel 2003 Options
· Customising The Excel Environment
· Working With Workspaces
Collaboration and Consolidation
· Sharing Workbooks
· Sending Workbooks
· Consolidation
Excel 2003 Advanced