Long live the King Excel and his beloved Power Query Queen!
My boss was very excited that day. He had [...]
Fully Dynamic Dependent Dropdown Lists in Excel
Dependent Dropdown Lists in Excel have never been so [...]
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 [...]
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 [...]