2-Day Excel 365 Dynamic Arrays Series 1 - Power Functions Course (Exclusive Course)

This course is created, owned and trained by Mr. Alaster Leong. Learn from the original creator of this course.

Important Note: 

Please check the following before registering:

• The guide to check Excel 365  here.

The addition of Excel Dynamic Array functions is a long-awaited and greatly appreciated change. Despite many changes to Microsoft Excel over the years, one thing has remained the same – one formula, one cell to get the result.

With dynamic array formulas, multiple results will be returned and automatically spill to a range of cells, whereas in old array formulas, multiple results must be copied to many cells. This makes the new Excel Dynamic Arrays extremely powerful and versatile, with numerous potential applications. With this ability, existing functions that return only one single value can now return multiple values and perform magic!

Plus, the output is always dynamic; whenever the source data changes, the results update automatically. Delete and insert rows in old array formulas range is not possible without first deleting all existing formulas; with dynamic arrays, you can insert and delete rows without any problems! They are unquestionably valuable additions to the Excel formulas toolbox!

This Excel 365 Series 1 – Dynamic Arrays and Power Functions course will also take you through the basic of Excel LAMBDA, which enables you to create your own Microsoft Excel custom function without writing any code, and how you can use it within the workbook, as well as a recursive LAMBDA that loops through cells to replace multiple values. In addition, it will also cover some of the recent Excel 365 functions.

Dynamic arrays are the most significant change to Excel formulas in years, changing the way we use functions and formulas. A variety of tasks that were traditionally difficult are now easily accomplished with the new dynamic arrays.

In Excel 365, array formulas became much more straightforward and understandable for all users. The old array formulas are kept for compatibility, but it is now recommended to use the new ones.

Excel dynamic array formulas simplify many complex tasks, and we believe that many Excel users will love them as much as we do! You’ll never want to go back once you’ve seen how the new dynamic arrays work!