Key Information |
Excel Level II: Intermediate |
Excel Level III: Advanced |
Excel Programming with VBA |
---|---|---|---|
$249
6 Hours
|
$249
6 Hours
|
$549
13 Hours
|
|
Overview |
In this intermediate Excel class, you'll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text.
|
In this advanced Excel training, you'll learn advanced database functions such as INDEX and MATCH; create basic macros; and use What-If Analysis for Goal Seek and Data Tables.
|
This Excel VBA course concentrates on practical automation of repetitious Excel tasks and reports. In this hands-on training, you will write macros to automate your Excel tasks even if the data is not consistently formatted, create custom Excel applications and environments, and create custom Excel Add-ins to increase the functionality of the program.
|
Prerequisite |
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.
|
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
|
Prior VBA programming knowledge is not required, but knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, Pivot Tables, and IF statements.
|
Location |
185 Madison Ave, NYC or Live Online
|
185 Madison Ave, NYC or Live Online
|
185 Madison Ave, NYC or Live Online
|
Schedule |
Next start date: March 27, Monday, 10–5pm
Other scheduling options Weekdays, weeknights, or weekends View full schedule |
Next start date: April 11 & 13, Tuesday & Thursday, 6–9pm
Other scheduling options Weeknights, weekdays, or weekends View full schedule |
Next start date: Mar 30–31, Weekdays
Other scheduling options: Weekdays or weekends View full schedule |
Certification |
|
|
Receive a Certificate of Completion
|
Free Retake Within 1 Year
See our class policies for more details
|
|||
Workbook Included |
|||
Courses Included (Certificates & packages only) |
N/A
|
N/A
|
|
Payment Plan See our payment plan FAQ for more details |
|
|
|
Financing
See our Leif FAQ for more details
|
|
|
|
Target Audience |
Those with familiarity with basic Excel, including basic formulas & functions, graphs, and tables, seeking to expand their skills to intermediate-level features, including VLOOKUP and Pivot Tables. The skills taught in the course apply to a variety of industries, including technology, financial services, retail, education, professional services, healthcare, non-profit, and more. |
This class is meant for those with prior experience with basic and intermediate-level Excel skills looking to learn Excel’s most advanced functions and capabilities, including advanced lookup functions, Pivot Charts, and macros. |
Anyone
|
What You’ll Learn |
|
|
|