BYS [SSV1015] – Pivot Tables


Plenty of practice using Pivot Tables. See below for a full product description.


This unit begins with basic pivot tables with plenty of onscreen instructions on how to drag and drop data into rows and columns and use filtering and the values box. There is also practice on formatting data and the general appearance of the Pivot Table including re-naming labels and sorting in ascending / descending order. As the unit progresses there are tasks that ask for Pivot Charts with appropriate labelling etc. The unit finishes with tasks using the “Show Values as” function to show revenue as a % of sales and a calculated field.


There are no reviews yet.

Be the first to review “BYS [SSV1015] – Pivot Tables”