In this video, we import multiple files that contain multiple sheets from a folder into one Excel table.
This is a hugely powerful technique, yet it is quick and easy to do with Power Query.
Download the files to follow along with the tutorial https://www.computergaga.com/_excel/f...
In this example, we have four Excel workbooks that contain six worksheets. We only need four of these sheets, so will filter two out in the process.
The data from all four sheets and all four files will be stacked into one table and then a PivotTable created from it.
Find more great free tutorials at;
https://www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1