Microsoft Excel course

Excel Lesson 10

Final Employment Workbook Project

First-time setup and success checks

Lesson goal in plain language: Independently build an accessible workbook that organizes, calculates, summarizes, and communicates workplace information.

Prepare before step 1

  1. Open the correct application, website, or device screen and wait for its name to be announced.
  2. Open Excel manual and review the matching procedure if any command or term is unfamiliar.
  3. Use only fictional, public, disposable, or instructor-provided practice information. Make a copy before changing an important file.
  4. Read all numbered instructions once before performing them so you know the intended final result.

Commands used or referenced

Enter, Insert+Spacebar,, Alt+Q

For a plus-sign command, hold the modifier key, press and release the final key, then release the modifier. For a sequence, press and release each key in order. Stop after every command and listen for the result.

Work and verify

  1. Perform one numbered instruction and stop. Identify the active window, focused control, selected item, cell, slide, message, field, or device area before continuing.
  2. Compare the result with the lesson goal. A sound alone is not enough; verify the name, state, value, location, permission, or content.
  3. If the result is wrong, press Escape once to leave an unexpected menu, identify focus again, and use Undo only when the change is safely reversible.
  4. Save or synchronize at natural stopping points. Use the required filename Excel-Lesson-10-Final.xlsx.
  5. Complete the “Before submitting” checklist from top to bottom. Correct missing items before marking the lesson complete.
  6. Close and reopen the practice item, or return to it from the product’s main screen, to prove you can locate and verify the result independently.

Success standard: Explain what each major command did, show the finished result, and recover from one harmless focus or navigation error without another person naming the next key.

Goal

Independently build an accessible workbook that organizes, calculates, summarizes, and communicates workplace information.

Skills practiced

Step-by-step instructions

  1. Create a workbook for a fictional department's monthly supply budget.
  2. Create a Purchases worksheet with the headers Date, Item, Category, Quantity, Unit Cost, and Line Total.
  3. Enter at least ten fictional purchases across at least three categories.
  4. Use a formula to calculate each Line Total.
  5. Format dates and currency appropriately without merging cells.
  6. Convert the purchase list to a table and give it a meaningful name.
  7. Create a Summary worksheet.
  8. Calculate the grand total, average line total, lowest line total, and highest line total.
  9. Use COUNTIF to count at least one category or status.
  10. Create one simple chart from summary data, add meaningful alt text, and keep its source data available.
  11. Add a plain-text summary that explains the most important result.
  12. Run the Accessibility Checker and review every worksheet using only the keyboard.
  13. Save the workbook as Excel-Lesson-10-Final.xlsx.

JAWS help: Press Insert+Spacebar, then J, to search JAWS commands when you forget a keystroke. Ribbon KeyTips can differ slightly by Microsoft 365 update, so Alt+Q search is included where useful.

Your assignment

Complete an accessible monthly supply-budget workbook with at least ten purchases, formulas, a table, summary calculations, a chart with alt text, and a written summary.

Save the finished assignment as Excel-Lesson-10-Final.xlsx.

Before submitting

Ready for the final quiz?

After reviewing all ten lessons, take the Microsoft Excel final quiz. Score 80 percent or higher to create a printable completion certificate.