Interactive Excel practice for job seekers
Don't just watch videos. Practice real formulas and keyboard shortcuts in your browser, and get instant feedback on every mistake. Then take your Excel test with confidence.
Try it right now
Click B5 and type =SUM(B2:B4), then press Enter.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Sales | |||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | Total | |||
| 6 | ||||
| 7 | ||||
| 8 |
Tip: Start typing anywhere. The = sign tells Excel it's a formula.
Many employers check Excel skills before they hire. We teach exactly what those tests ask: lookups, conditional sums, clean references, speed.
Not just “wrong”. You see what your formula returned, what it should return, and which cell to look at, the moment you press Enter.
Real keyboard shortcuts on your own keyboard, with Mac and Windows variants. The speed interviewers notice.
Tell us when your interview or start date is. We split the course into a daily plan that fits.
Each lesson is a series of small tasks in a live spreadsheet. You can't move on until you've actually done it.
Finish with interview-style drills on realistic HR and sales data, then earn your certificate.
Instant, specific feedback
Forgot the dollar signs? Used TRUE instead of FALSE? Typed a number instead of pointing at the cell? ExcelReady spots the exact problem and tells you how to fix it.
C3 =B3*(1+F1)
Lock F1 with dollar signs ($F$1), so it doesn't move when you fill the formula down. Tip: press F4.
C2 shows #N/A. This means Excel couldn't find what you looked for. Check the ID in A2 and that the table range is right.
Short, hands-on and in order. Most take under 6 minutes.
Cells, navigation and the shortcuts every Excel test assumes.
Cells, rows and columns · Select ranges with Shift · Move around the sheet · Edit, clear and undo · Your first formulas · Jump to the edge of your data · Fill Down and Fill Right · Copy, cut and paste · Formatting shortcuts · More formatting · Skill check: basics
SUM, AVERAGE, COUNT, rounding and cell references.
SUM and AutoSum · AVERAGE, MIN and MAX · MEDIAN and MODE · LARGE and SMALL · COUNT, COUNTA and COUNTBLANK · ROUND, ROUNDUP and ROUNDDOWN · Percentages and % change · Relative vs absolute references ($) · Debugging SUM · Practice: department budget
IF, AND, OR, IFS and IFERROR.
TRUE, FALSE and comparisons · The IF function · AND, OR and NOT · Nested IF and IFS · IS functions and SWITCH · IFERROR
COUNTIF, SUMIF and their multi-condition cousins.
COUNTIF · SUMIF · COUNTIFS and SUMIFS · AVERAGEIF, MAXIFS and MINIFS · Wildcards and cell-based criteria · Practice and skill check: summary grids
VLOOKUP, INDEX/MATCH and XLOOKUP, the interview favorites.
VLOOKUP exact match · VLOOKUP approximate match · VLOOKUP practice · HLOOKUP for horizontal tables · INDEX and MATCH · INDEX/MATCH skill check · XLOOKUP · XLOOKUP wildcards and match modes · Fixing lookup errors
Clean, split and combine text data.
LEFT, RIGHT, MID and LEN · FIND and SEARCH · Joining text: &, CONCAT and TEXTJOIN · TEXT and VALUE: numbers to text and back · Cleaning messy text · TEXTBEFORE and TEXTAFTER · Text skill summary: clean a contact list
Build dates and calculate the time between them.
How Excel stores dates: DATE, YEAR, MONTH, DAY · Days between dates: DAYS, DATEDIF and TODAY · Renewals and month-ends: EDATE, EOMONTH, WEEKDAY · Dates in criteria: totals by date range and month · Workdays: NETWORKDAYS and WORKDAY · Date skill summary: gym memberships
UNIQUE, FILTER and SORT: modern Excel's power tools.
UNIQUE: list and count distinct values · FILTER: pull matching rows with a formula · SORT: order data with a formula · Modern Excel: XMATCH, SORTBY, TEXTSPLIT and spill references (A2#) · Pivot-style summary with formulas
Work across worksheets, then filter, highlight and summarize data with filters, conditional formatting and pivot tables.
Worksheets and cross-sheet references · Filter a table · Conditional formatting · Pivot tables 1 · Pivot tables 2
Realistic multi-step tasks like the ones in Excel tests.
Interview drill: HR roster · Interview drill: sales report · Case study: real estate listings · Case study: hospital admissions
Enter your date and we'll tell you exactly how many lessons to do each day to be ready in time.
Start free. Upgrade when you're ready for the whole course.
Free
$0
No card needed.
Monthly
$19.99/month
For an interview coming up soon.
Annual
$59.99/year
Just $5/month. Best value.
Lifetime
$149 once
Founding-member price. Pay once, no renewals.
Full refund if you ask within 30 days of your first payment. Cancel subscriptions any time.
No. Every lesson runs in a spreadsheet simulator in your browser. It behaves like Excel: the same formulas, references and keyboard shortcuts.
The course covers the skills those tests usually check: formulas, absolute references, COUNTIF/SUMIF, VLOOKUP, INDEX/MATCH, XLOOKUP, text and date functions. It ends with timed-style interview drills. No course can guarantee a result, but you'll walk in having actually done the tasks, not just watched them.
Both. Shortcuts switch automatically to match your computer, and you can toggle them any time.
The first lesson with no signup, the second with a free account, plus live practice on every function guide. Upgrade when you want the full course.
No. ExcelReady is an independent practice platform. Excel is a trademark of Microsoft.
Yes. If it isn't for you, email us within 30 days for a full refund.
We're building full-length, timed Excel tests modeled on common pre-employment formats, with a score report. Join the list and we'll let you know first.