Pivot Tabelle aus ZWEI Excel Tabellen erstellen und aktualisieren

► 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