Dynamic Arrays Functions in Excel 365

Course Outline:

  • The concept of Dynamic Array Functions.
  • Classic Functions inherit the dynamic array behavior
  • Main Functions► UNIQUE, FILTER, SORT, SORTBY, RANDARRAY, SEQUENCE, XLOOKUP
  • Data Validation with Dynamic Arrays
  • Charting with Dynamic Arrays
  • LET function, LAMBDA and LAMBDA helper functions.
  • New TEXT Functions
  • The Advanced Formula environment.
  • Building 2 Amazing projects using Dynamic Arrays.

With the course you receive:

  • Practice files
  • Multiple resources and references.
  • Lifetime access to the course recording
  • Certificate of Completion
  • Regular price: USD 140.00 – Sale Price: USD 99.00

Course Price

Sale Price: USD 99.00
Regular Price: USD 140.00
*You will be charged the equivalent in Canadian Dollars
Equivalent price in Canadian Dollars is
Regular 182 CAD - Sale Price 129 CAD
Upcoming Course Date:
Saturday, 30 Apr 2022 (Fully Booked)

Saturday, 28 May 2022 (Fully Booked)

More dates coming soon
Start Time: 9:00 AM (EST)

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.