MECC June Weekend Battle '25 - Walkthrough by Brittany Deaton - Collecting Scarves (V) скачать в хорошем качестве

MECC June Weekend Battle '25 - Walkthrough by Brittany Deaton - Collecting Scarves (V)

Join Brittany Deaton, AVP, Finance Technology at Unum, Excel Esports Player as She guides you through the Benjamin Weber's Collecting Scarves Case from the 2025 MECC June Weekend Battle (Varsity Level). This comprehensive tutorial is perfect for students looking to enhance their Excel skills and confidently tackle challenging cases. 00:00 Intro – what the “Collecting Scarves” case is about 00:11 Quick walk‑through of goals & dataset 01:50 Data prep – turn raw sheets into Tables (Scarf, Colors) 02:17 Level 1 | City lookup with XLOOKUP 02:58 Level 2 | Travel to one city: distance = 100 × √(Δx²+Δy²) + €15 05:26 Level 3 | Three‑city route: sum distances, add scarf prices 08:58 Manufacturing section begins 09:02 Level 4 | Count a specific colour using LEN‑SUBSTITUTE 12:11 Level 5 | Same count for all scarves in a chosen city (FILTER) 14:10 Level 6 | Manufacturing cost for 3 scarves → SUMPRODUCT + $200 setup each 18:30 Level 7 | Compare “travel & buy” vs “manufacture”; return the cheaper 21:14 Bonus intro 21:17 B1 – City that hosts the most scarves 23:01 B2 – Scarf code that appears most often 24:47 B3 – How many scarves start with blue (B) 25:13 B4 – City whose scarves contain the most red elements 27:08 B5 – Cost to manufacture all 100 scarves