Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Import Multiple Excel Files & Sheets into Excel - Power Query Get & Transform

ExcelIsFun via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn how to use Power Query (Get & Transform) to import and combine multiple Excel workbooks and sheets into a single file. Discover techniques for appending and merging data from various sources, extracting file names and sheet tabs, and incorporating them into your dataset. Build dynamic PivotTables that update automatically when new files are added to a folder. Explore the creation of formula helper columns in Power Query and master the Number.Round function. Perfect for those seeking to streamline data consolidation and analysis across multiple Excel files.

Syllabus

) Introduction to Append Multiple Workbooks and Merge Multiple Workbooks.
) Append Multiple Workbooks into a single table from Multiple Excel Files, and build PivotTable using Power Query From Folder feature. See how to extract File Name and Sheet Tab and incorportate them into the Data Set..
) Build PivotTable.
) Add new files to folder and PivotTable updates..
) Merge Multiple Workbooks into a single table from Multiple Excel Files using Power Query From File feature..
) Create Formula Helper Column in Power Query and learn about Number.Round Power Query Function.
) Summary.

Taught by

ExcelIsFun

Reviews

Start your review of Import Multiple Excel Files & Sheets into Excel - Power Query Get & Transform

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.