Power Query - Import Multiple Excel Files and Combine into Proper Data Set

Power Query - Import Multiple Excel Files and Combine into Proper Data Set

Learn how to import data from multiple Excel workbook files and combine them into a single proper data set using Power Query. Master techniques for transforming file extensions, filtering Excel files, extracting file names to create new columns, using custom functions, and appending worksheets. Apply correct data types, load data to Excel sheets, and create pivot tables. Discover how to refresh queries when adding new files or changing folder paths. Gain practical skills in data manipulation and analysis through hands-on examples and comprehensive explanations of Power Query features.