A quiet afternoon is the perfect excuse to build practical Excel tools that organize your hobbies, bills, and budget. These three guided projects show how a handful of formulas, tables, and formatting rules can transform a blank worksheet into practical tools that fit around your lifestyle.

Organize your books and track your reading goals

Carving out time to read is one of the best ways to unplug, but letting your book stack gather dust is all too easy without a little extra motivation. Building a dedicated reading log gives you a gentle nudge to stay on track.

First, set up and begin populating your log:

1. Type the column headers Title, Author, Genre, Format, Status, and Finished Date into row 5, and populate cells A6, B6, and C6 with the title, author, and genre of your first book.
2. Select one of the table cells, press Ctrl+T, and check My table has headers to turn your tracker into a table.
3. Open the Table Design tab.
4. Name the table Library_Log_2026.

Next, create in-cell drop-down lists for the book format and status:

1. Select cell D6.
2. Click Data > Data Validation.
3. Change the Allow field to List.
4. Type Paperback, Hardcover, E-reader, Audiobook into the Source field, then click OK.
5. Repeat this process for cell E6, but enter Unread, Reading, Completed.

You can now complete row 5, and as soon as you start typing in row 6, the boundaries and drop-down menus will expand downward.

Next, set up an analytics card:

1. Enter your yearly target manually in cell B1.
2. Use the 2026 formulas in the table below to count books completed and your current progress.

When 2026 ends, duplicate the worksheet for 2027, clear all the data from your table, set your annual goal in cell B1, and update the table name in the Table Design tab.

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.

Build a dynamic home utility tracker to track your energy bills

Keep your monthly household consumption under control

Utility bills only seem to move in one direction: up. While you can’t control wholesale prices, you can build a framework to determine whether rising bills are due to higher consumption, price hikes, or both.

To do this, starting on row 4:

1. Create a table (Ctrl+T) named Utility_Tracker_2026 with the headers Month, Meter Reading, Units Used, Total Cost, Cost Per Unit, and Consumption Change.
2. Format the Total Cost and Cost Per Unit as Accounting.
3. Use row 5 as a baseline entry point by entering your final reading from December of the previous year.

Use cells A1:B2 to display your overall annual metrics, so you can easily keep tabs on your numbers:

Enter the following 2026 formulas in row 5. Excel will automatically apply them to the remaining rows when you press Enter:

As you enter the raw meter readings and total costs from your utility statements, the formulas automatically calculate your usage, cost per unit, and consumption change, while handling blank rows and returning error placeholders until the next month’s data is ready.

To visualize consumption spikes, select your Consumption Change column, then click Home > Conditional Formatting > Color Scales > Red-Yellow-Green to apply a heatmap that highlights higher consumption in red and lower consumption in green.

The following year, make these quick changes to a duplicated copy of the worksheet:

1. Rename the duplicated sheet tab to reflect the year.
2. Clear the Meter Reading and Total Cost columns.
3. Type your final December meter reading from the previous year into row 5.
4. Update the table name to match your new sheet title.

Track your personal monthly budget to master your finances

Build a stress-free money dashboard

Setting up a monthly budget dashboard doesn’t require complex bookkeeping knowledge—you just need a clean structure that separates your cash summary from your upcoming billing dates.

First, insert the table:

1. In row 9, create a table (Ctrl+T) with column headers for Category, Item, Cost, To Pay, Day, and Date.
2. Name the table Jun_26.
3. Format the Cost and To Pay columns as Accounting, and the Date column as Date.

Now, set up the summary dashboard:

1. In cells A1:A7, type Month, Year, Total cost, To pay, Bank, and Leftover.
2. Type the current month index number (such as 6 for June) into cell B1, the current year in cell B2, and your current bank balance (formatted as Accounting) in cell B6.
3. Use the formulas below to complete the dashboard, with all cells formatted as Accounting.

Now, move back to your Jun_26 table:

1. Populate the first five columns for the first payment item (cells A10:E10) manually.
2. Use the DATE function to generate the payment date in cell F10:

   =DATE($B$2,$B$1,[@Day])

As you move through the month, type PAID over fully cleared balances. If you pay off any expenses bit by bit, manually adjust the To Pay cell value as necessary.

Finally, add some visual conditional formatting cues. The target cell or range in the table below is what you need to select before clicking Home > Conditional Formatting > New Rule > Use a formula… to set up a rule.

To roll this tracker over into the future, follow this checklist in a duplicated worksheet tab:

1. Double-click the new sheet to rename it for the new month.
2. Update the month and year in cells B1 and B2.
3. Update your starting bank balance in cell B6.
4. Add any month-specific expenses to your table (and remove those corresponding to the previous month).
5. Update the table name to match the current month and year. The associated structured references will update accordingly.

A weekend well spent

Whether you’re looking for ways to get organized or you simply enjoy playing around with Excel, spending an hour turning your finances and hobbies into trackable spreadsheet systems is a great way to feel a sense of achievement. And you don’t have to stop there! Last weekend’s Excel projects cover setting up a monthly habit tracker, a vehicle maintenance log, and a dynamic meal planner—three more tasks that will send you into Monday morning with the feeling of a weekend well spent.