Excel: Advanced

Building off Excel: Introduction and Intermediate, the Advanced course is designed to give students the skills to master complex functions and automate processes in Excel.

What You'll Learn

  • Introduction to nesting functions
  • VLOOKUP functions
  • Using the IFERROR function
  • Using the consolidate data commands
  • Recording and running macros
  • Customizing the ribbon

Course Details

  • 2 modules
  • Full day of instruction
  • Industry-expert instruction

Who should take this course?

Anyone looking to master complex functions, including VLOOKUP and SUMIFS, and to learn the fundamentals of creating and editing macros that can automate processes in Excel.

Knowledge of Excel: Introduction and Intermediate concepts preferred.

Excel: Advanced
from 145.00
Delivery Method:
Purchase Now

Interested in a private course for your team? Contact Us

Excel is an incredible software program.. After spending three days at Learn iT! my confidence level has increased substantially. I look forward to taking the PowerBi course next!!
— Ela K.