Excel for Analysts
Reliable lookups, conditional aggregation, cleanup and dynamic arrays.
Your route
- 01References
Learn the concept, complete a small practice task, then use it in a real-work example.
- 02XLOOKUP
Learn the concept, complete a small practice task, then use it in a real-work example.
- 03SUMIFS
Learn the concept, complete a small practice task, then use it in a real-work example.
- 04cleanup
Learn the concept, complete a small practice task, then use it in a real-work example.
- 05pivots
Learn the concept, complete a small practice task, then use it in a real-work example.
NO ACCOUNT REQUIRED
Start learningProgress stays in this browser
Complete lessons and challenges without creating a profile.