Key Information	Excel Level I: Fundamentals	Excel Level II: Intermediate	Excel Level III: Advanced
	$249 6 Hours	$249 6 Hours	$249 6 Hours
	Learn More	Learn More	Learn More
	Download Syllabus	Download Syllabus	Download Syllabus

Overview	In this beginner Excel workshop, you'll learn calculations, basic functions, graphs, formatting, printing - with a comprehensive course review at the end of the class. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.	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.
Prerequisite	Open to Beginners	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.
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 24, Friday, 10–5pm Other scheduling options Weekdays, weekends, or weeknights View full 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
Certification
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Payment Plan See our payment plan FAQ for more details
Financing See our Leif FAQ for more details
Target Audience	Those new to Excel looking to gain the core skills used by business professionals, including formulas, functions, calculations, and time-saving techniques. 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.	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.
What You’ll Learn	Become familiar with the interface and data entry Learn essential formulas and functions Format and print your work Create charts, including line, column, and pie charts Learn tips and tricks for easy workbook management Review key concepts in a final project	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

Enroll in an Upcoming Excel Course

March 2023
Excel Level III: Advanced March 17 Friday 10–5pm EDT	$249 6 Hours	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.
Excel Level II: Intermediate March 21 Tuesday 10–5pm EDT	$249 6 Hours	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.
Excel Level I: Fundamentals March 21 & 23 Tuesday & Thursday 6–9pm EDT	$249 6 Hours	In this beginner Excel workshop, you'll learn calculations, basic functions, graphs, formatting, printing - with a comprehensive course review at the end of the class. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.
Excel Level III: Advanced March 22 Wednesday 10–5pm EDT	$249 6 Hours	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.
Excel Level I: Fundamentals March 24 Friday 10–5pm EDT	$249 6 Hours	In this beginner Excel workshop, you'll learn calculations, basic functions, graphs, formatting, printing - with a comprehensive course review at the end of the class. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.
Excel Level I: Fundamentals March 26 Sunday 10–5pm EDT	$249 6 Hours	In this beginner Excel workshop, you'll learn calculations, basic functions, graphs, formatting, printing - with a comprehensive course review at the end of the class. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.
Excel Level II: Intermediate March 27 Monday 10–5pm EDT	$249 6 Hours	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.
Excel Level II: Intermediate March 28 & 30 Tuesday & Thursday 6–9pm EDT	$249 6 Hours	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.
April 2023
Excel Level II: Intermediate April 2 Sunday 10–5pm EDT	$249 6 Hours	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.
Excel Level I: Fundamentals April 10 Monday 10–5pm EDT	$249 6 Hours	In this beginner Excel workshop, you'll learn calculations, basic functions, graphs, formatting, printing - with a comprehensive course review at the end of the class. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.

showing 10 of 107 courses

Earn a Excel Bootcamp

Enroll in an Upcoming Excel Course