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
    • 605 KB
    PQ-Tips-Examples.zip
    • 29.4 KB
    PQ-Tips-2025.xlsx
    • 154 KB
    PQ-Tips-2025-completed.xlsx
    • 591 KB

    Session Recording (August 2025)

    Excel Power Query Tips recording
    • 57 mins
    • 197 MB