EVENT DESCRIPTION

  • This is a Live Online event where you get to work hands-on with the instructor using supplied data

COURSE DESCRIPTION and TOPICS:

Microsoft 365 bring enormous power to your fingertips with its range of Dynamic Array functions and the Dynamic Array capability that can be extended to existing legacy functions. If you build spreadsheet models and calculators, or use spreadsheets to analyse substantial amounts of data, then this workshop can potentially be a game changer for you.

  • Briefly revise the concept of range names its role in advanced formulas
  • Introduction to Arrays, Array constants, and the New Dynamic Arrays in Office 365
  • Examining how Dynamic Array formulas work with legacy functions in Office 365
  • Exploring the Power of some of new Functions with Dynamic Arrays in Office 365
    • FILTER – use logic statements for dynamic filtering of large data
    • UNIQUE – create lists from arrays and combine with legacy functions
    • SORT and SORTBY – create lists from arrays with ease
    • CHOOSECOLS and CHOOSEROWS – combine these with other functions
    • TEXTSPLIT for splitting text across columns and rows with multiple delimiters
    • SEQUENCE – for creating sequences of numbers within rows and columns
    • VSTACK – Create dynamic stacked datasets for use with other formulas
    • LET – The function to reduce calculation instances in one formula
    • LAMBDA – The function to create your own functions
  • We will cover more functions if there is time available

WHO WILL BENEFIT:

Those wishing to increase their proficiency in Microsoft Office with the convenience of taking courses at their own location.

SPECIAL INSTRUCTIONS

  • Two hour, Live, Instructor-led online webinar workshop with hands-on practice and instruction.
  • Essential requirements are a Computer with broadband internet access, audio headset or speakers and working copy of Microsoft Office 365. Microsoft Office Starter Edition will not be adequate.
  • Office 365will be used in the demonstration of techniques of this workshop.

LOCATION