The VCU School of Business Emerging Technology Center is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium.https://docs.google.com/spreadsheets/d/1VlwwE2bD07kk605bvgPoCHG8zYFhGJm_/edit#gid=1372020365&range=A1:C216 Use the Symposium prospect list at this linkLinks to an external site. to determine the number of member and nonmember registrants.

1. Directions for answering Question One
   1. Make an Excel workbook with three tabs:
      1. Notes
      2. Prospect List (data) (The input file provided in this question.)
      3. Registrants Pivot Table shows the total corporate member and total corporate nonmember count on the Prospect list. Within the total corporate members, display the total members by company. Highlight the total number of nonmembers and the total number of members.
         1. The pivot table should look something like this with the numbers filled in:

https://virginiacommonwealth.instructure.com/courses/87491/files/9705029/preview