Create a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial!

Create a pivot table from multiple sheets in Excel: append sheets with Power Query, or connect tables with Data Model relationships. No copy-paste, no VLOOKUP. 📥 Download the practice workbook: https://www.xelplus.com/create-pivot-... New to Power Query? Start with Power Query Foundations: https://courses.xelplus.com/p/power-q... Method 1 is for sheets with the same columns, like one tab per store. Turn each sheet into an Excel Table, load them to Power Query, and append them into one query. The columns can be in a different order. Add a Store column so you can filter by store, then build the pivot table straight from the result. Method 2 is for a sales table and a separate master list, like product codes and product details. Instead of writing lookups, create a relationship under Data → Relationships and insert the pivot table from the Data Model. In both methods, new data only needs a refresh. 🎓 500,000+ enrolled in our courses. Learn Pivot Tables step by step 👉 https://link.xelplus.com/yt-g-multipl... 00:00 Two ways to build a pivot table from multiple sheets 01:28 Method 1: Combine sheets with the same columns 02:39 Load the tables to Power Query 04:03 Append the tables into one query 05:05 Load the combined data to a pivot table 05:25 Add a Store column to filter by store 06:44 Method 2: Combine tables with relationships (no VLOOKUP) 07:48 Create a relationship between the tables 09:22 Insert a pivot table from the Data Model 10:33 Wrap up 🎬 Pivot Tables for Beginners:    • Excel Pivot Table EXPLAINED in 10 Minutes ...   ➡️ Join this channel to get access to perks:    / @leilagharani   ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram:   / lgharani   LinkedIn:   / leilagharani   #excel #pivottables #powerquery