Here is a comprehensive walkthrough guide for the Birthday Bonanza Solution Model provided by one of our faculty fellows, Carolyn Hamilton (Active Sheet). The case is available in your ExPrep account. Try it yourself, and if you get stuck, look for the solution in the videos.

TASK
You have agreed to be the teaching assistant for a new Excel Esports class at your school. The professor you are working for wants you to analyze the students’ birthdays for a grant they received that gives each student a cupcake on their birthday. To do so, you will need to parse the students’ data into a useable form, answer questions using that data, and then determine the cost of the cupcake program.
WALKTHROUGH VIDEO PROVIDED BY CAROLYN HAMILTON
MEWC
TAC
EEO