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 that I want to tell you about in this post. [...]
MrExcel 2021 – Unmasking Excel – PDF
The Fifth edition of Bill Jelen´s 257-page book "MrExcel 2021 - Unmasking Excel" is out! You [...]
How to Copy a Power Query query from one Excel workbook to another one
Have you ever wanted to repeat in another workbook a query that you already built in one Excel workbook? [...]
2020: the Year of many Learning Opportunities
2020 was a year of many challenges and changes for all of us. However, I have always believed that [...]
How to change the display language in Excel
Different reasons might make you want to change the language in Excel. You may need Excel to be in [...]
Enable Background Refresh property in Power Query in Excel
In Power Query's properties, in Excel, we can find the "Enable Background Refresh" property, which is usually enabled by [...]