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!

How To Convert Column Data Fields To Row Data Fields

Sometimes you have columns doing double duty as a data. This video shows how to convert or move a column field into a row data field using the consolidated range option in the pivot table wizard.

Create a Basic Control Chart

If you're in working in an manufacturing operations role or taking business operations class you'll be familiar with keeping the parts production in a certain range. You don't want too much variation in how something is made. One of the tools to report on this process is a control chart or also known as a Shewart chart. Check out video on how to create a basic control chart.