This session is designed for finance professionals looking to enhance their Excel skills with the latest functions. You’ll learn how to leverage these powerful tools to streamline your workflow, improve data analysis, and make more informed decisions. By the end of this course, you’ll be equipped with the knowledge to use these functions effectively in your daily tasks.

Topics Covered

• Introduction to the New Dynamic Array Functions: Understanding the revolutionary change in calculations
• Data Management Functions: Organizing, cleaning, and managing data with new dynamic array functions
• Advanced Lookup Functions: Replacing VLOOKUP, INDEX, and MATCH with a new generation of tools
• Understanding LAMBDA: Custom function development