At the end of the class, you will create your own Pivot Tables and Pivot Charts from data provided or from your own data.

Create a Pivot Table from data provided (or practice with your own data). The resource file provided 'Skillshare Pivot Table Exercise.xlsx' is the file shown in all the videos and you will be required to create your own 2D and 3D pivot tables.

1. Make a pivot table showing by employee name (row field) the quantity (value field) of CROSSOVERS1, CROSSOVERS2 and CROSSOVERS3 sold (filter field). This is 2-dimensional.

5610bea8

Push it further by showing this data per month in the column section (3-dimensional).

e723a685

2. Using the Pivot Table and Pivot Chart button, create a pivot chart of your choice that shows the quantity of crossovers sold per employee (the three products only). Take a screenshot of your pivot table /chart and paste this in the Projects Section.

7ed4cc8b

3. Using the Pivot Table and Pivot Chart button, consolidate information from the three worksheets in the file 'Skillshare Pivot Table Consol Exercise.xlsx'. Ignore the request for page field, which can be explored later.

Nicola Reynolds

--

3