Key Information |
Excel Level II: Intermediate |
Excel Level III: Advanced |
Excel Programming with VBA |
---|---|---|---|
$249
6 Hours
|
$249
6 Hours
|
$549
12 Hours
|
|
Overview |
Learn intermediate Excel functions like VLOOKUP and SUMIFs, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training. |
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users. |
In this hands-on course, learn how to automate repetitive tasks in Microsoft Excel using VBA programming. Develop macros, custom commands, and new worksheet functions to streamline your Excel workflow and increase productivity. |
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.
|
Open to Beginners
|
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: November 11 & 13, Monday & Wednesday, 6–9pm
Other scheduling options Evenings, weekdays, sundays, or saturdays View full schedule |
Next start date: November 13, Wednesday, 10–5pm
Other scheduling options Weekdays, evenings, sundays, or saturdays 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 Climb Credit 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 |
|
|
|