Key Information
Excel Level I
Excel Level II
Excel Bootcamp
$249 7 Hours
$229 7 Hours
$549 21 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.
Learn functions, formulas, Pivot Tables, Macros, and time-saving techniques in this hands-on Excel Bootcamp. You'll conquer all the keys skills to become proficient in Microsoft Excel.
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.
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: July 12, Tuesday, 10–5pm
Other scheduling options Weekdays, weeknights, or weekends
View full schedule
Next start date: July 7, Thursday, 10–5pm
Other scheduling options Weekdays, weeknights, or weekends
View full schedule
Next start date: Jul 18–20, Weekdays
Other scheduling options: Weekdays, weeknights, or weekends
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
  • 7 HoursExcel Level I
  • 7 HoursExcel Level II
  • 7 HoursExcel Level III
Discounts See our discounts policies for more details
  • Shorter courses such as this are already affordably priced and are not eligible for discounts.
  • Shorter courses such as this are already affordably priced and are not eligible for discounts.
  • Take 10% off this course if you’ve previously taken any 12+ hour course.
  • Take $100 off this course if you’re an individual paying for yourself (not reimbursed by a company).
Payment Plan See our payment plan FAQ for more details
12-Month 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.

Participants with limited to no experience in Excel looking to master Excel’s most common applications used by business professionals, including:

  • Those working in or seeking a position in that requires advanced analytical skills in Excel
  • College and graduate students looking to supplement academic coursework with practical applications of Excel in business-contexts 
  • Entrepreneurs of freelancers looking to work on advanced Excel projects
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
  • Calculations, basic functions, graphs, formatting, printing
  • Functions such as VLOOKUP and SUMIFs
  • Summarize data with Pivot Tables
  • Sort & Filter databases
  • Working with text: split & join text, dropdown menus
  • Advanced database functions such as INDEX and MATCH
  • Create basic macros
  • Use What-If Analysis for Goal Seek and Data Tables