Microsoft Excel 2003 Advanced Training Course
With our Excel 2003 Advanced Training Course, you will learn more complex functions and nesting, how to analyze large amounts of data and also how to make use of Excel's What If Tools.
The Excel 2003 Advanced course is designed for more experienced users of Excel. With our unique course tailoring service, you can choose to include or exclude content for your training session.
We can also run the Excel 2003 Advanced training course onsite, or at our London city based training centre. We can even provide training equipment (laptops, projectors etc) if you need onsite training but do not have a dedicated IT training room.
With the reassurance that our client base includes HSBC, Google, QBE, McDonalds, and many more, why not see how we can provide the best returns on your Excel 2003 Advanced training investment.
Excel 2003 Advanced Training Course Information
Audience: This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros
Course Duration
This is a 1 day Excel 2003 Advanced Course. Course starts at 09:30 and runs until 16:30
Excel 2003 Advanced Course Objectives: After the course, you will be able to:
- Use Lookup & Informational Functions
- Create Pivot Tables
- Use What-If Tools
- Sharing and Tracking Workbooks
- Record Basic Macros
Requirements: You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.
Course Duration
This is a 1 day Excel 2003 Advanced Course. Course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Excel 2003 Advanced Training Course Contents
Lookup & Information Functions
- Vertical Lookup (Vlookup)
- Horizontal Lookup (Hlookup)
- Match and Index
- IsText, IsValue, IsDate, IsErr, Is Error, IsNa
Advanced List Management
- Advanced Filters
- Using List Features
- Dynamic Lists
Pivot Tables
- Using the Pivot Table Wizard
- Changing the pivot table layout
- Formatting
- Grouping items
- Inserting calculated fields
- Pivot Table Options
- Display and hide data in fields
- Lay out reports directly on worksheet
- Pivot Chart
What If Analysis
- Scenarios
- Custom Views
- Reports
- Goal Seek
- Solver
- Data Tables
Protecting & Sharing Files
- Sharing a file
- Tracking changes
- Accepting or rejecting changes
- Applying Data validation rules
- Inserting comments
Introduction to Macros
- Purpose of Macros
- Recording macros
- Where to save macros
- Absolute and relative record
- Running macros:
- Custom buttons, menu items, keyboard shortcuts
**Remember that you can tailor the Excel 2003 Advanced course to suit your exact needs**
Excel 2003 Courses
