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.

Count Unique or Duplicate Values in a List

Have you ever had a friend yelled random numbers at you while you're counting values? Aside from wanting to toss your friend in a lake you'd like to have an easier way to count these numbers to tell which are unique and which are duplicates. If the list is small that not a probably to do this type of analysis. If the list is big then forget trying to do it in your mind. Why not just use Excel? It's basically a sophisticated counting application. There's actually a function in Excel called COUNTIF and it counts stuff that meets a criteria. Check our the video below to see how's it all done.