Car Database Management and Analysis Using Excel

In this project, I converted a raw text-based car database into an organized and insightful Excel workbook, which was imported and structured using commas as delimiters. I leveraged advanced formulas such as VLOOKUP, LEFT, MID, RIGHT, CONCAT, and IF to extract and transform key information into usable data points.

To enhance visualization and analysis, I:

⚡Applied conditional formatting to highlight trends in the data.

⚡Created a scatter chart to show the relationship between the age of cars and their miles driven.

⚡Built a pivot table to calculate the total miles driven by each driver.