Open Course - Webinar
Microsoft Excel Advanced
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.
Individual delegate price:
£250 + VAT
Course Introduction
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.
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