Wednesday, July 17, 2019

Use the PMT, IPMT & PPMT Functions

If you do finance or just personal finance you are probably working on interest payments.  Excel has a bunch of finance functions that help you figure out financial payments.  In this video, I'll cover the different PMT functions and check out the video to learn how to use the different payment functions (PMT, IPMT & PPMT) in Excel.

Feel free to provide a comment or share it with a friend!

Tuesday, July 16, 2019

Create a Reverse Pivot Table

How to create a database table from a summary table.  Basically creating a reverse pivot table.  This tip uses the Pivot Table Wizard (keyboard short cut ALT+D+P)

Some also call this an unpivot.

Reverse Pivot #2 video at

Monday, July 15, 2019

Create Sparklines

Did you want to have a line chart but not have it take up too much space or don't worry about all the other features needed in a line chart? If so, you may want to consider sparklines. Sparklines were popularized by Edward Tufte. This videos cover how to create a sparkline in Excel 2007.