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 [...]
Rounding in Power Query – The default rounding mode and the binary-decimal conversion issue in Excel
There are two things about Power Query and Excel [...]
MrExcel 2021 – Unmasking Excel – PDF
The Fifth edition of Bill Jelen´s [...]