Category Archives for "Excel Tips"

How to Calculate Compound Annual Growth Rate (CAGR) in Excel

If you’re into and financial planning or analysis, you must have heard about the Compound Annual Growth Rate (or CAGR). In this tutorial, you’ll learn different ways to calculate the CAGR in Excel: Using Operators Using the POWER function. Using RATE function. Using the IRR Function. But before we dive into how to calculate CAGR […]

Continue reading

6 How to Make Negative Numbers Show Up in Red in Excel

If you work with a lot of numbers in Excel, it’s a good practice to highlight negative numbers in red. This makes it easier to read the data. There are various techniques you can use to highlight negative numbers in red in Excel: Using Conditional Formatting Using Inbuilt Number Formatting Using Custom Number Formatting Let’s […]

Continue reading
1 2 3 24