Download the featured files here: https://www.bluepecantraining.com/wp-content/uploads/2023/02/Bank-Statements.zip

In this Microsoft Excel video tutorial I demonstrate how to combine multiple workbooks (stored in the same folder) in a single workbook. The method shown in this video uses Power Query.

Table of Contents:

00:00 - Introduction
00:15 - Create a 'From Folder' query in Power Query
00:37 - Exclude non-Excel files.
01:47 - Apply data transformations
05:47 - Edit the query
06:18 - Add more workbooks to folder and update data in the combined file
------------------------