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.

Wednesday, July 10, 2019

How to Show Formulas in Excel

This short video shows how to display formulas in the all the cells of a worksheet.  By default when you put a function or formula in a cell and it calculate (hopefully without error), you will see the eventual output.  However in some cases you may want to view all the formulas or functions in your worksheet.  This video shows two ways it can be done.