Microsoft Excel 97 Advanced Training Course in London and the UK
Our Excel Advanced course will build on your current Excel skills. The Excel Advanced course will concentrate on Lookup Functions, Analysing lists using Pivot Tables, Using What If Analysis and customising Excel. Users attending this class must be able to demonstrate an Intermnediate level of competence, or have attended our Intermediate course.
Excel 97 Advanced Training Course Information
To build on previous knowledge and explore Advanced functionality within Excel, finishing with an introduction to Macros.
Course Duration
This is a 1 day Excel 97 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 97 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
Excel 97 Courses
