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
torocq

Recent Posts

MS Teams – Essentials

Communication is one of the biggest keys to success in the workplace. Microsoft Teams offers…

1 month ago

MS Teams – Quickstart

No question, the speed of work has increased exponentially. Whether you work remotely or in…

1 month ago

Microsoft Power Automate

If you are looking to streamline repetitive tasks and processes, you can use Microsoft Power…

1 month ago

Microsoft Planner

With Planner you and your team can to create plans, assign tasks, chat about tasks,…

3 months ago

Redesigning a Better Life

Redesigning a Better Life is about creating your own unique path and living a more…

2 years ago

Adobe Premiere Pro – Quickstart

Creating short videos is becoming an indispensable skill. In this one-day workshop, you will learn…

2 years ago