Case 8: Final Mixed Assessment
This lesson is part of the course
In this lesson
Suggested time: 10 minutes for the order table and 10 minutes for the KPIs. You clean, look up, price and schedule 12 orders, then report three KPIs: eight graded cells, like a real assessment.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Case 1: Lookups with XLOOKUP, INDEX/MATCH and Tier Tables Locked
- Case 2: SUMIFS and COUNTIFS Report Locked
- Case 3: IF, IFS, AND and OR Logic Locked
- Case 4: Percentages, Growth and the Classic Traps Locked
- Case 5: Text Cleanup and Concatenation Locked
- Case 6: Date Calculations with EOMONTH, NETWORKDAYS and DATEDIF Locked
- Case 7: Pivot-Style Summary with Formulas Locked
- Case 8: Final Mixed Assessment Locked