Fully Dynamic Dependent Dropdown Lists in Excel
Dependent Dropdown Lists in Excel have never been so [...]
Tips & Tricks of POWER QUERY in Microsoft Excel
On Feb 17, 2022, I presented Tips & Tricks [...]
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 [...]
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 [...]