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.
Reviews
There are no reviews yet.