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!
Wednesday, July 17, 2019
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 https://youtu.be/sb81XE_jPd
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.
Subscribe to:
Posts (Atom)