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 6, Monday, 10–5pm
Other scheduling options Weekdays, evenings, or Sundays
View full schedule
Next start date: April 7, Tuesday, 10–5pm
Other scheduling options Weekdays, evenings, or Sundays
View full schedule
Next start date: April 15, Wednesday, 10–5pm
Other scheduling options Weekdays, evenings, or Sundays
View full schedule
Certification
Software Included
Microsoft Office (1 month)
Microsoft Office (1 month)
Microsoft Office (1 month)
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 Climb Credit 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
  • Get comfortable with the Excel interface and learn multiple ways to enter and organize data in a worksheet.
  • Work with rows, columns, and worksheets by inserting, deleting, hiding, grouping, and managing spreadsheet elements.
  • Build foundational Excel skills with Autofill, basic calculations, AutoSum, and essential functions such as SUM, AVERAGE, MAX, MIN, and COUNT.
  • Use formulas more effectively with absolute references, logical true/false tests, text functions, and multi-input functions.
  • Format spreadsheets for clarity with cell formatting and conditional formatting that highlights data based on specific rules.
  • Create visual reports with column charts, line charts, pie charts, sparklines, and Excel Tables.
  • Manage workbooks more efficiently using Freeze Panes, printing tools, display options, templates, and essential keyboard shortcuts and Excel tips.
  • Reinforce key concepts through end-of-class projects designed to review what you learned.
  • Navigate worksheets more efficiently using keyboard shortcuts and Excel tools that speed up movement within and between cells.
  • Work with formulas and text by reviewing calculation methods, splitting text with Text to Columns, and joining text with CONCAT and the ampersand.
  • Manage cell ranges with Paste Special, Paste Special Values, and named ranges to format data, hardcode results, and simplify references in calculations.
  • Use database tools such as VLOOKUP, XLOOKUP, Sort & Filter, and Remove Duplicates to find, organize, and clean large sets of data.
  • Build PivotTables to summarize large databases, group data within PivotTables, and create multiple PivotTables on a single worksheet.
  • Apply logical, math, and statistical functions including IF, AND, OR, SUBTOTAL, SUMIFS, and COUNTIFS to analyze data based on conditions and filtered results.
  • Improve data quality with Data Validation and reinforce key course concepts by completing an end-of-class project.
  • Use advanced navigation tools, Autofill techniques, Hot Keys, and Go To Special to move through worksheets and work more efficiently.
  • Build stronger formulas with mixed references, cell auditing tools, date functions, and custom number formats.
  • Create advanced logic with nested IF statements and IF formulas that incorporate AND/OR criteria for more flexible results.
  • Perform What-If Analysis with Goal Seek and Data Tables to test variables and evaluate possible outcomes.
  • Analyze data with advanced PivotTable tools, including base fields and sets, calculated fields, and Pivot Charts.
  • Use XMATCH, INDEX-MATCH, macros, and dynamic arrays to create powerful lookups, automate tasks, and complete an end-of-class project reviewing key concepts.

More Excel Courses

Enroll in an Upcoming Excel Course

January 2026
January 6
Tuesday 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.

January 6–8
Weekdays 10–5pm EST
$549
18 Hours

Become proficient in Microsoft Excel and go from beginner to pro with our hands-on Excel Bootcamp. Learn functions, formulas, Pivot Tables, macros, and time-saving techniques to conquer all the key skills needed to excel in Excel.

January 7
Wednesday 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.

January 8
Thursday 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.

January 11
Sunday 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.

January 11–25
Sundays 10–5pm EST
$549
18 Hours

Become proficient in Microsoft Excel and go from beginner to pro with our hands-on Excel Bootcamp. Learn functions, formulas, Pivot Tables, macros, and time-saving techniques to conquer all the key skills needed to excel in Excel.

January 12
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.

January 12 & 14
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.

January 13
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.

January 18
Sunday 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.

Showing 10 of 85 courses

Yelp Facebook LinkedIn YouTube Twitter Instagram