TITLE: Car Fleet Mileage Analysis - PivotTable & Excel Dashboard
PROJECT TYPE: Personal/Practice Project
DESCRIPTION/PROBLEM: I worked with a car inventory dataset containing vehicle and driver mileage records. The goal was to organize, clean and analyze the data using Microsoft Excel and create a clear dashboard for comparing driver mileage and supporting fleet-related decisions.
WHAT I DID:
Cleaned and Standardized car manufacturer names using VLOOKUP and IF.
Created a PivotTable to summarize total mileage by driver.
Used SUM to calculate the overall mileage of 1,406,428.4 miles.
Created a bar chart to compare driver mileage visually.
Used LEFT, MID and RIGHT to extract information from car IDs.
Used CONCATENATE to generate standardized car IDs (e.g., FD06MTGBLA001).
Applied Conditional Formatting and professional table formatting for easier interpretation.
RESULT: The completed Excel dashboard made the mileage data easier to understand and provided a quick visual comparison of driver activity.
TOOLS USED: Microsoft Excel, PivotTables, SUM, Charts, Conditional Formatting, VLOOKUP, IF, LEFT, RIGHT, MID and CONCATENATE


0 likes · 0 views · Sep 27, 2026
TITLE: Car Fleet Mileage Analysis - PivotTable & Excel Dashboard PROJECT TYPE: Personal/Practice Project DESCRIPTION/PROBLEM: I worked with a car inventory...