Introduction to Pivot Tables Part 2

Introduction to Pivot Tables Part 2

 

 

the first video and I now want to build out some additional pivot tables and charts that we will ultimately add to our dashboard so instead of inserting a brand new pivot table I'm just going to make a duplicate copy of this sheet and then modify the new sheet 

 

so to make a duplicate copy of the sheet the easiest way to do that is you just left-click and hold down on the sheet like you're going to drag it over to the right then hold down the control key on the keyboard and let go the less left mouse button that'll make a duplicate copy of the sheet.

Related Topics:

• How to Use Power Query to Unpivot Data for a Pivot Table
• Use Pivot Tables to Create Montlhly Average vs Current Year Chart in Excel 
• Create a Distribution Chart Using PowerQuery and Pivot Tables
• MTD Pivot Table Calculation for Christopher