Analysis of 1,000+ customer records across income, age, education, and commute distance. Built with Pivot Tables and interactive Slicers.
1,000
Dataset size
481
48.1% purchased
N. America
Highest volume
0–1 mi
Commute = peak buy
$10K–$170K
Customer spread
Bike Purchase by Region
Buyers vs Non-buyers per region
Purchase Rate by Commute Distance
Shorter commutes = higher purchase rate
Purchase by Age Bracket
Middle age group dominates purchases
Avg Income — Buyers vs Non-Buyers
Income influence on purchase decision
Dunder Mifflin Sales Dashboard
12-month sales report for Paper, Printers, and Manila Folders with conditional formatting highlights and year-end totals.
5,071
Units sold
1,583
Units sold
667
Units sold
September
Paper: 736 units
Monthly Sales — All Products
Paper · Printers · Manila Folders — 12 months
Annual Sales Share
% of total units by product
Conditional Formatting — Sales Heatmap
Visual recreation of Excel CF rules applied to monthly data
Paper — Sep
736 🔥 PEAK
Paper — Apr
750 ★
Paper — Jul
510
Paper — May
440
Paper — Mar
150 ↓
Color scale: 🔴 Low → 🟡 Mid → 🟢 High (Excel CF rule applied)
Spreadsheet Preview — Dunder Mifflin Sales Report
Actual data structure with conditional formatting applied
📊 Dunder Mifflin Sales Report — Excel Simulation
Product
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Year Total
Paper
450
310
150
750
440
485
510
347
736
155
450
288
5,071
Printer
75
40
65
50
24
71
57
61
34
41
58
91
667
Manila Folder
200
118
145
210
45
170
130
90
55
110
130
180
1,583
US Presidents — Data Cleaning
Professional data cleaning on a historical dataset — removing duplicates, fixing date formats, standardizing party names using TRIM and text functions.
4 types
Duplicates, dates, whitespace, formatting
45
US Presidents
1 removed
Woodrow Wilson
Serial→Date
Excel serials converted
Data Issues Found & Fixed
Before vs After cleaning — each issue type
Before Cleaning — Raw Data Issues
Problems identified in original dataset
❌ Issues Found
→ Duplicate row: Woodrow Wilson (row 28 & 29)
→ Date stored as Excel serial: 44756 instead of 14-Jul-21
→ Party names with extra spaces: "Democratic- Republican"
→ Inconsistent capitalization in party column
→ Trailing whitespace in president names
After Cleaning — Fixed Data
Techniques applied in Excel
✅ Fixes Applied
→ Removed duplicate using: Remove Duplicates tool
→ Fixed dates using: TEXT(A2,"DD-MMM-YY")
→ Trimmed whitespace: =TRIM(party_column)
→ Standardized party names: =PROPER(TRIM(A2))
→ Documented all steps for reproducibility
Party Distribution — After Cleaning
Clean political party breakdown across 45 presidents
Advanced Excel Formulas
XLOOKUP, INDEX/MATCH, IF/IFS, SUMIF, COUNTIF and more — demonstrated on the Dunder Mifflin HR dataset.