# Real-World Projects

Course: [Excel](https://www.devtutorials.ai/learn/excel) · Section: Practical Projects
Source: https://www.devtutorials.ai/learn/excel/practical-projects/real-world-projects

> Build four complete workbooks: a budget sheet, a marks sheet, an expense tracker, and a sales report.

You've learned every major part of Excel. Now it's time to use those skills the way you will at home, at school, and at work. In this final lesson, you'll build four real workbooks from start to finish: a **budget sheet**, a **marks sheet**, an **expense tracker**, and a **sales report**.

Each project has a **Load the starter workbook** button that puts the data into the sandbox. Work through the tasks in order and press **Check** after each one. Save a draft between projects so you don't lose your work.

Every project uses the same habits: **headings in row 1**, **one value per cell**, **formulas instead of typed totals**, **absolute references for fixed cells**, and a **final check** before sharing. These habits matter more than any single button.

## Budget Sheet

A budget answers one question: **is more money coming in than going out?** It tracks **income**, tracks **expenses**, and calculates the **balance**.

After each project, click **Save draft**, then **Reset** before loading the next starter workbook. Each project starts from its own clean data.

## Marks Sheet

A marks sheet records each student's marks, then calculates their **total**, **average**, and **grade**.

## Expense Tracker

An expense tracker records **daily expenses**, rolls them up into a **monthly summary** by category, and shows the result as a **chart** and a short **report**.

## Sales Report

A sales report collects **sales data**, **calculates totals**, **generates charts**, and summarizes the period in a **monthly report** a manager can read at a glance.

Do things in a sensible order: totals for each row first, then sort, then add a total row underneath. A total row inside the table would be sorted along with the data.

## Common mistakes

| Mistake | What happens | How to fix it |
|---|---|---|
| Total row sorted with the data | The total ends up at the top | Sort before adding the total row, or leave a blank row |
| SUMIF ranges not locked | Lower rows look in the wrong place | Use `$B$2:$B$9` |
| Nested IF in the wrong order | High scores get low grades | Test the highest threshold first |
| Total included in a pie chart | One slice is half the pie | Select only the categories |
| Typed totals | They don't update when data changes | Replace them with formulas |

## What to remember

- Real workbooks combine many skills: data entry, formatting, formulas, functions, sorting, charts, and conditional formatting.
- A **budget** compares income with expenses and calculates a balance.
- A **marks sheet** uses SUM, AVERAGE, nested IF, and COUNTIF.
- An **expense tracker** rolls daily entries into a summary with SUMIF, then charts it.
- A **sales report** totals, ranks, and charts data, with a total row added after sorting.
- Test every workbook by changing a number.

Congratulations on finishing the Excel course! You can now organize, calculate, analyze, and present data with confidence.