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

Introduction To Excel Power Query [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 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.

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

Open the Power Query Editor

If you have cell selected in the output table from a Power Query, you can press, in sequence (not held down) the following keys Alt P U E to open the Power Query Editor window.

Related Posts

 

One Minute to Excel #11 – Add % to a Pivot Table

It is not intuitive

Often people perform calculations off to the right of Pivot Tables to calculate percentages.

In this short video I show you those calculations can be done inside the Pivot Table itself.

The solution is not intuitive, but it is easy.

This example builds upon the previous One Minute to Excel post.

Pivot Table Shortcuts

Here’s a couple of useful keyboard shortcuts for Pivot Tables.

Display/Hide the Pivot Table Field List – this list lets you create or change the Pivot Table.

Alt J T L  – pressed in sequence, not held down.

 

To add Subtotals above the entries in an existing Pivot Table.

Alt J Y T T – again pressed in sequence, not held down.

Related Posts

One Minute to Excel #10 – Create a Pivot Table

It is easy

Note sure why, but Pivot Tables are often seen a “hard” or “advanced”.

In the short video we see how easy they are.

Oops – I go over my one minute time limit by a few seconds because I format the Pivot Table as well.

One Minute to Excel #9 – Drop down list in a cell

Three techniques

This short video covers different ways to insert a drop down list into a cell.

I go over my one minute time limit by a couple of seconds, but I do cover three techniques.

Excel’s Formatted Tables [Video]

Free webinar recording

Learn about Excel’s powerful Table feature that treats tables like little databases.

I ran this free live webinar in March 2021.

You can access the pdf manual and example file by clicking the button below the video.

Download Materials

One Minute to Excel #8 – Incrementing a Long List of Dates

It is easy when you know how

In this short video I cover how to increment dates in long ranges.

It uses a little know dialog.

One Minute to Excel #7 – Copy Date down a Long Range

Quick and easy technique

In this short video I cover how to insert dates in long ranges.

Its simple and quick.

One Minute to Excel #6 – Add Subtotals Automatically

Built-in feature

In this short video I cover how to insert automated subtotals.

Its a built-in feature, that is easy to use.

One Minute To Excel #5 – Extracting Unique Entries

Three techniques

In previous videos I worked with duplicated entries.

In this video I demonstrate how to extract unique entries from a list.

Three different ways in 60 seconds.

Off we go!

 

One Minute to Excel #3 – Filling in the blanks

No blank looks

Imported data often has missing entries you need to populate.

You can use Power Query, but that duplicates the table.

This technique works on the existing table and is quick and easy to apply once mastered.

Start the clock!

One Minute to Excel #2 – Identify Duplicates

Short, sharp video tips

In the previous video I removed duplicates, in this video we identify duplicates using Conditional Formatting.

I identify the duplicates twice in a minute in this video.

The clock is ticking.

One Minute to Excel #1 – Remove Duplicates

Working against the clock

I have started a new series of short videos showcasing Excel’s features that work in less than a minute.

There is a countdown to see if I can do it.

In this first one I remove duplicates in less than a minute.