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.
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.
- Small classes
- Computer provided
- Book included
- Free retake
We provide computers to use during class. This course is available on PC only.