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.

Create a Column Chart Showing Percentages

This video show how to add percentage labels to a column chart. A percentage (%) label is not a feature in columns charts like a pie chart, but there are workaround to add those in. This video covers a couples ways to do that.