Excel MIS sample
The workbook has a data sheet, a monthly summary using SUMIFS, and a product-by-branch sheet. No macros.
| Date | Branch | Product | Qty | Amount |
|---|---|---|---|---|
| 2026-08-02 | Indiranagar | Filter coffee | 40 | 9600 |
| 2026-08-06 | Whitefield | Brass lamp | 6 | 10800 |
| 2026-09-02 | Indiranagar | Filter coffee | 48 | 11520 |
| 2026-09-08 | Whitefield | Brass lamp | 8 | 14400 |