12 interactive exercises

Excel Beginners Practice Lab

Work through twelve extra spreadsheet tasks, from payroll calculations to a VLOOKUP employee directory. Each one runs in the browser with the same answer checker, hints and saved progress as the rest of ExcelForAll. Each card shows whether it needs an account or a paid plan.

The exercises adapt the concepts from the original workbooks to this site's single-sheet grid. Open any task below, or browse the full exercise course.

1. 01BeginnerBasic Formulas7 minNo account needed

   Calculate gross and net pay in a payroll

   Use salary, allowances and deductions to calculate gross pay and net pay for four employees.

2. 02IntermediateCell References7 minFree account

   Calculate salary increase scenarios

   Use absolute references to apply three pay increase rates across several employee rows.

3. 03BeginnerSUM and AVERAGE5 minFree account

   Consolidate eight weeks of sales

   Total eight weekly sales columns for each employee with one SUM formula per row.

4. 04IntermediateSorting and Filtering7 minPaid plan

   Sort bonuses and total by department

   Sort an employee bonus table by department and use SUMIF to total Admin and HR bonuses.

5. 05BeginnerText Functions5 minFree account

   Clean customer names with TRIM and PROPER

   Repair inconsistent spacing and capitalisation in customer names with two text functions.

6. 06AdvancedIF and Logic10 minFree account

   Build a student grading board

   Calculate each student's average, pass status, class rank and letter grade with formulas.

7. 07IntermediateCharts7 minPaid plan

   Total deposits and build a column chart

   Add three deposit types for each region and chart the regional totals in a column chart.

8. 08BeginnerDescribing Data5 minPaid plan

   Analyse deposits with MAX, MIN and LARGE

   Find the highest, lowest and second-largest savings values from a regional deposit table.

9. 09IntermediateCOUNTIF and SUMIF5 minFree account

   Audit duplicate account numbers

   Use COUNTIF with a locked range to find repeated account IDs in an employee list.

10. 10IntermediateIF and Logic7 minFree account

    Audit trainee records against rules

    Use IF, AND and OR to flag trainee rows that break age or category rules.

11. 11BeginnerText Functions4 minFree account

    Join first names and surnames

    Combine two name columns into a full name with CONCAT and a space between the words.

12. 12IntermediateLookup Functions6 minPaid plan

    Build an employee VLOOKUP directory

    Use an employee ID to look up a name and location from a small staff directory.

Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz, licensed under MIT. License text.