1. 1. Meet the grid

   Find your way around cells, rows and columns.

   2 min

2. 2. Enter data

   Type text and numbers, then confirm with Enter and Tab.

   3 min

3. 3. Edit and undo

   Fix mistakes with F2, Delete and Ctrl+Z.

   3 min

4. 4. Move around fast

   Jump through long lists with Ctrl+Arrow and Ctrl+Home.

   2 min

5. 5. Select ranges

   Select blocks of cells with Shift, the mouse and the keyboard.

   3 min

6. 6. Copy, cut, paste

   Move and duplicate cells with Ctrl+C, Ctrl+X and Ctrl+V.

   3 min

7. 7. AutoFill

   Let the fill handle type dates, days and number series for you.

   3 min

1. 8. Your first formula

   Add, subtract, multiply and divide with =.

   4 min

2. 9. SUM

   Total a whole column in one formula.

   3 min

3. 10. AVERAGE

   Find the typical order with AVERAGE.

   3 min

4. 11. MIN and MAX

   Find the best and slowest day.

   3 min

5. 12. COUNT and COUNTA

   Count orders, paid and unpaid.

   3 min

6. 13. Copy formulas down

   Write a formula once and fill it down every row.

   4 min

7. 14. Absolute references

   Lock a cell with $ so every row uses the same rate.

   4 min

8. 15. Order of operations

   Use brackets so formulas calculate in the right order.

   4 min

1. 16. Number formats

   Show prices as currency and margins as percentages.

   3 min

2. 17. Dates

   Fix dates that show as numbers and use TODAY.

   4 min

3. 18. Sort

   Rank products by sales with Sort.

   3 min

4. 19. Filter

   Show only the rows you need with AutoFilter.

   3 min

5. 20. Formatting basics

   Bold, borders, column widths and freeze panes.

   4 min

1. 21. IF basics

   Make the sheet decide with IF.

   4 min

2. 22. AND / OR

   Combine conditions with AND and OR inside IF.

   4 min

3. 23. Nested IF and IFS

   Give each sales rep a grade A, B or C.

   5 min

4. 24. COUNTIF

   Count only the rows that match a condition.

   4 min

5. 25. SUMIF

   Add up only the rows that match a condition.

   4 min

Coming to Premium

• Lookups

  VLOOKUP, XLOOKUP and INDEX/MATCH: find anything in a table.

• Text & Dates

  Split, join and clean text; date math, workdays and validation.

• PivotTables

  Summarize thousands of rows in seconds.

• Charts

  Pick the right chart and make it clear.

• Dynamic Arrays

  FILTER, SORT, UNIQUE, LET and what-if analysis.

• Power User

  LAMBDA, Power Query and speed shortcuts.

• Job Tracks

  Real scenarios for finance, marketing & sales, operations and HR.

• Interview Prep

  Timed Excel tests, a case study and a final exam with a certificate.