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

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

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, which were released in August 2022.

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!

At the end of the course, learners will be able to:

This course will benefit people who:

• Already have advanced Excel knowledge
• Are advanced Excel users who require to use a lot of formulas and functions to solve their work problems
• Are advanced or expert Excel users who want to learn higher-level functions in Excel 365 Dynamic Arrays

*Note: This course is not intended for basic Excel users.

This is a hands-on practical course. Our trainer will walk you through each topic step-by-step. Those undergoing our Power Query training will also be provided with exercise files to practice the application methods at every stage. A short Q & A  session will be available after each topic.

*Note: This course is not intended for basic Excel users.

To undergo our Excel 365 – Dynamic Arrays and Power Functions training course, you will need to be:

• An intermediate Excel user who already have Excel formulas and functions working knowledge
• Proficient in  advanced Excel formulas and functions skills or an advanced or expert Excel user.
• Software Requirement: Office 365 installed

Below are the list of things to prepare for the Excel 365 Series 1 – Dynamic Arrays and Power Functions course:

• PC/Windows operating system laptop with Office 365 Microsoft Excel installed
• Laptop power adaptor
• USB mouse (optional)