FormulaCamp
Completed
1. Excel Fundamentals · Project P01 · 30 min

9. Project P01: Personal Finance Tracker

Lesson 9 of 9
Task 1 of 6
  1. Format the headers A1:H1: bold font and a gray fill.

Lesson theory

Your task: tidy up the expenses for March. Format the table, total each category, work out each category's share, and compare it to its limit. Use everything you already know: formulas, SUM, SUMIF, $ references, formats and styles.

Do the tasks in order and try without hints first. A hint is there if you get stuck.

fx

Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo

Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page