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 new 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 of class.

Topics: Download The PDF

*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. This course requires users are comfortable nesting 3-6 functions in a formula.

Excel New Features Topics:

• Functions:
  • Xlookup:
    • Xlookup Basics
    • Xlookup Last And Left
    • Xlookup With Named Ranges
    • Xlookup Twice Across 3 Tables
    • Xlookup Arrays
    • Filter An Xlookup Array
    • Xlookup Twice For Intersections 
  • Unique
  • Sort
  • Filter
  • ChooseCols
  • Transpose
  • TrimRange
  • Aggregate
  • GroupBy
  • Hstack / Vstack
  • Drop
  • PivotBy
  • PercentOf
  • TextSplit and TextJoin
  • Checkbox
  • Image
  • Sequence
  • Lambda 
  • Let 
  • And more!
• Power Query:
  • Power Query Editor Benefits
  • Open The Power Query Editor
  • Get Data: Import Excel Data To Open The PQE
  • Backup A Query
  • Strategies For Updating The Query Next Month
  • Update The Data Source
  • Append New Data
  • Use The Data Model To Merge Queries
  • Get Many Files From A Folder
  • Data Profiling Tools
  • Group By
  • Parameter Queries
  • Query Naming Conventions