We now need to choose the data that we want to analyse – click on the pop out icon next to the Table/Range box… Click on Insert on the ribbon and select PivotTable… The first thing to do is set up the initial table: click on the sheet tab called Pivot which is an empty spreadsheet at the moment. One of the best ways to view a lot of data is in a pivot table it’s easy to set up and summarises data that you want to see. If you’d like a recap of the previous tutorials, please click the links: Part 1, Part 2 & Part 3. In the last 3 tutorials we created our timesheet ready to use in this tutorial we’ll create a pivot table to help make sense of the information inputted into the timesheet.
0 Comments
Leave a Reply. |