Import Multiple Excel Files with Multiple Sheets in Excel

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/files/power-query/data.zip 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