How to change the font size in the formula bar in Excel
I can think of a few reasons why we would want to change the font size in Excel’s formula [...]
How to improve your Excel skills
On May 16, 2023, I was a panellist on the FP&A Today podcast along with 2 other MVP’s, Mark Proctor [...]
Power Query Magic – The One with Celia Alves
On June 12, 2022, I was delighted to be the guest on Power Query Magic Podcast with host Wyn [...]
How to make Power Query refresh on a protected sheet in Excel
Power Query in Excel does not allow refreshing queries that load to tables in protected sheets. To refresh [...]
How to make VBA wait for Power Query
Making VBA wait for Power Query to complete refreshing all queries has been challenging for me a couple of [...]
How to Set Connection Only as Power Query’s Default Loading Destination in Excel
Power Query’s default loading destination in Excel is to load a query to a Table in a new worksheet. [...]