212-828-7089
Excel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on WordpressGoogle Places

Return to Excel

Excel 365 New Features

Excel 365 New Features

Excel365Learn the new features found in Excel 365. Our exclusive class is not taught anywhere else and was developed by a Certified Microsoft Trainer with 35 years of Excel experience. The only class with up to 15 interactive hands-on practice labs in class, plus homework to practice after class! The only class to offer a video of the instructor teaching the class to view from the comfort of your home.

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

Target Student: You use Excel daily and want to become more efficient and proficient. The class targets intermediate to advanced users.

class schedules

Course Schedules

January 30th 10am
February 9th 1pm
February 20th 1pm

registerLength: 4 Hours
Price: $195

 

Topics Include:

  • Xlookup
  • Spill
    • The Unique function
    • The Sort function
    • The Transpose function
  • Filter function
  • Ifs function
  • Switch function versus Ifs function
  • Sheet View
  • Workbook Statistics

Click here to download the 365 New Features slideshow

Frequently Asked Questions

frequently asked questions

  • What time does class start?
    Morning classes start at 10am
    Afternoon classes start at 2pm
  • Do I need to bring a computer?
    We provide a Windows computer.
  • Do I receive a certificate?
    Yes, upon completion you will receive an attractive gold foil certificate.
  • Are there any prerequisites?
    Ability to use a mouse and a keyboard.
  • Where are you located?
    31 West 34th Street. Near Penn Station, NJ Transit, and the N, Q, R, W, B, D, F, 1, 2, 3, A, C, E trains.

About The Instructor

Glenn Harris is a Microsoft Certified Technical Trainer and Office Master Instructor with 20 years of classroom experience. He has published many training manuals on Microsoft products. Excel Class is the only class that offers programmed self-assessment labs and online access to videos of Glenn teaching class (to himself).
microsoft certified trainer
microsoft office master
certified technical trainer

Select Corporate Clients

AIGAmerican ExpressColumbia UniversityDouglas EllimanGoldman SachsHarvard ClubMRM McCannNBCRalph LaurenUBSUnivision

Course Outline

pdf outlineDownload a PDF

  • Xlookup
    • Why Xlookup is better than Vlookup or Index and Match
    • When Vlookup or Index and Match is better than Xlookup
    • Xlookup to the right
    • Xlookup to the left
    • Xlookup last item
    • Xlookup across worksheets
    • Xlookup to return a contiguous array
    • Xlookup with two criteria
    • Xlookup an Xlookup to find an intersection in a PivotTable
  • Spill
    • The feature and the error
    • The Unique function
    • The Sort function
    • The Transpose function
  • Filter function
    • Include 1 criteria
      • text
    • Include 2 criteria
      • dates
    • Filter and Sort functions
    • Filter twice to display non-adjacent arrays
  • Ifs function
    • Why it is easier than nested If functions
  • Switch function versus Ifs function
  • Sheet View
  • Workbook Statistics