Key Information
Excel Level 3
$219 7 Hours
Overview
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
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
Scheduling Options
Weekdays, weeknights, or weekends
Next Start Date
April 24, Saturday, 10–5pm
Certification
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Discounts See our discounts policies for more details
  • Shorter courses such as this are already affordably priced and are not eligible for discounts.
Payment Plan See our payment plan FAQ for more details
Target Audience

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
  • 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

Add Class or Certificate to Compare