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.

Create a Stacked Column or Bar Chart

Column charts provide a quick way to compare data. A variant of the column chart is a stacked column chart which visually shows how different parts of the total stack up to each other. Think of it as a pie chart, but in a horizontal column or bar format. See this video to learn how to create a stacked column, 100% stacked column or stacked bar chart.

Perform a Lookup with Multiple Criteria

If you've perform lookup before it's usually looking up something with one criteria (i.e., finding the sales for SKU 123). But what if you had multiple criteria to lookup like sales for SKU 123 that are blue and size is small? Wow that's a lot of criteria to put into a lookup function. But it's actually not that hard to do. In this video I'll show two example of how you can accomplish this task. Check out the video!