Monthly Sales Report Overhaul

The existing monthly sales report had become difficult to maintain. Branch data was entered horizontally across columns, legacy formulas supported the report, and the workbook did not include charts or a consolidated dashboard.

I redesigned the source layout so sales records could be added down rows inside an Excel Table. I then updated the workbook with XLOOKUP and other modern formulas, created PivotTable-based charts, and built a dashboard that presented the month’s sales position in one view.

The original layout placed branches side by side across the worksheet. Every additional branch required another set of columns, which made the sheet wider and increasingly difficult to navigate and maintain.

• Branch data was recorded horizontally rather than in a consistent list of records.
• Adding a branch required extending the worksheet with new columns.
• Formula ranges and references could require manual adjustment as the report changed.
• Older formulas made the logic less flexible and harder to maintain.
• The workbook did not include PivotCharts or a dashboard.
• Users could not quickly see the complete monthly sales position in one place.

Project objective

Build a report structure that could accommodate additional branches without sideways expansion, simplify formula maintenance, and provide a clear visual summary of monthly sales performance.

Once the data was converted into an Excel Table, I replaced outdated lookup logic with XLOOKUP where appropriate and used modern formulas to support the revised report.

• Table ranges expand automatically as new records are added.
• Structured references make formulas easier to read and audit.
• XLOOKUP provides clearer matching logic for returning related values.
• A consistent record structure reduces the need to copy formulas into new branch columns.

I led the workbook redesign from the underlying data structure through to the finished dashboard.

• Reviewed the limitations of the existing report layout and formulas.
• Restructured the source data into a row-based format.
• Converted the source range into an expandable Excel Table.
• Updated report logic with XLOOKUP and other modern formulas.
• Created PivotTables and PivotCharts for sales analysis.
• Designed a dashboard showing the complete monthly sales position.
• Organized the workbook to support easier updates and future branch additions.

The most important achievement was not a single formula or chart. It was transforming a difficult-to-expand worksheet into a coherent reporting model: structured source data feeds maintainable formulas, the same data supports pivot analysis, and the results flow into a clear dashboard.

Potential future improvements

• Automated source-data validation and exception flags
• Power Query connections for recurring data imports
• Additional dashboard filters for region, product, and reporting period
• Automated distribution of monthly management reports