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 Dashboard in cell A1 and format it with a large, bold font.
2. Type your headers in row 3—Product in A3, Sales in B3, and Visual in C3—and widen column C to give plenty of space for the in-cell chart you’re going to add.
3. Type five sample products in the Product column and sales figures—5,200, 6,400, 7,800, 9,300, and 10,100—in the Sales column.
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:

=REPT("█", ROUND(([@Sales]/MAX([Sales]))*20, 0))

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 Visual column and change the font to Consolas so the text blocks align perfectly.
2. With the Visual column still selected and the Home tab 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.

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 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.

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

1. Type the large, bold title Password Auditor in cell A1.
2. Create headers across row 3: Password in A3, Length in B3, Number in C3, Capital in D3, Lowercase in E3, Symbol in F3, and Security Rating in 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:

=IFS(COUNTIF(B4:F4, TRUE)<=2, "Weak", COUNTIF(B4:F4, TRUE)<=4, "Moderate", TRUE, "Strong")

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 A through G so the input, headers, and results have plenty of space.
2. Select cells A3:F4 and click Center in the Alignment group in the Home tab.
3. Bold the headers in row 3.
4. Go to the View tab and uncheck Gridlines to 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.

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 Dice in cell A1.
2. Reduce the width of column A to just a few pixels, and increase the width of column B so it takes up about half your screen width.
3. Open the Home tab 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 fill and a thick box border.

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

=RANDBETWEEN(1, 6)

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 B4 and type Press F9 to roll in a small, muted font. Center-align the text in this cell.
2. Open the View tab and uncheck Gridlines to clean up the sheet.

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

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.