In this exercise, you are going to use Excel Pivot Tables to analyze a data set: sales data of Global Bikes). You will
Create a pivot table.
Create crosstabs.
Filter, sort, rank data.
Aggregate data.
Create calculated fields.
Create charts.
Analyze time series.
The instructions and questions are in this file Using Excel Pivot Tables for Analytics.pdf.
Actions
The data can be downloaded here: Global Bike Sales.xlsx download
Your answers to the questions should be put in the Answer Sheet Pivot Tables.docx
Actions and submitted. You must answer the questions and provide screenshots to support your answers.