Compare Excel Classes

Which Excel course is right for you? This tool allows you to compare our Excel courses with the important information you need to make the right decision.

Key Information
Excel Level I: Fundamentals
Excel Level II: Intermediate
Excel Level III: Advanced
$249 6 Hours
$249 6 Hours
$249 6 Hours
Overview
Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.
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.
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: April 2, Tuesday, 10–5pm
Other scheduling options Weekdays, evenings, or sundays
View full schedule
Next start date: April 3, Wednesday, 10–5pm
Other scheduling options Weekdays, evenings, or sundays
View full schedule
Next start date: April 10, Wednesday, 10–5pm
Other scheduling options Weekdays, evenings, or sundays
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

November 2023
November 19
Sunday 10–5pm EST
$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.

November 20
Monday 10–5pm EST
$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.

November 21–28
Tuesdays 6–9pm EST
$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.

November 27
Monday 10–5pm EST
$249
6 Hours

Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.

November 27 & 29
Monday & Wednesday 6–9pm EST
$249
6 Hours

Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.

November 28
Tuesday 10–5pm EST
$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.

December 2023
December 1
Friday 10–5pm EST
$249
6 Hours

Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.

December 4
Monday 10–5pm EST
$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.

December 4 & 6
Monday & Wednesday 6–9pm EST
$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.

December 6
Wednesday 10–5pm EST
$249
6 Hours

Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.

showing 10 of 79 courses

Yelp Facebook LinkedIn YouTube Twitter Instagram