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.

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.

Create a Scrolling Table

It's fairly easy to create a table in Excel, but when it gets large you have to use the the arrows to scroll up and down. But what if you want to constrain the table to a fixed row height and perform scrolling within the table? This can actually be done with some Excel functions and it's not as hard as you might think. See this video to learn how to create a scrolling table that lets your scroll through a range from a larger table.