It's Magic, No It's Excel Power Query! Combining a Folder of Files Into ONE Spreadsheet
Автор: DoIT Training at Stony Brook University
Загружено: 2025-09-17
Просмотров: 237
Описание:
Ever wasted hours copying and pasting to combine multiple spreadsheets? No more! Learn how to use Excel Power Query to automagically clean and combine all the files in a folder into one spreadsheet AND update the sheet in a click when files are added!
#spreadsheets #excel #powerquery #combinefilesinexcel #nocopypaste #excelmastery #itsnotmagicitspowerquery
0:00 Intro
0:46 Open a new Excel
1:03 Get Data from Folder
1:38 Set Rules for which files in folder to to combine
1:51 Power Query Tour
3:32 Combine Data
4:55 Clean Data
7:51 Load Data to Sheet
8:36 Add new files to folder and refresh/update sheet
Slides: https://docs.google.com/presentation/...
Demo Files to follow along: https://drive.google.com/drive/folder...
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
