Guided Excel projects

A lesson teaches one function. A project hands you a worksheet and a list of questions a manager would actually ask, and you answer all 19 of them with formulas rather than by reading numbers off the screen.

Every project uses original synthetic data. There are 4 projects: 1 free to start and 3 included with course access. Question wording below is the wording you meet in the workspace.

What a project asks of you

Each project gives you a fixed sheet and a sequence of questions. The questions deliberately escalate: the first asks for one total, and later ones ask which row is the worst, how many broke a rule, or what a subset adds up to. That escalation is the point, because a single lookup rarely arrives alone at work.

  1. Read the sheet and note which column holds the quantity and which holds the money.
  2. Write one formula that answers the question in the cell it belongs in.
  3. Check the result against the source rows before moving to the next question.
  4. Re-answer a changed version of the same question so the answer cannot be memorised.

The projects

Build a regional sales report

Free

Three regions, two products, four quarters.

4 questions

  1. What did North sell in total across all four quarters?
  2. How many rows are North?
  3. What is the single best quarter figure in the sheet?
  4. What did Desks sell in total, across every region?

Cost out a staffing roster

Course access

Hours, rates, and who is expensive.

5 questions

  1. What does the whole roster cost?
  2. What does the Design team cost?
  3. Who is the single most expensive person?
  4. What is the average design rate?
  5. Flag anyone over 40 hours

Chase a budget variance

Course access

Six cost lines, planned against actual.

5 questions

  1. What is the total actual spend?
  2. Which line overspent the most?
  3. How many lines came in over budget?
  4. What is the total overspend, counting only the over lines?
  5. Biggest miss regardless of direction?

Clean up a messy contact list

Course access

Five names, every formatting problem.

5 questions

  1. How long is the raw name in A2, spaces and all?
  2. What is the name in A2 without the extra spaces?
  3. Now title-case that cleaned name.
  4. Lowercase the email in A2 after trimming it.
  5. Strip the dash out of code A-001.

Where projects sit in the course

The 4 projects sit after the lessons that teach their skills. If a project question looks unfamiliar, the matching lesson guide explains the function on its own with a worked example, and all 92 lesson guides are indexed by skill. For a longer walkthrough of a single business task, the applied guides combine several skills on one problem with complete worked answers.

Open the projects in the workspace