Project from my Excel Data Analysis course. Excel Data Anaysis Project:
This project analyzes a sample sales dataset using Excel.
Skills used : • Data Sorting • Data Filtering • Conditional Formatting • Pivot Tables • Tables • Charts • Functions • Vlookup • Index-Match
Dataset Columns:
• OrderID
• Product
• Region
• Sales
• Quantity
• Date
GOAL: The goal was to analyze sales performance across regions and products.
OUPUT: The analyses includes summary tables and charts showing which regions generated the most sales.