Advanced Excel XP-2003
Course Duration
Duration – 1 Day. Course timings 0930-1630 (approximate)
Course Aims
This course will provide delegates with more advanced skills and techniques for customising and automating spreadsheets.
Exposure to pivot tables, MS query and macros are covered.
Pre-requisites
Prior knowledge and/or experience of Microsoft Excel 2003 is desirable.
Target Audience
This course is designed for users who wish to use the advanced functions of Excel including importing data, creating forms, more advanced charts and macros.
Content/Topics
The Microsoft Excel 2003 Advanced course will cover the following topics enabling delegates at the end of the course to be able to:
—————————————————————————————————————————————————————–
Importing
From Text File
MS Query
Import from Access
Query Access
Parameter Query
Refresh Automatically
Web Query
Auditing
Precedents
Dependents
Circular References
Error Tracking
Evaluate Formula
Watch Window
Show Formulas
Pivot Table/Chart
Create, Amend
Filter Data
Drill Down
Display Empty Cells
Show/Hide Detail
Group/Ungroup Data
Rank Data
Calculated Fields
Calculated Items
Macro
Macro Recorder
Edit Macro
Run Macro
Delete Macro
Assign Macro to Picture
Assign Macro to Ribbon
Simple VBA
Tables
One-Way Table
Two-Way Table
Format Table
Sharing
Track Changes
Highlight Changes
List in Sheet
Accept/Reject Changes
What If
Goal Seek
Solver
Scenario Manager
Consolidate
Simple Consolidate
Across Sheets
Across Books
Conditional Options
In Conditional Formatting
In Validation
Control Forms
Option Buttons
Check Boxes
Spinners
Combo
Calendar
Create Forms
Active X Form
Advanced Charts
Secondary Axis
Dynamic Charts