Ain3701 Assignment 3 Due September 2024

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-enworkbook).

Step 2: Preparing the Data
1. Organize the data on the “Data” worksheet. Ensure each product and catedefined along with the monthly sales data.
2. Create a separate worksheet for calculations and VBA coding, named “W