![]() ![]() Existing Worksheet should be ticked for the location of the pivot table, and click OK. ![]() Then click back into the Main sheet tab and highlight the table from the start (cell A3) to the end (cell I16 in our example) – you’ll notice it displays Table1 in the box, this is the current name of the actual table…Ĭlick back on the pop out box and it takes you back to the Create PivotTable dialogue box. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |