Master NEW Excel Functions in Office 365 & Office 2021

 

Learn to Use Excel's NEW Functions (FILTER, UNIQUE, SORT, XLOOKUP...) to Dramatically Simplify the Work You Do in Excel.

What you'll learn

  • Master Excel's NEW Formulas (FILTER, UNIQUE, XLOOKUP, SORT, SORTBY, SEQUENCE, RANDARRAY & More Dynamic Array Functions)
  • Learn how to think outside the box to solve ANY Excel challenge you come across
  • Be the FIRST to unlock the power of Microsoft Excel’s BRAND-NEW calculation engine
  • Add INTERACTIVITY to your Excel reports as NEVER seen before (Create Pivot Table style reports, without using Pivot Tables)
  • Maximize the NEW potential in Excel and learn how to apply the new DYNAMIC ARRAYS Formulas to make YOUR files better
  • Get lifetime access to a proven and State-Of-The-Art Excel course including challenges, quizzes & exercises

This course includes:

  • 7 hours on-demand video
  • 17 articles
  • 30 downloadable resources
  • Access on mobile and TV
  • Certificate of completion

Requirements

  • You HAVE Microsoft 365 & the NEW Excel Dynamic Array formulas (see the 3rd Preview lecture)
  • You currently use Excel and are familiar with SUM, IF & VLOOKUP functions
  • MAC USERS: Excel Dynamic arrays are also available in Excel for Microsoft 365 for Mac. Please note: The course is taught for Excel on Windows. If you have a Mac, I wouldn't be able to help you if you run into problems.

Course link - https://bitli.in/Sm6F7BN  


Comments