Excel rounding vs Power Query rounding: WARNING They are different

The term “rounding difference” commonly describes something insignificant; it rarely raises cause for concern. However, when you discover that Excel rounding and Power Query rounding are different, you suddenly realize that it can be a bigger issue than you first thought. This post explains the different rounding methods in Excel and Power Query, and how Read More

7 ways to remove additional spaces in Excel

The space character for an Excel user can be a real problem. When exporting data from various IT systems, that export will often include extra spaces around values. Finding and removing additional spaces is a crucial skill for every Excel user. We often can’t see the space characters, but Excel sees them. This can cause Read More

Calculate CAGR in Excel (Compound Annual Growth Rate)

In this post, we are looking at how to calculate CAGR in Excel. CAGR stands for Compound Annual Growth Rate; it calculates the annual percentage growth over a period of time, where the growth is compounded each year. The compound annual growth rate is often used in finance to understand how different investments have performed Read More