Excel - mehrere Dateien mit mehreren Blättern und unbekannt vielen Spalten importieren - Power Query

Any number of files with varying numbers of worksheets and an as yet unknown number of structurally similar columns are to be combined into a list. Power Query allows me to run through import steps using functions. #PowerQuery #PowerBI #Excel Finally, I encountered an error that I was able to fix with a tip from my colleague Ken Puls: https://www.excelguru.ca/blog/2015/03... And here I am reading the calendars of several mailboxes:    • Excel - Mehrere Kalender abfragen und Proj...   Power Query has been an integral part of Microsoft versions of Excel since 2016. Power Query is available as an add-in for versions of Excel 2010 and later. Queries cannot be created on Macs, but they can be executed/updated. Power Query is also an integral part of Microsoft Power BI for extracting, transforming, and loading data (ETL tool) and has also become a natural precursor to importing data into Excel for later processing in, for example, pivot tables. Engaging with Power Query is one of the most worthwhile time investments! The Excel Experts series includes (peripheral) topics from my five-day seminar series for in-house training of Excel experts, which I have been conducting for my clients since 2017. Five to six full-day sessions, each one month apart, cover the following topics: Excel table functions, Power Query, pivot, charts/dashboards, and other Excel tips for, for example, form creation. This series is truly intended only for employees who already work extensively with Excel and want to take a big step forward.