Join 400,000+ professionals in our courses here https://link.xelplus.com/ytdallcou...

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

⬇ Download the workbook here: https://pages.xelplus.com/mergemulti...

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:    • Excel Power Query (Get & Transform)  

Power Query complete course: https://www.xelplus.com/course/excel...

➡ Join this channel to get access to perks:    / @leilagharani  

☕ Get the Official XelPlus MERCH: https://xelplus.creatorspring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/coursequiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram:   / lgharani  
LinkedIn:   / 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