Presentations in English containing training content.
How to share workbooks with data resulting from Power Query without allowing other users to refresh the queries
Power Query is all about creating a refreshable connection [...]
Parameters and Custom Functions in Power Query in Excel
On Jan 27, 2022, I presented to the Baku [...]
M Code Tips to achieve more with Power Query
On Nov 8, 2021, I had the pleasure to [...]
A Bit of Excel – Power Query: The tool that can save you Hours of WORK in Excel
Power Query: The tool that can save you Hours [...]
Excel Office Hour: Tips for more productivity with Power Query in Excel
On May 11, 2021, I presented Tips [...]
Excel Weekend 7 – M code tips to achieve more with Power Query
On June 12, 2021, I presented M code tips [...]
Dealing with dates prior to 1900 in Excel with Power Query
If you need to work with dates prior to [...]
Toronto Meetup Group: Power Query Fundamentals to help you with your Excel Reporting Tasks
On January 6th, 2021, I presented to the Toronto Meetup [...]
Vancouver Power BI & Modern Excel User Group Meetup: The New Power Query Custom Data Types in Excel
On November 5th, 2020, I presented to the Vancouver [...]
How to Copy a Power Query query from one Excel workbook to another one
Have you ever wanted to repeat in another workbook [...]