Are you staring at a sea of empty cells and don’t know where to begin? Excel feels far less intimidating when you treat it as a toolbox instead of a test. These beginner-friendly projects help you create practical trackers and planners in under an hour while learning core skills.

A quick note before you begin

Converting data to tables

All the projects below involve converting raw data ranges to Excel tables and naming them. To do this:

1. Ensure your dataset has a header row.
2. Select the dataset, including the header row.
3. Press Ctrl+T or click Insert > Table.
4. Check My table has headers, then click OK.
5. Select any cell in the table, and in the Table Design tab, rename the table using the Table Name field.

OK, so set your timer and let’s get started!

Project 1: Build a personal budget tracker to master your cash flow

Managing your money with simple math

A budget tracker helps you see exactly where your money goes without a complex setup. Excel handles the structure—you just need to define the rules.

Start by setting up your transaction table:

1. In row 6, create headers for Date, Description, Category, and Amount.
2. Populate your table with some transactions, entering income as positive values and expenses as negative values in the Amount column.
3. Convert the range to a table and name it Transactions.
4. Using the Number group of the Home tab, format the Amount column as Accounting.

​​​​​​

Next, build your summary section at the top of the sheet.

1. In cell A1, type Starting balance, then in cell B1, manually type your balance.
2. In cell A2, type Income, then in cell B2, enter:

   =SUMIF(Transactions[Amount],">0")

3. In cell A3, type Expenses, then in cell B3, enter:

   =SUMIF(Transactions[Amount],"<0")

4. In cell A4, type Final balance, then in cell B4, enter:

   =B1+B2+B3

Now, your sheet automatically updates your financial position every time you add a new transaction.

OS

Windows, macOS, iPhone, iPad, Android

Free trial

1 month

Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more.

Project 2: Design a priority-based task manager

Organizing your day with filters

Excel can help you prioritize work by highlighting tasks based on due dates and priority, so you can immediately see what’s urgent without manually scanning every row.

Start by building your task table:

1. In row 1, enter your headers: Task, Due, Priority, and Status, then populate the first two fields.
2. Convert the data to a table and name it Tasks.
3. Select the Priority column (excluding the header), then go to Data > Data Validation.
4. In the Allow field, select List, and in Source, type High,Medium,Low.
5. Repeat this process for the Status column (Not Started,In Progress,Complete).
6. Populate those final two columns by selecting the appropriate options from the in-cell drop-down lists you’ve just created.

Now add visual alerts for overdue tasks:

1. Select the Due column (excluding the header).
2. Go to Home > Conditional Formatting > New Rule.
3. Click Only format cells that contain.
4. Select Cell Value in the first drop-down menu and less than or equal to in the second drop-down menu, then in the text field, type:

   =TODAY()

5. Click Format, then choose a red fill color.

After you close the dialog boxes, any tasks due on or before the current date will automatically be highlighted in red.

Project 3: Track your home inventory and stock levels

Finding what you need at a glance

A simple inventory tracker helps you keep on top of everyday essentials by showing exactly what you have, what’s running low, and what needs restocking. Instead of guessing or double-buying items, Excel updates your stock status automatically as quantities change.

Start by building your inventory table:

1. In row 1, create headers for Item, Category, Stock, and Minimum.
2. Enter your inventory items and their current stock levels.
3. Convert the range to a table named Inventory.

Next, add an automatic stock check:

1. Add a new column called Status. The table will expand automatically.
2. In the first status cell, type the following formula, then press Enter:

   =IF([@Stock]<[@Minimum],"Restock","OK")

Finally, add a slicer to make filtering easier:

1. Click anywhere inside the table, and in the Table Design tab, click Insert Slicer.
2. Tick Status, then click OK.
3. Click Restock in the slicer to see only low-stock items.

Now, your inventory automatically highlights what needs replenishing, and you can switch between full view and “restock only” mode with a single click.

Project 4: Calculate shared expenses

Splitting costs without confusion

Creating a cost tracker simplifies shared finances by automatically calculating each person’s share of the overall balance. Instead of manually working out receipts and reimbursements, Excel updates the balances for you whenever new expenses are added.

First, build your expense table:

1. In row 1, create headers for Item, Cost, and Buyer.
2. Enter your shared expenses underneath the headers.
3. Convert the data into an Excel table, rename it Expenses, and format the Cost column as Accounting.

Next, leave a blank column to the right of your Expenses table and create a new one:

1. Insert the headers Name, Paid, and Balance, then enter each participant’s name in the Name column.
2. Format the range as a table named Balances.
3. In the Paid column, type the following formula, press Enter, and format the results as Accounting:

   =SUMIF(Expenses[Buyer],[@Name],Expenses[Cost])

4. Open the Table Design tab, and check Total Row.
5. Remove the default value in the Balance total cell, then select Average from the drop-down menu in the Paid total cell.

Finally, calculate who owes money. In the Balance column, type:

=[@Paid]-Balances[[#Totals],[Paid]]

Then, press Enter and format the results as Accounting. Positive balances indicate the person paid more than the average and should be reimbursed, while negative balances mean the person owes money to the group.

Master the grid and take the next step

You’ve gone from staring at blank cells to building useful spreadsheets that actually do work for you—tracking money, managing tasks, organizing supplies, and splitting costs. More importantly, you’ve learned the core patterns that make Excel powerful in everyday life. The next leap is moving from manual tracking to automation, and that’s where Power Query comes in.