In House - 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.
Course price:
£1200 + 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
Open dates
Course name | Topic | Environment | Duration | Price | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Microsoft Excel Advanced
|
Microsoft Office Skills
|
Webinar
|
1 Day
|
£250 + VAT
|
|
|
|
|
|
|
|
|
|
|
|