This is a revenue and profit-focused dashboard where you can visualize data and insights from the last five years to make informed and precise decisions. It focuses on:
✔️ Revenue Dashboard
✔️ Profit Dashboard
✔️ Advanced Formulas with Slicers
✔️ Dynamic Search-1 (Macro-enabled)
✔️ Dynamic Search-2 (Macro-enabled)
✔️ Dynamic Dropdowns with LOOKUPS (May not work properly depending on software version)
✔️ VBA (Macro-enabled)
✔️ Pivot Table
✔️ Chart with Slicers
✔️ Conditional Formatting
⚙️ Macro Information:
.xlsm workbook is macro-enabled.
- Macros are included in Sheets 4, 5, and 7.
- You’ll need to adjust your macro security settings to allow them to work on your PC.
- For a safer version, a separate
.xlsxfile is uploaded (macros will be disabled in this version).
🧠 Additional Notes:
I’ve included both basic and advanced Excel techniques.
The dataset is AI-generated using ChatGPT, and the challenges are compiled from online sources and various references.