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 – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – tubebuddy.com/chrismenard

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 ( Download)
• Create a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial! ( Download)
• Make Pivot Table from Multiple Sheets in Excel ( Download)
• Getting started with PivotTables in Excel ( Download)
• Create an Excel PivotTable Based on Multiple Worksheets ( Download)
• Excel: Getting started with PivotTables ( Download)
• Excel - Combine Multiple Tables - Relationships (PivotTables) and XLOOKUP ( Download)
• How to Create a Pivot Table Using Multiple Sheets in Excel | Microsoft Excel Tutorial | Simplilearn ( Download)
• How to Create a PivotTable From MULTPLE SHEETS in Excel (Different Headers or With the Same Headers) ( Download)
• Use a PivotTable and Vlookup to find out weekly revenue by Chris Menard ( Download)
• Recommended PivotTables in Excel by Chris Menard ( Download)
• Create One Pivot Table from Many Sheets ~ AWESOME Excel Trick ( Download)
• Manual Grouping in a PivotTable in Excel by Chris Menard ( Download)
• Excel - 3D Reference with Multiple Worksheets ( Download)
• Pivot Table from Multiple Sheets - Google Sheets ( Download)