Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Check the Filters - Part 2

31 August 2022

Welcome to our Power Query blog. This week, I look at how the options on the Transform tab can filter a query, saving both time and steps.


Power Query: Check the Filters - Part 1

24 August 2022

Welcome to our Power Query blog. This week, I look at how checking the filter options can save time and steps.


Power Query: Double Access Savings – Part 4

17 August 2022

Welcome to our Power Query blog. This week, I combine the data from the tables in the two Access databases.


Power Query: Double Access Savings – Part 3

10 August 2022

Welcome to our Power Query blog. This week, I continue to extract the data from the tables in the two Access databases.


Power Query: Double Access Savings – Part 2

3 August 2022

Welcome to our Power Query blog. This week, I filter and expand the data in the two Access databases from last week.


Power Query: Double Access Savings – Part 1

27 July 2022

Welcome to our Power Query blog. This week, I look at how to access two Access databases.


Power Query: Keeping it Current – Part 3

20 July 2022

Welcome to our Power Query blog. This week, I complete the query to look for data in the current workbook.


Power Query: Keeping it Current – Part 2

13 July 2022

Welcome to our Power Query blog. This week, I start to convert the query to look for data in the current workbook.


Power Query: Keeping it Current – Part 1

6 July 2022

Welcome to our Power Query blog. This week, I copy a query to the workbook data has been extracted from.


Power Query: See it, Save it, Sort it - Part 7

29 June 2022

Welcome to our Power Query blog. This week, I refine my grouping and show how to preserve data order while grouping.


Newsletter