Excel Yourself/Excel Power Query Tips

Excel Power Query Tips

Pick up a few tips that make using Power Query easier.

Power Query is the best way to import data into Excel.

  • Free

Excel Power Query Tips

Power Query simplifies importing data into Excel. These tips help to make using Power Query a bit easier. Tips covered relate to. -listing errors -data types and why they are important -financial year hack -IFERROR in Power Query? -renaming steps -adding notes to steps -default settings Version: All Versions Recorded: August 2025 Level: Intermediate Duration: 1 hour Price: Free

Contents

Power Query in Excel

Materials

The PDF manual can be printed out and you can make notes in it.

The completed file Excel file won't work for the CSV files unless you modify the SOURCE steps to match the folder path on your system.

The zipped folder needs to be unzipped and saved to your system so you can follow along with the recording or the manual.

PQ-Tips-2025.pdf
PQ-Tips-Examples.zip
PQ-Tips-2025.xlsx
PQ-Tips-2025-completed.xlsx

Session Recording (August 2025)

Excel Power Query Tips recording