This project demonstrates Excel techniques for cleaning, organizing, analyzing, and visualizing sales data. It’s designed to showcase core spreadsheet functions used in a business sales environment.
- Text to Columns: Splitting combined data entries for clarity
- IF Statements: Logic to flag conditions and criteria
- SUMIF: Summing totals based on specific conditions
- Sorting & Filtering: For easier data exploration
- Pivot Tables & Charts: Visualizing category and regional performance
- Conditional Formatting: Highlighting top performers and patterns
