Required: Excel Pivot Table is a great tool to summarize, analyze, explore, and present your data from different angles. Using the Orders Datasheet uploaded into the blackboard system, you are required to answer the following questions:
1- How many products are sold by Nancy? 2- Highlight with red color the top three products sold by Andrew 3- Which companies are among the top 5% sellers? 4- Using Pie chart, show the total sale for each employee. Describe and interpret the Pie chart results. 5- Based on analyzing the orders datasheet, provide further useful insights. Explain why these insights are important