Learn Microsoft Excel Office 365 advanced formula tricks that most people don't know.

Sign up to get updates, practice files and code snippets http://eepurl.com/hwyGg1

00:00 Initial Spreadsheet Data Setup
01:50 UNIQUE, VALUETOTEXT, FILTER functions
03:50 SUMIFS with Dynamic Arrays
07:35 SORT, LET, CHOOSE
11:40 INDEX Dynamic Arrays
13:20 XLOOKUP with Dynamic Arrays
15:20 TRANSFORM
16:20 SUMIFS with 2 Dimensional Dynamic Arrays

#excel #advanced #tutorial