Tuesday, April 9, 2019

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.




Monday, April 8, 2019

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.


Wednesday, April 3, 2019

Create a Risk Assessment Chart

This video covers how to create a colored (green-yellow-red) risk assessment chart. This is used in project management to compare risk to probability for various task or projects to help aid in decision making.