Skip to content

Learning paths

Three learning tracks, from your first formula to loans and lookups. Each is a sensible order of hands-on exercises.

Beginner: Excel Foundations

Cell references, totals, percentages, counting, rounding and your first IF formulas: everything you need before the harder tools.

14 exercises

  1. Your First Formula Beginner
  2. Invoice Total with Cell References Beginner
  3. Total, Average and Highest Monthly Spend Beginner
  4. Row and Column Totals in a Sales Table Beginner
  5. Commission with One Rate Cell Beginner
  6. Sale Price After a Percentage Discount Beginner
  7. Percent Change and Share of Total Beginner
  8. Count Survey Responses with COUNT and COUNTA Beginner
  9. Rounding Prices and Whole Boxes Beginner
  10. Has the Sales Target Been Met? Beginner
  11. Free Shipping and Review Flags with AND and OR Beginner
  12. Clean and Combine Names with TRIM and PROPER Beginner
  13. Split Product Codes with LEFT, RIGHT and LEN Beginner
  14. Due Dates and Days Overdue Beginner
Start this path

Intermediate: Conditions, Lookups and Text

Conditional sums and counts, lookups, tiers, error handling, text and dates: make a sheet answer questions on its own.

18 exercises

  1. Total Revenue for One Region Intermediate
  2. Average Order Value with AVERAGEIF and AVERAGEIFS Intermediate
  3. Largest and Smallest Deals with MAXIFS and MINIFS Intermediate
  4. Count Support Tickets with COUNTIF and COUNTIFS Intermediate
  5. Look Up a Product's Price Intermediate
  6. Volume Discount Tiers with IFS Intermediate
  7. Typical Salary: AVERAGE, MEDIAN, LARGE and SMALL Intermediate
  8. Sales Leaderboard with RANK Intermediate
  9. Split Email Addresses into Username and Domain Intermediate
  10. Format Numbers and Dates as Text with TEXT Intermediate
  11. Clean Imported Amounts with TRIM, SUBSTITUTE and VALUE Intermediate
  12. Find an Employee by ID with XLOOKUP Intermediate
  13. Handle Missing Prices with IFERROR Intermediate
  14. Flag Bad Data with ISBLANK and ISNUMBER Intermediate
  15. Employee Tenure in Years and Months with DATEDIF Intermediate
  16. Subscription Renewal Dates with EDATE and EOMONTH Intermediate
  17. Build a Region by Product Sales Summary with SUMIFS Intermediate
  18. Profit and Margin by Product Intermediate
Start this path

Advanced: Lookups, Finance and Analysis

Two-way lookups, loans and investments, weighted figures and distinct counts: the formulas behind real business reports.

9 exercises

  1. Look Up a Shipping Rate with INDEX and MATCH Advanced
  2. Sales Between Two Dates with SUMIFS Advanced
  3. Weighted Average Price with SUMPRODUCT Advanced
  4. Who Sold the Most? INDEX, MATCH and MAX Advanced
  5. Shipping Rate Bands with INDEX and XMATCH Advanced
  6. Count Distinct Customers with UNIQUE and FILTER Advanced
  7. Monthly Loan Payment and Total Interest with PMT Advanced
  8. Savings Goal: Future Value with FV Advanced
  9. Is the Project Worth It? Net Present Value with NPV Advanced
Start this path