Cleaned and standardized a messy customer transaction dataset using Excel and Power Query. The project included correcting inconsistent text and category values, standardizing dates and phone numbers, converting order amounts into usable numeric data, handling missing values, removing duplicates, and organizing the final dataset into a clean structure. Basic PivotTable summaries were also created to make the cleaned data immediately usable for reporting.