Contact Us

Contact Us





    New functions in Excel 365 1 Day | 6 hours | $425 PLUS TAX

    The new Excel functions -- FILTER, SORT, UNIQUE, XLOOKUP -- have changed how Toronto Excel users build their spreadsheets. This course replaces the workarounds you've been using with modern approaches that are cleaner, more flexible, and significantly more powerful. Essential for anyone on Excel 365. Prerequisite: Knowledge of Excel 2

    Primary benefits of Dynamic Array formulas:

      • » Shorter formulas; easier to use and understand; more efficient

     

      • » Multiple results are returned to a “SPILL” range which is dynamic and will continually adjust to accommodate new or changed data

     

      » Only one formula needs to be entered; no replication is necessary

    Functions covered in this course

    • SORT/SORTBY
    • TEXTJOIN
    • SWITCH
    • XLOOKUP
    • FILTER
    • UNIQUE
    • SEQUENCE
    • RANDARRAY

    You will benefit most from this course if you:

      • » Are a good intermediate or advanced user of Excel

     

      • » Do a lot of LOOKUPS, or DATA FILTERING

     

      » Need your results to be dynamic, i.e. will automatically recognize new or changed data without having to manage multiple, complex formulas