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.

Tuesday, April 2, 2019

Create a Horizontal Scrolling Table

You may have seen how to create a scrolling table to scroll vertically (up and down), but what if you wanted to go horizontally (side to side). Well this video will show you how to create a scrolling table that scrolls horizontally. This video show the steps on how to create it using the scroll bar form control and the OFFSET function.