Learn to solve challenging problems in Excel by applying and nesting various functions. You'll get an introduction to VBA, Excel's programming language, to automate workflow and repetitive tasks. Through various exercises and projects, you will reinforce and build upon knowledge gained in intermediate-level courses. 

Who Should Attend This Course?

This course is perfect for those who feel comfortable with topics covered in our Advanced Excel for Business course and want to elevate their skills and tackle difficult exercises in Excel. As opposed to standard courses where the desired function or formula is known beforehand, in this courses attendees (with instruction and guidance from an Excel expert) will have to devise the proper set of functions needed to solve the exercise. 

Course Objective: The goal of this course is not to simply provide attendees with complicated formulas for future reference, but to teach users how Excel's functions can be used to solve complex problems. 

Related Courses

Want to become a Power User but don't meet the prerequisites? Our Excel for Business Bootcamp is a 3-day program that will prepare you for the course. 

Looking to learn VLOOKUP and Pivot Tables? Master these functions and tools in Intermediate Excel for Business

Do you work in investment banking or a financial firm and have a strong foundation in Excel? Our Advanced Excel for Financial Modeling course will show you the tricks and techniques you need to become a top financial analyst. 

warning-standard-solid This course has a prerequisite

Attendees must have Excel proficiency equivalent to our Advanced Excel course, including nested functions, INDEX-MATCH, and recording macros.