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.