You can set up a relationship with two or more tables in Excel to create a PivotTable. XLOOKUP and VLOOOKUP also work, but you can skip those great functions and set up Relationships. For example, one Excel table contains the Employee ID and name. A second table contains the Employee ID, Department Name, Date of Hire, Location, and other information. If I want to see the employee's name and other information from the second table, I can set up a relationship with a Primary Key and a Foreign key.
Screenshot of Relationships [ Ссылка ]
Chapters/Bookmarks
0:00 Intro
1:30 XLOOKUP
3:42 Set up relationships
Title Watch Url
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips [ Ссылка ]
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY [ Ссылка ]
Teams Online Course Promotion [ Ссылка ]
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total [ Ссылка ]
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting [ Ссылка ]
Excel - Filter a PivotTable with a Timeline [ Ссылка ]
PivotTables - 3 Annoying Things FIXED! [ Ссылка ]
Excel Add Sparklines on a Separate Worksheet [ Ссылка ]
Excel Chart Maps used with the Geography Data Type [ Ссылка ]
Excel Concatenate Text and Dates with the TEXT function [ Ссылка ]
Tasks by Planner in Teams - Recurring Tasks - New Feature [ Ссылка ]
Excel - Insert a blank row after every row or every Nth row [ Ссылка ]
#chrismenardtraining #exceltraining #msexcel #chrismenardtraining
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]
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!
![](https://i.ytimg.com/vi/AJ4rsuYrkNs/maxresdefault.jpg)