Create and update a pivot table from two Excel tables

Опубликовано: 25 Июнь 2026
на канале: Jakob Neubauer

80,786

1.1k

► Subscribe to the channel: https://bit.ly/jakobnbr

► Pivot Table Basics:    • Excel Pivot-Tabellen ERSTELLEN 📚 Grundlage...

In this video, I'll show you how to create a pivot table in Excel from two tables, and even two files. We'll cover the basics of Power Query and how to connect data using relationships in Excel to create a pivot table.

▬ More Videos ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

► Professional Dashboards in Excel
   • Interaktives Dashboard in Excel erstellen ...

► The Most Important Excel Functions
   • 20 Excel Funktionen die JEDER können sollte

► ALL My Excel Tips & Tricks
   • Excel Tipps & Tricks

▬ My Equipment ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

In the video:

► Software: https://amzn.to/3eUCBNb
► Mouse: https://amzn.to/3ERJHwG
► Keyboard: https://amzn.to/3mPemof
► Monitor: https://amzn.to/3EMIxCJ
► Microphone: https://amzn.to/3t149cl
► Camera: https://amzn.to/3eQZpgS

Thank you for your free support through these affiliate links!

▬ About this channel ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

I'm a business education graduate from Austria and run an SEO & web design agency full-time. On this channel, you'll find tips, tricks, and tutorials about Microsoft products and working productively in the digital space.

Subscribe to my channel: https://bit.ly/jakobnbr
LinkedIn: https://bit.ly/jnbr_linkedin

▬ Timestamps ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

00:00 Intro
00:33 Preparing Files
02:20 Importing Data
06:06 Merging Tables
07:39 Creating a PivotTable
08:50 Updating a PivotTable
10:14 Recommendation