Learn 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 Report Data

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.

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

Our NYC Training is offer in person or online.