Data Analytics with Excel
From raw rows to real answers
Go from opening a raw spreadsheet to answering real business questions with it. You'll work one running dataset, a pizza shop's sales, all the way from your first SUM to a single formula that pulls the historically correct price for any order. No prior analytics experience needed.
10 hours
Estimated time
16 exercises
Hands-on practice
12 functions
Excel functions covered
Certificate
On completion
What you'll be able to do
Clean, sort, and summarize a raw sales dataset with confidence
Look up values across multiple tables, even when the data isn't aligned
Use modern dynamic arrays (FILTER, UNIQUE, SORT) to slice data on the fly
Build point-in-time lookups that return the correct historical value
Combine FILTER and VLOOKUP into one formula that solves a real analytics problem
Full curriculum
Sign in to track your progress
Earn a verified certificate
Complete all exercises and pass the final assessment to earn a CellSkill certificate in Data Analytics with Excel. Share it on LinkedIn or with your employer.
Get started free