Learn Excel’s new features in Excel 365

Our exclusive class was developed by a Certified Microsoft Trainer with 38 years of Excel experience.

A New Way To Work With Excel Spreadsheets

The features and functions taught in this class will help you create dynamic reports that require much less daily, weekly, or monthly maintenance. Less work to update your reports and more time to analyze the results!

The only class with more than 15 interactive hands-on practice labs in class, plus homework to practice after class! 

Format: In person (New York City) or virtual online.

Target Student: You use Excel daily and want to become more efficient and proficient. 

Includes: Notes, hands on practice exercises, unlimited access to videos for review.

*Note: This course requires an intermediate to advanced knowledge of Excel. Preferably you have already taken our 24 Hour Excel Class Online, or are familiar with all the concepts covered in that course.

Topics Covered Include:

• Learn to Extract, Transform, and Load your report data with the Power Query Editor.

• Xlookup: 2 Hours!
  • Xlookup Basics
  • Xlookup Last And Left
  • Xlookup Twice Across 3 Tables
  • Xlookup Returns Many Columns
  • Filter An Xlookup
  • Xlookup Twice For Intersections
• Functions: 4+ Hours!
  • Unique function
  • Sort and SortBy function
  • Filter function
  • Transpose function
  • Aggregate function
  • GroupBy function
  • Hstack / Vstack function
  • Drop function
  • ChooseCols function
  • PivotBy function
  • PercentOf function
  • TextSplit and TextJoin function 
  • Image function
  • Sequence function 
  • Let function 
  • And more!

Our NYC Training is either in person or online.