Calculate A Compound Annual Growth Rate (CAGR)

If you're familiar with business metrics or taken a business strategy course, you may have come across CAGR. It's a derived number to is used to average out the growth rate of a product or investment over a span of time. There is actually a formula that you can do by hand to calculate CAGR, but why do that when you have Excel! See the video to learn how to calculate compounded annual growth rate (CAGR) with a formula and ALSO create your own function in Excel.

Create a One Variable Data Table

Ever heard of a variable table? What about a one variable table? Well if you haven't you've step into the right place. A one variable table gives you the ability to put a variable input in and see how that input affects some outputs. For example let's say you are taking out a loan and wanted to see what your payments would be at 1%, 1.5% or etc. Instead of erasing and plugging in a different interest each time, you can just create a table that list the interest rates ranging from 1% to say 7% in .5% increments. This can be done with a one variable data table. View the video to see how it's done.

Create a BCG Matrix

If you've taken business class or familiar with management consulting strategies, you've probably come across this tool called a BCG Matrix. Also known as a growth-share matrix, the BCG matrix was created by Bruce Hendersen in the 70s (founder of Boston Consulting Group). It's a tool that helps you analyze companies or products based on a quadrant that shows growth rate and relative market share. You can actually create this fairly easily on Excel, so check out the video to learn how.