This module teaches you to master spreadsheet lookups for professional-grade data analysis. You will first learn the core mechanics of VLOOKUP and INDEX/MATCH, understanding why accuracy is critical through real-world case studies of costly errors. You will then move from theory to practice, developing a systematic process for debugging formulas and handling common lookup failures. This ensures you can confidently retrieve and map data with precision, guaranteeing your datasets are accurate and reliable every time.

This module teaches you to build professional spreadsheets for collaboration. First, you will learn to use strategic formatting and industry-standard color-coding, transforming complex models into intuitive, auditable tools. Then, you will master worksheet protection to safeguard your model's integrity. You will practice locking critical formulas to prevent errors while leaving designated input cells open for users. This ensures your spreadsheet is not only accurate but also robust, user-friendly, and secure—making it a professional tool ready for any shared work environment.

This module teaches you to build professional-grade Excel workbooks that are reliable, auditable, and repeatable. You will move beyond simple calculations to master robust functions, correct cell referencing, reliable lookups, and worksheet protection. The project challenges you to create a trustworthy financial or operational model that prevents common errors and can be safely used by decision-makers. By delivering a clean, well-documented workbook, you will prove to employers you can create analysis that stands up to review and demonstrates a high level of technical skill and operational maturity.