You can create a PivotTable in Excel using multiple worksheets. The key is to turn the ranges into Tables. The trick to doing this is the tables are related. Example: you may have one table that has all your customers and their customer numbers. Another table contains orders for those customers but must include the customer number. We tie the customer number from the Customer Table to the customer number of the Orders table.
#pivottables #exceltutorial #excelworksheets
Chris Menard is a Microsoft Office Master Instructor. He is also a public speaker on technology products. His clients include:
The University of Georiga Executive MBA students.
Mizuno USA
Gwinnett Medical Center
The Georgia Society of CPAs.
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ KZitem keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Негізгі бет Create a PivotTable in Excel using multiple worksheets by Chris Menard
Пікірлер: 108