Contact Us

Contact Us





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

    Dynamic Arrays have changed what's possible in Excel. The new functions -- FILTER, SORT, UNIQUE, XLOOKUP, and others -- replace complicated legacy approaches with something intuitive and remarkably capable. This Ottawa course gets you current on the features Excel 365 professionals are now building their workflows around. 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