About this course
For the experienced Excel user, this live practical Microsoft Excel Advanced webinar will provide a workshop day with flexible content to cover advanced subjects, including those detailed below.
This webinar will be delivered via WebEx.
What you will learn
Course Objectives
- Full understanding of IF, OR, AND
- Date Functions and Principles
- Gain an understanding of Macros and Visual Basic for Applications
Course Content
- Recap of Intermediate knowledge
- Advanced Filters and Subtotals
- Pivot Tables and Pivot Charts
- VLOOKUP and HLOOKUP
- INDEX and MATCH
- Importing Data
- Text Functions SEARCH, LEFT, RIGHT, MID, LEN
- More Text Functions PROPER, UPPER, LOWER, ABS
- Other Useful Functions RAND, INT, CAR
- Data Validation and Data Input Control
- Using OR/AND with the IF Function
- Error Trapping with ISERROR, IFERROR and IFNA
- Date Functions DATE, DAY, MONTH, YEAR, NOW, TODAY, WEEKDAY
- Basic Macros
- Creating Advanced Macros Using Visual Basic for Applications
Recent reviews
Very informative - I did it as a refresher but learned new things too, the Trainer was excellent.
DEBBIE B03 Apr 24
Met all needs for my personal development
Charlie W21 Mar 23
Glyn was insightful, engaging and the course materials were really useful and easy to follow.
Jamie B12 Dec 22