3 Excel projects you can finish in 15 minutes this weekend (July 10-12)

You don't need to spend hours in a spreadsheet to level up your Excel skills. If you have 15 minutes to spare this weekend, try building one of these clever, professional-looking projects. They're quick to finish, satisfying to make, and genuinely useful once you're done.

Build a mini data dashboard with a single function

No need for heavy charts

Standard Excel charts are useful, but they can quickly clutter a worksheet. Instead, use the REPT function to create compact data bars that sit directly inside your cells and expand as your numbers change.

First, create your worksheet layout and input some dummy data:

1. Type Performance Dashboardin cell A1and format it with a large, bold font.

2. Type your headers in row 3— Productin A3, Salesin B3, and Visualin C3—and widen column Cto give plenty of space for the in-cell chart you're going to add.

3. Type five sample products in the Productcolumn and sales figures—5,200, 6,400, 7,800, 9,300, and 10,100—in the Salescolumn.

4. Select the entire data range, and press Ctrl+T(or click Insert > Table) to convert your data into an Excel table .

5. Check My table has headers, then click OK.

Now, select cell C4, type the following formula into the formula bar, and press Enter:

This divides the current row's sales by the largest value in the Sales column to calculate a ratio between 0 and 1. It then multiplies that by 20, which sets the maximum width of the bar, before the REPT function repeats the block character to create a proportional bar for each row.

Finally, make the dashboard easier to read:

1. Select all the cells in your Visualcolumn and change the font to Consolasso the text blocks align perfectly.

2. With the Visualcolumn still selected and the Hometab still open, click Conditional Formatting > New Rule.

3. In the dialog box, click Use a formula to determine which cells to format, and create the four rules below in the order shown:

Once you've mastered this technique, you can use the same approach to create star ratings and other in-cell visuals.

Excel's built-in Conditional Formatting Data Bars can also create quick in-cell charts, but REPT gives you more creative control. Because the visual is made from text characters, you can customize the symbols, colors, and layout to create visualizations that look completely different from standard conditional formatting.

Build an offline password strength checker

Set up personalized rules in modern Excel

Most password managers can already generate and evaluate strong passwords, but building your own checker is a fun way to see how Excel can turn simple rules into an interactive tool.

This project requires Excel for Microsoft 365 or Excel for the web because it relies on the REGEXTEST function .

Start by creating the password input area and your validation checks:

1. Type the large, bold title Password Auditorin cell A1.

2. Create headers across row 3: Passwordin A3, Lengthin B3, Numberin C3, Capitalin D3, Lowercasein E3, Symbolin F3, and Security Ratingin G3.

3. Select cell A4, apply a light blue cell fill, and type a sample password.

4. Enter the following formulas, and as you do, watch Excel return TRUE or FALSE for each criterion:

Next, in cell G4, enter the following formula to convert the number of successful checks into an overall rating:

Two or fewer TRUE evaluations result in a weak rating, three or four create a moderate rating, and only a password that passes all five checks receives a strong rating.

Now, add conditional formatting to show results visually. For each of the ranges and cells below, click Conditional Formatting > Highlight Cells Rules > Equal To, and apply the corresponding colors:

Finally, polish the worksheet so it looks like a mini-app:

1. Widen columns Athrough Gso the input, headers, and results have plenty of space.

2. Select cells A3:F4and click Centerin the Alignmentgroup in the Hometab.

3. Bold the headers in row 3.

4. Go to the Viewtab and uncheck Gridlinesto give the worksheet a cleaner, app-like finish .

Your completed worksheet now functions as a simple password audit tool: type a new password into the input cell and watch each validation update automatically.

This checker is designed as an Excel project rather than a security guarantee. A "Strong" result only means the password passed the rules you created—it shouldn't replace a dedicated password manager or security tool.

Build a digital dice roller

Turn Excel into a board game app

If you lose the dice to your favorite board game, Excel can step in as an unpredictable digital substitute.

First, create your spreadsheet layout:

1. Type the large, bold title Game Night Dicein cell A1.

2. Reduce the width of column Ato just a few pixels, and increase the width of column Bso it takes up about half your screen width.

3. Open the Hometab and format cell B2:

   1. Increase the font size to 200pt.

   2. Set both the vertical and horizontal alignment options to Center.

   3. Apply a light gray cell filland a thick box border.

Now, create the dice engine. Select cell B2, and in the formula bar, type:

When you press Enter, you have a six-sided digital dice.

Finally, make the tool user-friendly and add a finishing touch:

1. Select cell B4and type Press F9 to roll in a small, muted font. Center-alignthe text in this cell.

2. Open the Viewtab and uncheck Gridlinesto clean up the sheet.

Whenever it's your turn to play, simply press F9 to recalculate the workbook and roll your digital dice.

RANDBETWEEN recalculates whenever the workbook recalculates, so your dice value may change if you edit other cells on your sheet.

---

Take your spreadsheet creation skills to the next level

Once you've finished these quick builds, you'll have three polished spreadsheets and several useful Excel techniques you'll use again and again. If you're ready for another challenge, you can build heat maps, 3D maps, and more in under an hour by following our previous collection of Excel weekend projects .