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

Discussion

23 comments