Beginner to Pro ~ Excel Dynamic Array Formulas - FREE Class

Excel Dynamic Array functions are going to change the way to you work your data forever. Join me for this epic live event where I will demonstrate:

* What is so different about Excel's dynamic array functions
* The new # operator
* 6 important dynamic array functions - FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
* 25 practical examples of dynamic array functions for business analysis
* Your questions & answers

Sample data, completed example file & more for this lesson:
================================================
https://chandoo.org/wp/excel-da-free-live-event/
Timestamps:
===========
0:00 - Introduction & Welcome
4:30 - Tell me what you are drinking
5:15 - Example data explained
7:40 - What is dynamic array feature and how it differs?
12:20 - The FILTER function
28:00 - Using FILTER with other functions like SUM, COUNTIFS, VLOOKUP
33:00 - FILTER but show non-adjacent columns
40:22 - UNIQUE function
43:12 - UNIQUE with Text functions to generate alphabet frequency
47:12 - UNIQUE combinations
51:00 - SORT & SORTBY functions
53:10 - SEQUENCE function
55:20 - Using SEQUENCE to show top 10 countries by population
1:00:00 - RANDARRAY function
1:05:45 - Your Questions (refer to live chat messages)

#ExcelTips #DynamicArrayFunctions

Видео Beginner to Pro ~ Excel Dynamic Array Formulas - FREE Class канала Chandoo