# 15. Final Project — Maharashtra Monthly Report

Source: https://ravindrabagale.com/mr/excel/ch15-final-project-blinkit-maharashtra-monthly-report/
Language: mr (Marathi with English technical terms)

Messy fictional exportपासून complete workbook बनवू. प्रत्येक stage स्वतः करा आणि परिणाम तपासा.

Deliverables

Raw, cleaned tblOrders आणि reconciliation.

Named masters, lookup/calculated columns.

पाच business प्रश्नांची Pivot analysis.

Readable interactive dashboard.

Tested refresh/export macro, आवश्यक safeguardsसह.

.xlsm workbook, verified PDF आणि Notes.

Stages

15.1 Project brief आणि fictional data

15.2 Stage 1 — raw export clean करा

15.3 Stage 2 — named Tables आणि lookups

15.4 Stage 3 — पाच प्रश्नांसाठी analysis

15.5 Stage 4 — final dashboard

15.6 Stage 5 — Refresh आणि PDF macro

15.7 Submission checklist आणि marking