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

Microsoft Planner

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

4 weeks 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

Project Management Quickstart

In this introductory course, students learn all of the basics of project management. Perfect for…

3 years ago

MS Sharepoint – Users

In this hands-on course, we will demonstrate and practice the essential skills you need to…

9 months ago

Document Design in Word

A well-designed document reflects well on you because a good page layout makes any document…

3 years ago