Dynamic Array Functions in Excel [Full Course]

When it comes to creating formulas in Excel, Dynamic Array Functions are a real game changer! They re-write the rules of formula creation, making once-complex formulas a snip to create. So if you're a user of Excel 365 or Excel 2021 and you want to make your life easier (and who doesn't!), this is a must-watch session In addition to the Dynamic Array Functions (listed below), I'll also show you how existing Excel functions and formulas can be used in a Dynamic Array. The Dynamic Array Functions covered in this session are: FILTER RANDARRAY SEQUENCE SORT SORTBY UNIQUE XLOOKUP ⏱ Timestamps 00:00:00 Introduction 00:00:34 What are Dynamic Array Functions? 00:02:20 UNIQUE 00:17:06 Using the # Symbol in Dynamic Arrays (Count values) 00:20:51 SORT 00:27:05 SORTBY 00:32:05 FILTER 00:41:32 SEQUENCE 00:49:01 RANDARRAY - Generate Random Numbers, Dates and Times 00:55:14 XLOOKUP 01:02:31 Using Standard Functions as Dynamic Array Functions ✅ Want more FREE training? Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk 🙋‍♂️ Let's connect on social Twitter:   / theexceltrainer   Facebook:   / theexceltrainer   LinkedIn:   / thomasmik   #excel #dynamicarrayfunctions #formulas