MEWC
FMWC
TAC
EEO
TASK 1
In “Excel Battlefield”, you take on the role of a commander. Every level consists of 20 distinct battlegrounds, each with an initial power for your army and specific power levels for the 20 enemy armies you’ll face. After the battle your army’s power increases by adding the power of the defeated enemy army. The objective is to calculate and predict the outcomes of each battleground based on the provided scenarios. Performance is assessed through required fields in each level, with some levels also featuring bonus questions.
WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY
Solving the case with Dynamic Arrays
WALKTHROUGH VIDEO PROVIDED BY LORENZO FOTI
This is his live attempt to solve the case.
TASK 2
While it seems like classes just started after summer break, it is almost time to start enrolling for next semester. Several of your friends have asked for help in understanding their class schedules. To help them, build a model to analyze their course schedules and give them key information such as the earliest start time, total hours in class, and whether they have any scheduling conflicts.
WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY
WALKTHROUGH VIDEO PROVIDED BY EXCEL WIZARD