💪 Challenge: Create an Excel Summary Report FAST
Create an Excel Summary Report FAST
Use the knowledge you've gained in this section to create a quick summary report.
Open S2_Dynamic_Array_Basics_START file and go to the Challenge tab.
The Challenge has 3 steps:
Step 1: Convert the data to a table. Name the table TableAgent
Step 2: Create a unique list of sales agents sorted in descending order
Step 3: Calculate the total quantity sold by each agent during the entire period
The data is in the Challenge tab.
The Answer is included in the completed version of the Workbook: S2_Dynamic_Array_Basics