Key Information	Excel Level II: Intermediate	Excel Level III: Advanced	Excel Programming with VBA
	$249 6 Hours	$249 6 Hours	$549 12 Hours
	Learn More	Learn More	Learn More
	Download Syllabus	Download Syllabus

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: May 28, Wednesday, 10–5pm Other scheduling options Weekdays, saturdays, evenings, or sundays View full schedule	Next start date: May 21, Wednesday, 10–5pm Other scheduling options Weekdays, saturdays, evenings, or sundays View full schedule	Next start date: Jun 25–26, Weekdays Other scheduling options: Weekdays only 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	6 HoursExcel VBA and Macros Level I 6 HoursExcel VBA and Macros Level II
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	Learn to split and join text, add data validation, and named ranges Use database functions such as VLOOKUP & HLOOKUP Add logical statements, including AND, OR, and IF statements Create Pivot Tables to quickly summarize large databases Use statistcal functions such as Ranking, COUNTIFS, and SUMIFS Create advanced combo charts from multiple charts Review key concepts by creating a final project	Cell management including cell locking, auditing, and hot keys Special formatting for calculating dates Use advanced functions such as nested IF statements Learn advanced analytical tools for data consolidation, conditions to exlude data, and pivot charts Use advanced database functions including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH Record macros and relative reference macros for ad hoc reporting Create a project that applies key concepts from the class	Security Recording macros Reading and analyzing code Programming basic macros Create more complex macros Variables Looping statements Logic statements User Forms Error Trapping Troubleshooting

Enroll in an Upcoming Advanced Excel Course

April 2025
Excel Level II: Intermediate April 29 Tuesday 10–5pm EDT	$249 6 Hours	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.
Excel Level III: Advanced April 30 Wednesday 10–5pm EDT	$249 6 Hours	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.
May 2025
Excel Programming with VBA May 15–16 Weekdays 10–5pm EDT	$549 12 Hours	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.
Excel Level II: Intermediate May 16 Friday 10–5pm EDT	$249 6 Hours	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.
Excel Level II: Intermediate May 20 Tuesday 10–5pm EDT	$249 6 Hours	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.
Excel Level III: Advanced May 21 Wednesday 10–5pm EDT	$249 6 Hours	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.
Excel Level II: Intermediate May 28 Wednesday 10–5pm EDT	$249 6 Hours	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.
June 2025
Excel Level II: Intermediate June 5 Thursday 10–5pm EDT	$249 6 Hours	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.
Excel Level III: Advanced June 6 Friday 10–5pm EDT	$249 6 Hours	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.
Excel Level II: Intermediate June 7 Saturday 10–5pm EDT	$249 6 Hours	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.

Showing 10 of 44 courses

Earn a Excel Bootcamp

Enroll in an Upcoming Advanced Excel Course