Transpose Data in Power Query

In Excel you can you the copy or cut and then paste transpose to switch data from columns to rows, or vice versa. You're basically rotating data from rows to columns or columns to rows. This functionality is also available in Power Query. Most of the time you shouldn't have to bring a small data set into PQ to do any transpose of data, but if rotating data is part of your overall transformation steps there is some extra steps you need to be aware of.

 *SUBSCRIBE* to my channel at https://goo.gl/wN3c3p

Create an Exploding Pie Chart

If you wanted to get fancier then the ordinary pie charts how about making a 3D pie chart that has the slices come out from the center. In this video, I'll cover how to create a pie chart with an exploding pie slice.  Also covering how to change the rotation and adding some 3D effects.

Calculate the Interest Rate on a Car Loan

Use the Excel RATE Function to calculate the annual interest rate.  This will give you an idea how much interest you are paying if you change the monthly amount or number of payment periods.