Import Data from Multiple Excel Files from a Folder using Power Query

Опубликовано: 22 Октябрь 2018
на канале: Computergaga

106,952

711

In this video we import data from multiple Excel files from a folder using Power Query.

It is amazing how simple this can be with Power Query in modern Excel. Then we can refresh that connection and import more files, or changed files with one click in the future.

This video shows the process of importing all the files from a folder quickly. And then updating when changes are made.

The video then demonstrates 2 common issues you may encounter and provides the solution to them.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ►   / 18737946
Instagram ►   / computergaga1
Twitter ►   / computergaga1