Categories: Microsoft Excel online training coursesMicrosoft

Dynamic Arrays

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

Leave a Comment
Share
Published by
torocq
Tags: Microsoft Excel TrainingAdvanced Microsoft OfficeExcelDynamic Arrays
3 years ago

Recent Posts

Redesigning a Better Life

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

1 year 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…

2 years ago

MS Sharepoint – Users

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

6 months ago

Document Design in Word

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

2 years ago

MS SharePoint – Owners

SharePoint features are robust and complex. Site owners can determine which features and options to…

6 months ago