Course overview

Excel as a Database (DBMS) – Relationships, Joins, and Data Modeling

Course content10 lessons
Table Relationships and Foreign Keys in Excel as a Database Table Relationships and Foreign Keys in Excel as a Database Lesson 1 Creating Table Relationships and a Data Model in Excel Creating Table Relationships and a Data Model in Excel Lesson 2 Inner Join Between Tables with Power Query in Excel Inner Join Between Tables with Power Query in Excel Lesson 3 Left Join and Right Join in Power Query Left Join and Right Join in Power Query Lesson 4 One-to-Many Relationship in Excel: A Real-World Employee Management Case One-to-Many Relationship in Excel: A Real-World Employee Management Case Lesson 5 One-to-Many with Inner Join and Left Join in Power Query One-to-Many with Inner Join and Left Join in Power Query Lesson 6 Right Join, Full Join, and Projections with Power Query in Excel Right Join, Full Join, and Projections with Power Query in Excel Lesson 7 Many-to-Many Relationships and Junction Tables in Excel Many-to-Many Relationships and Junction Tables in Excel Lesson 8 Many-to-Many Relationships and Inner Join Across Three Tables in Power Query Many-to-Many Relationships and Inner Join Across Three Tables in Power Query Lesson 9 Completing a Many-to-Many Relationship in Excel Completing a Many-to-Many Relationship in Excel Lesson 10
Previous
Up next Next
Current lesson | Lesson 4/10

Left Join and Right Join in Power Query

Excel as a Database (DBMS) – Relationships, Joins, and Data Modeling 0%
Let's explore Left Join and Right Join in Power Query together: I'll explain when to use each one, why the join type changes the results, and how to retain data even when there's no match between tables.
Instructor
G Giovanni Pace
Up next One-to-Many Relationship in Excel: A Real-World Employee Management Case