Course ID: DHPE
About & Customize
Popular Options
Are you looking to take your Excel skills to the next level and solve complex data analysis and reporting problems more efficiently? This course on Excel’s dynamic array functions will help you master these powerful new functions and transform your workflow. You’ll learn how to use functions like UNIQUE, SORT, FILTER, and SEQUENCE to extract, sort, and reference data, as well as how to use the spill operator to reference dynamic arrays. Upon completion of this course, you’ll have the awareness, the skills and confidence to apply dynamic array functions to real-world problems and create sophisticated data analysis and reporting solutions.
Upon completion of this course participants will be able to:
1. Identify the appropriate dynamic array function to use for different data analysis and reporting tasks.
2. Use the dynamic array functions to extract, sort, and filter data.
3. Use the spill operator to reference dynamic arrays.
4. Confidently apply your knowledge of dynamic array functions to solve real-world problems and create sophisticated data analysis and reporting solutions.
All business professionals that use Excel on a regular basis. Dynamic arrays are new(er) functions provided in the later versions of Excel that make many calculation tasks previously done far easier to accomplish. If you are looking to stay current with Excel’s latest capabilities, this is a course for you!
Regular use of Excel and knowledge of using functions to perform calculations in Excel would be helpful.
This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.
To get started, contact BLI:
(888) 777-7077
team@blionline.org