Bring your laptop to the workshop to follow along and utilize the Excel template provided. Pre-register for this session in the mobile app to receive the Excel template the night before to prepare for the workshop. 

In this hands-on session, you will learn how to leverage some of Excel’s most powerful and advanced functions to create a fully functional merit matrix from scratch. This step-by-step approach will not only help you understand the mechanics of these tools but also demonstrate how to apply them effectively in real-world scenarios. The session will cover the following essential functions and tools:

• XLOOKUP: A versatile function for searching and returning data across ranges.
• IFS: For creating multiple conditional statements in a single formula.
• INDEX (referencing multiple arrays): To extract data dynamically from multiple datasets.
• XMATCH: For advanced matching and positioning in your data.
• What-If Analysis: To model and analyze various scenarios and outcomes.
• Map Chart: A visualization tool to represent geographic or regional data.

By the end of the session, you’ll have a deeper understanding of how these tools work together and how to apply them to streamline and enhance your data analysis workflows.