AIN3701
ASSIGNMENT 3
DUE SEPTEMBER 2024
Part (a): Creating the Visual Dashboard in Excel
Step 1: Setting Up the Workbook
1. Open "Assignment_3.xlsx" in Excel 365.
2. Save the workbook as "yourstudentmutiber_Sumame_AlxIsm" (macro-enabled
workbook).
Step 2: Preparing the Data
1. Organize the data on the "Data" worksheet. Ensure each product and category is clearly
defined along with the monthly sales data.
2. Create a separate worksheet for calculations and VBA coding, named "Workings".
AIN3701 ASSIGNMENT 3 SOLUTIONS SEMESTER 02 — 2024
1 Solution Implementation
1. Open the Provided File
Open the Excel file "Assignment 3.xlsx".
2. Create a Dashboard Worksheet Add a New Worksheet: Name the new worksheet
"Dashboard".
Set Up Dashboard Layout
: Allocate space for four main components: Yearly Trend
• All Categories Ranking of Categories Yearly Trend
• Product per Category Yearly Trend
• Braai Top 10 Products
3. Category Rankings:
"Braai" is the top-performing category. followed by 'Deserts' and "Potiieskos
c The "Breakfast" category, despite being the lowest, gill shows stable sales throughout the
year
4. Top 10 and Bottom 10 Products:
ASSIGNMENT 3
DUE SEPTEMBER 2024
Part (a): Creating the Visual Dashboard in Excel
Step 1: Setting Up the Workbook
1. Open "Assignment_3.xlsx" in Excel 365.
2. Save the workbook as "yourstudentmutiber_Sumame_AlxIsm" (macro-enabled
workbook).
Step 2: Preparing the Data
1. Organize the data on the "Data" worksheet. Ensure each product and category is clearly
defined along with the monthly sales data.
2. Create a separate worksheet for calculations and VBA coding, named "Workings".
AIN3701 ASSIGNMENT 3 SOLUTIONS SEMESTER 02 — 2024
1 Solution Implementation
1. Open the Provided File
Open the Excel file "Assignment 3.xlsx".
2. Create a Dashboard Worksheet Add a New Worksheet: Name the new worksheet
"Dashboard".
Set Up Dashboard Layout
: Allocate space for four main components: Yearly Trend
• All Categories Ranking of Categories Yearly Trend
• Product per Category Yearly Trend
• Braai Top 10 Products
3. Category Rankings:
"Braai" is the top-performing category. followed by 'Deserts' and "Potiieskos
c The "Breakfast" category, despite being the lowest, gill shows stable sales throughout the
year
4. Top 10 and Bottom 10 Products:
