Excel Pivot Table from Multiple Sheets
See how to create an pivot table from multiple sheets in Excel.
Get written steps and an Excel sample file on my Contextures site.
https://www.contextures.com/xlpivot08...
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#contexturesexceltips
Video Timeline
0:00 Data on 2 Sheets
0:24 Open PivotTable Wizard
0:50 Select Sheet Ranges
1:08 Page Field Settings
1:29 Adjust the Pivot Table
2:04 Show Sum
2:15 Page Field