Excel Power Query and Multiple Files 2022

Webinar recording from April 12, 2022

This is the recording of the second free Power Query webinar I ran in 2022.

You can watch the first one at this link.

In this session we see how to import multiple files in one Power Query. We look at importing CSV and Excel files.

You can download the materials, including a detailed pdf manual using the button below.

Download materials

One Minute to Excel #25 – Find the breakeven point

Goal Seek solution

If we have a simple Profit and Loss and we want to figure out a breakeven point, we can use Goal Seek to find it.

We can also use it to see sales required to meet a certain profit.

All in less than in minute.