Why formatting improves readability in Excel - Business Case Study

Scenario Mode

👤 Your Role: You are an office assistant responsible for preparing reports.

📋 Request: Your manager wants a clear and easy-to-read sales report to share with the team.

📊 Data: You have a table with sales data including Product, Region, Units Sold, and Revenue.

🎯 Deliverable: Create a formatted sales report that highlights key data and improves readability.

Sample Data

Product	Region	Units Sold	Revenue
Notebook	East	120	2400
Pen	West	200	1000
Binder	East	150	2250
Pen	North	180	900
Notebook	South	100	2000
Binder	West	130	1950
Pen	South	170	850
Notebook	North	110	2200

1

Step 1: Select the header row (Product, Region, Units Sold, Revenue) and make the text bold.

Use Excel ribbon: Home > Font > Bold (or press Ctrl+B).

Expected Result

Headers appear bold, making them stand out from data rows.

2

Step 2: Apply a background color to the header row to separate it visually from the data.

Select header row, then Home > Fill Color > Choose a light color (e.g., light gray).

Expected Result

Header row has a light background color improving visibility.

3

Step 3: Format the Revenue column as currency to show dollar signs and two decimals.

Select Revenue cells, then Home > Number Format > Currency.

Expected Result

Revenue values show as $2,400.00, $1,000.00, etc., making money amounts clear.

4

Step 4: Adjust column widths to fit the content so no data is cut off.

Double-click the right edge of each column header to auto-fit.

Expected Result

All data is fully visible without extra space.

5

Step 5: Add borders around all cells to separate data clearly.

Select entire table, then Home > Borders > All Borders.

Expected Result

Each cell is outlined, making the table easier to read.

6

Step 6: Apply conditional formatting to Units Sold column to highlight values above 150.

Select Units Sold cells, Home > Conditional Formatting > Highlight Cell Rules > Greater Than > Enter 150 > Choose light green fill.

Expected Result

Units Sold values above 150 are highlighted in light green, drawing attention to high sales.

Final Result

-------------------------------------------------
| Product  | Region | Units Sold |   Revenue    |
-------------------------------------------------
| Notebook | East   |    120    |  $2,400.00   |
| Pen      | West   |   200*    |  $1,000.00   |
| Binder   | East   |   150     |  $2,250.00   |
| Pen      | North  |   180*    |   $900.00    |
| Notebook | South  |   100     |  $2,000.00   |
| Binder   | West   |   130     |  $1,950.00   |
| Pen      | South  |   170*    |   $850.00    |
| Notebook | North  |   110     |  $2,200.00   |
-------------------------------------------------
* Units Sold highlighted for values > 150

✓Bold headers and background color make the table easy to scan.

✓Currency format clarifies money amounts in Revenue.

✓Borders separate data clearly for better reading.

✓Conditional formatting highlights high sales in Units Sold.

Bonus Challenge

Create a total row at the bottom that sums Units Sold and Revenue with bold formatting.

Show Hint

Use SUM formula for Units Sold and Revenue columns, then apply bold font to the total row.