Final Project – Part 4: Building the Dashboard Layout

In this fourth part of the Final Project, you will assemble all the elements created so far — dataset, calculations, KPIs, and charts — into a clean, professional, and visually balanced Sales Dashboard. This is the phase where your work becomes a real analytical tool, suitable for presentations, reporting, and decision-making.

A well-designed dashboard is not just a collection of charts. It is a structured, intentional layout that communicates insights clearly and instantly.

---

1. Create a New Sheet for the Dashboard

Start by creating a new worksheet named Dashboard. This sheet will contain only the final visual output — no raw data, no formulas, no helper tables.

Review layout best practices in Lesson 6.5 – Best Practices for Clean Spreadsheets.

---

2. Set Up the Dashboard Grid

A clean grid helps you align elements perfectly. Follow these steps:

1. Increase column width to create a wide canvas (e.g., 18–22 units).
2. Reduce row height slightly for a compact layout.
3. Turn off gridlines for a clean look:
   View → Gridlines (uncheck)
4. Use light gray borders to define invisible alignment zones.

This creates a professional “canvas” similar to BI tools like Power BI or Tableau.

---

3. Add the Dashboard Title

At the top of the sheet, create a large, clear title such as:

Sales Dashboard – Year Overview

Formatting tips:

• Font: Calibri or Arial
• Size: 24–28 pt
• Bold
• Centered across the top area (use Center Across Selection, not Merge Cells)

Review formatting basics in Lesson 2.2 – Formatting Cells.

---

4. Insert KPI Cards (Top Section)

KPI cards give an instant overview of performance. Use the KPIs created in Part 2 – Calculations Layer.

Recommended KPIs:

• Total Sales
• Total Quantity Sold
• Average Order Value
• Top Product
• Best Region

How to create KPI cards:

1. Insert a rectangle shape for each KPI.
2. Remove the shape border.
3. Use a light background color (very pale gray or white).
4. Insert the KPI value using a linked cell reference.
5. Add a small label above or below (e.g., “Total Sales”).

Use keyboard shortcuts to speed up alignment and duplication.

---

5. Insert the Charts

Now place the charts created in Part 3 – Creating Visualizations.

Recommended layout:

• Left side: Column Chart (Sales by Region)
• Right side: Pie Chart (Sales by Category)
• Bottom: Line Chart (Monthly Sales Trend)

This layout balances comparisons (left), proportions (right), and trends (bottom).

Formatting tips:

• Remove chart titles and replace them with text boxes for consistent styling
• Align charts using the “Align” tools
• Use consistent colors across all charts
• Resize charts so they fit neatly into the grid

Review chart formatting in Lesson 5.1 – Basic Charts.

---

6. Add a Summary Table (Optional but Recommended)

A small summary table can help users understand the data behind the charts.

Suggested metrics:

• Top 5 Products
• Top 5 Regions
• Monthly Average Sales

Use sorting and filtering techniques from Lesson 4.2 – Sorting Data and Lesson 4.3 – Filtering Data.

---

7. Apply Final Formatting

A professional dashboard must be visually clean and consistent.

Checklist:

• Use a single font family
• Use consistent colors across all elements
• Remove unnecessary gridlines and borders
• Align all elements perfectly
• Use whitespace strategically
• Ensure KPI cards are evenly spaced
• Ensure charts are aligned and sized consistently

Review best practices in Lesson 6.5 – Best Practices for Clean Spreadsheets.

---

8. Practical Exercise

1. Create a worksheet named FP_Part4_Dashboard.
2. Set up a clean dashboard grid.
3. Add a title using Center Across Selection.
4. Insert KPI cards linked to your calculations sheet.
5. Place the three charts in a balanced layout.
6. Add an optional summary table.
7. Apply final formatting and alignment.

---

Next Part

Continue with the final phase of the project: Final Project – Part 5: Final Review and Export