Return to Excel Training

Intermediate to Advanced Excel

Intermediate to Advanced Excel Training

Advanced ExcelAdvanced Microsoft Excel training is for those familiar with basic Excel concepts that inlcude the following prerequisites:

  • Sum
  • Absolute References
  • Vlookup
  • SumIfs 1 Criteria
  • Sort and Filter
  • Freeze Panes

Advanced Excel training includes a printed 85 page manual. Each student works on a Windows computer with Excel 2020.

Length: 1-day;
Sale Price: $279

class scheduleSchedule:
October 21st
October 29th
November 12th


The objectives of the advanced Excel class include:

  • Keyboard Shortcuts
  • Advanced Excel Formulas: Named Ranges, Vlookup, Index/Match, If, SumIf, IfError
  • Formula Auditing
  • Data Analysis with Pivot Tables
  • Automate Excel with Macros
  • Database Validation and Extract Unique Values

class outlineAdvanced Excel Outline

Contact Us

Call: 212-729-7216

Question / Comment

Frequently Asked Questions

Where are you located?
Our classes are taught at 225 West 34th Street and are convenient to Penn Station. Corporate classes are also taught on-site.
How long is the class?
Weekday classes begin at 9am, weekend classes begin at 10am. There is a 40-50 minute lunch break. The ending time is variable.
Do I need to bring anything?
The class provides a computer and printed notes along with a pen and snacks. You may bring lunch or purchase it nearby.

Intermediate to Advanced Excel
Excel Training, 31 West 34th Street,New York City,New York-10001
Starting on
October 21, 2021
Ending on
October 21, 2021
Intermediate to Advanced Excel
Offer Price
USD 279