1704x Apr 2026

Students in this module move beyond basic cell formatting to advanced analytical functions. 1. Optimization Modeling

Identifying patterns in data over time to predict the next quarter’s sales. 3. Spreadsheet "Wizardry" Students in this module move beyond basic cell

The course demands a high proficiency in Excel, specifically: for data retrieval. Pivot Tables for rapid data summarization. Students in this module move beyond basic cell

Using tools like Excel Solver to find the "best" outcome (e.g., maximizing profit or minimizing cost) given specific constraints. Students in this module move beyond basic cell

Case studies often involve logistics, finance, and marketing scenarios.

It forces students to deconstruct a messy problem into a structured spreadsheet model.

Understanding the relationship between different variables.