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 of WORK in Excel was the title of my presentation [...]
Excel Office Hour: Tips for more productivity with Power Query in Excel
On May 11, 2021, I presented Tips for more productivity with Power Query in Excel for the [...]
Excel Weekend 7 – M code tips to achieve more with Power Query
On June 12, 2021, I presented M code tips to achieve more with Power Query. We looked at some [...]
Dealing with dates prior to 1900 in Excel with Power Query
If you need to work with dates prior to 1900 in Excel, you may expect a few tough challenges. [...]
Toronto Meetup Group: Power Query Fundamentals to help you with your Excel Reporting Tasks
On January 6th, 2021, I presented to the Toronto Meetup Group.I presented some business case scenarios and offer some tips [...]
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 Power BI & Modern Excel User Group Meetup hosted by [...]