All tracks
Data analyst interview prep
Focused data analyst interview prep covering the Excel workflows often tested in real assessments.
Advanced 5 exercises
0 of 5 completed 0%
Exercises in this track
1
Remove duplicate customer records
Use COUNTIF with an expanding range to mark which customer records to keep and which repeats to remove.
COUNTIF IF COUNTIFS
2
Build a basic cohort retention table
Build a customer cohort retention grid by counting each signup cohort and calculating what share stayed active in later months.
COUNTIFS COUNTIF SUMIFS
3
Funnel conversion analysis
Calculate conversion rates between each stage of a marketing funnel, plus overall conversion and stage-by-stage drop-off rates.
IFERROR ROUND SUMIFS
4
Pareto analysis (80/20)
Build a complete Pareto analysis ranking defect categories by frequency with cumulative percentages and 80/20 classification.
RANK SUM IF
5
A/B test results analysis
Compare two experiment variants by calculating conversion rates, percentage lift, standard errors, and a significance decision.
SQRT ABS IF