Excel - Revenue Project

Designed and structured a comprehensive sales order dataset in Microsoft Excel to organize transaction records and calculate core metrics.

Key Deliverables:

1- Data Structuring & Cleaning: Formatted raw transaction records (dates, regions, representatives, and items) into a clean, standardized layout for clear analysis.

2- Calculations & Formatting: Applied precise formulas to compute total revenues (Units X Unit Cost), applied currency formatting, and adjusted date displays for accurate tracking.

3- Visual Hierarchy: Organized columns and data types to ensure readability and prepare the sheet for executive summary reporting.