Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses

Struggling to create PivotTables using data from different tables? This video is your solution! We dive into a practical, easy-to-understand guide on using Excel's Data Model for efficient reporting.

⬇️ Download the workbook here: pages.xelplus.com/merge-multiple-tables-file

Creating a Pivot Table in Excel based on multiple tables or multiple sheets can be tricky. Often Lookup functions like VLOOKUP are used to consolidate the information in a new table. This can significantly increase the size of the spreadsheet and make it slow.

Key Highlights:
▪️ Crafting a PivotTable with Customer Sales & Quantity Sold by Article
▪️ Using Excel's Data Model to Simplify Data Merging
▪️ Easy Steps to Create Relationships between Tables
▪️ Creating Visually Clear and Informative Reports
▪️ Tips on Hiding Unnecessary Data Fields for Clarity

In this video I'll show you a better alternative to combine data in a pivot table. We will keep the source tables as they are but we'll build a report based on relationships in PowerPivot. Based on this data model in Excel we can setup PivotTables and access the information from all tables.

00:00 Create a PivotTable with from Multiple Tables
01:47 Using the Excel Data Model to Merge Data from Different Tables
02:47 Create Relationships between Different Excel Tables
05:10 Diagram View in Excel PowerPivot
06:00 Create a Pivot Table from the Excel Data Model
09:56 Join Leila's Ultimate Power Query Course

Complete Power Query Playlist: youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-

Power Query complete course: xelplus.com/course/excel-power-query/

➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz/

🎥 RESOURCES I recommend: xelplus.com/resources/

🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

• Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in Excel ( Download)
• Excel - Combine Multiple Tables - Relationships (PivotTables) and XLOOKUP ( Download)
• Using Power Pivot Relationships for Pivot Tables | Everyday Office ( Download)
• Relationships in Pivot Tables in Excel ( Download)
• Properly Handle Date Grouping and Missing Dates in Excel Pivot Tables (show all dates) ( Download)
• Excel - How To Use Relationships In Excel Pivot Tables - Duel 161 - Episode 1898B ( Download)
• Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model) ( Download)
• Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List ( Download)
• Advanced Pivot Table Techniques (to achieve more in Excel) ( Download)
• Pivot Table Relationship in Excel | How to Connect Tables from Multiple Sheets in Excel ( Download)
• Excel Magic Trick 1450: Replace VLOOKUP When Making PivotTables with Excel 2016 Relationships ( Download)
• DAX CALCULATE Trick to Pass Filters from Many to One Side of Relationship ( Download)
• Create a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial! ( Download)
• Pivot Table Excel Tutorial ( Download)
• Learn Power Pivot in Excel (Better Than Pivot Tables) ( Download)