Name
Excel Masterclass: Building a Merit Matrix with Advanced Functions and Real-World Applications
Date
Monday, May 19, 2025
Time
1:15 PM - 2:30 PM
Session Format
Workshop
Description

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.