Assignment #01: Advanced Excel Interactive KPI Dashboard with Macros
Create an executive sales report with dynamic slicers, automated PivotCharts, conditional formatting alerting underperforming regions, and a VBA button to export the summary sheet directly to PDF.
Assigned by:
Lead Administrator
Due Date:
Nov 04, 2026
Standard Spec
Faculty Grading Rubric
Assignment Submission Guide
Required Deliverable Formats:
- Web / Code: Public GitHub Repository link with detailed README.md and live demo (Vercel/Render).
- Design & Motion: Figma shareable link (view permissions) or Behance case study URL.
- Marketing / Amazon: Google Sheets / Drive folder with campaign audit PDF screenshots.
- Prepare your deliverable link ensuring permissions are set to "Anyone with the link can view".
- Log in to your Student Dashboard.
- Navigate to My Classroom > open your active course > click the Assignments tab.
- Paste your project URL and write a brief summary of what you implemented.
- Your course trainer will grade and return marks within 48 hours.