Pivot Tables:
How to Avoid all that Copying-and-Pasting to Build a 2D Table
Note: you don’t absolutely need to know about any of this. You can do perfectly well using the steps shown in the Project Notes to turn a linear print-out of data into a 2D table. Once you get used to them, however, Pivot Tables will save you time.
Computer Graphics
Copyright By PowCoder代写 加微信 powcoder
pivot_tables.pptx mjb – March 13, 2022
Remember This Slide from the Project Notes Noteset?
You will need to do some copying and pasting to get the linear format into this 2D format, but it will be worth it!
Computer Graphics
mjb – March 13, 2022
You can avoid all that copying and pasting by using an Excel feature called Pivot Tables! Here come the steps.
Step #1: Insert Column Heading Labels
Computer Graphics
mjb – March 13, 2022
Step #2: Sweep Over the Entire Table, Including the Labels
Computer Graphics
mjb – March 13, 2022
Step #3: Insert → Pivot Table → OK
Computer Graphics
mjb – March 13, 2022
This will create a new worksheet.
This defines how the 2D table will be created.
Note that you can have more than 3 columns of data to start with. This process just lets you pick which 3 will go into the 2D table.
Step #4: Assign Roles for the Different Columns of Your Data
1. Drag Cores to Rows
2. Drag Number of Trials to Columns
3. Drag MegaTrialsPerSecond to Values
Computer Graphics
mjb – March 13, 2022
Ta-Da! You Have a 2D Table with No Copying and Pasting!
You can get rid of the Grand Total row and column – they have meaning in some spreadsheet applications, but not here.
Computer Graphics
mjb – March 13, 2022
But, You Can’t Make a Graph from a Pivot Table, so Copy and Paste it into Normal Cells
Sweep over and Copy the Pivot Table:
Paste those numbers somewhere else:
Clear the Row Labels cell:
Computer Graphics
mjb – March 13, 2022
Sweep Over the New 2D Table and Copy → Insert your graph, Just like in the Project Notes
Computer Graphics
mjb – March 13, 2022
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com