Microsoft Excel Advanced

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