OfficeDrills
🔒 Report Day is included with Microsoft Excel. See pricing below →
Productivity

Microsoft Excel

Practice real Excel workflows — writing SUM, VLOOKUP, IF, SUMIF, SUMIFS, and COUNTIF formulas, choosing the right formula for a goal instead of being told which one to use, fixing a fill-down reference bug, and debugging a broken formula — in a hands-on spreadsheet training simulation.

Educational practice environment — not affiliated with, endorsed by, or sponsored by Microsoft.

Options
Lesson 1 is free in every option. You'll enter your email first — no password. $20 unlocks the rest of Beginner or Advanced · Crash Course is $10.
Start here Beginner Every step spelled out, including what each screen and field actually means. For anyone who's never opened Microsoft Excel before. Start Beginner — free lesson 1 → Advanced The full real-world workflow with less hand-holding. Best if you've used it before or pick up new software fast. Start Advanced — free lesson 1 → Crash Course Four of the Advanced lessons — the highest-value tasks in the same real workflow. Built for brushing up before an interview. Start Crash Course — $10, free lesson 1 →
What you'll practice
Worksheets & Workbooks
  1. Freeze the Header Row
  2. Rename and Color-Code a Sheet Tab
  3. Protect a Finished Sheet from Edits
  4. Fit a Wide Sheet to One Printed Page
Formulas & Functions
  1. Sum a Column with a Formula
  2. Decide the Best Way to Exclude a Category
  3. Fix a Formula That Breaks When Filled Down
  4. Look Up a Price with VLOOKUP
  5. Flag Values with an IF Formula
  6. Decide Between a Count and a Total
  7. Total a Category with SUMIF
  8. Add a Second Condition with SUMIFS
  9. Fix a Broken Formula
Cells & Ranges
  1. Highlight Overspending with Conditional Formatting
  2. Remove Duplicate Entries from a List
  3. Name a Range for Easier Formulas
Tables
  1. Convert a List into a Table
  2. Use the Table Total Row
Charts
  1. Create a Chart to Compare Categories
  2. Add Data Labels to a Chart
Drills & Projects
Drill Data Cleanup Day → Six real spreadsheet tasks, on an actual grid, sortable table, and chart — a VLOOKUP that quietly returns the wrong row, a sort that scrambles pairs, Remove Duplicates deleting someone real, and more. 🔒 Included with Microsoft Excel Drill Off the Sheet → Six real workbook-structure tasks, on an actual sheet, table, and tab strip — a stale Print Area, sheet protection locking the wrong cells, a range that isn't really a Table, a forgotten hidden sheet, and more. 🔒 Included with Microsoft Excel Drill Ready to Send → One real Excel workbook, six tabs open at once — no numbered tasks. A filtered report's inflated total, a number stored as text, a stale cross-sheet reference, and more, in whatever order you find them. Included with Excel. 🔒 Included with Microsoft Excel Drill Report Day → Six real Excel tasks, on an actual sheet, pivot, and file list — a pivot that never refreshed, dates that came in day-first, a lookup that misses identical-looking names, IDs that lost their leading zeros, and more. 🔒 Included with Microsoft Excel Drill Sheet Audit → Six real Excel tasks, on an actual sheet — hidden rows that come along in a paste, a highlight rule that marks the wrong rows, a validation rule that pasting bypasses, a bonus formula that misses the threshold, and more. 🔒 Included with Microsoft Excel
← Back to all courses