All modules
Excel Skills
The spreadsheet round real campus placements actually run.
Formula Challenges spans 8 full topic tracks, and Pivot Tables & Data Analysis grades a whole summary grid at once - both graded by actually running your formula against real sample data through an original formula engine, never by matching text.
What's inside
Core & Aggregation
SUM, AVERAGE, COUNT/COUNTA, MAX/MIN, ROUND.
Logical & Conditional Totals
IF / IFS / AND / OR, and the -IF / -IFS family (COUNTIF, SUMIF, SUMIFS).
Lookup & Reference
VLOOKUP, HLOOKUP, XLOOKUP, and INDEX + MATCH.
Text, Date & Time
LEFT/RIGHT/MID, TRIM, TEXTJOIN, SUBSTITUTE, FIND, plus DATEDIF, EOMONTH, NETWORKDAYS and more.
Math & Statistics
ROUNDUP/DOWN, MEDIAN, STDEV, RANK, PERCENTILE, SUMPRODUCT.
Dynamic Arrays & Financial
UNIQUE, SORT, FILTER, SEQUENCE, plus PMT, FV, PV, NPER, NPV.
Pivot Tables & Data Analysis
Fill in a whole row × column summary grid at once, graded cell by cell against real data - the way an actual pivot analysis is checked.
How it's graded
A small, original formula parser/evaluator (not a third-party library) actually computes your formula's result and compares it to the real answer - the same standard Coding Challenges holds submissions to.
Ready to try Excel Skills?