Create Two Pie Charts in One

What is better than having one pie chart? Having two pie charts! But not separate...instead having them be together. Like having one pie chart on top of another. This video will cover how you can create two pie charts in one. Though it looks like a pie chart, it really isn't. This is actually a doughnut chart and making it look like a pie chart. See the video to learn how to make it.

Create a Full Outer Join in Excel Power Query

If you wanted to merge two tables together to figure out what records may have "missing', blank or null values in the fields, a full join or full outer join may be the solution for you. The use for this type of join can be for reconciliation or trying to discover what type of values you don't have from one table to another. If you want to see all records from table, look into using the full outer join merge capability in Excel Power Query.

Grouping Items in an Other Category

If you're modifying a list of items and wanted to categorize them in a few category names and have everything else in some general Other bucket it's fairly easy to do with the SWITCH function. Better to do this than using nested IF functions, which can get pretty long. Check out the video to see how it works.