Excel Power Query and Multiple Files [one hour video]

Includes detailed pdf manual

Getting data into Excel and in the correct layout and format is the important starting point for any Excel project.

Power Query can automate the importation process. It is now a vital skill to possess.

This is a follow up session to the Introduction session which you can view here.

This session focuses on importing multiple files from a folder. The session uses CSV and Excel files plus Excel tables.

This is a video of a free live training session I ran in May 2021 – over 100 people attended – please share this resource with friends and colleagues. No editing has been done to the video.

(Apologies I did have a coughing fit – I thought I had turned off the microphone but I hadn’t.)

Use the button below to download the pdf manual and example files so you can follow along.

We need to get the word out on this powerful Excel feature.

(Note: Power Query is also part of Power BI, the skills you learn also apply to that.)

Download Materials

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

2 thoughts on “Excel Power Query and Multiple Files [one hour video]

  1. Hi, I have a query related to power query or importing a excel sheet i mean to say only single Excel sheet not excel file in excel sheet i have multiple tables which i want to do analysis on them but if they do not have any relationship in common can we model them or connect them together or not.

    • Hi Mohammed
      Without seeing the data it is hard to say. But you can create a mapping table to relate two separate tables together.
      You can send me an example with what you want to achieve at a4@iinet.net.au and i can see what is possible.