Aging debtors analysis | Using Today() and vlookups or how to know who you need to send to the Sopranos

Published: Fri, 06/06/14

The Excel Expert

Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users

Aging debtors analysis | Using Today() and vlookups or how to know who you need to send to the Sopranos- 2014-06-02 05:37:33-04

I was recently teaching a class on Powerpivot and the subject came up of how to use Excel to construct an aging analysis. The person had already created some serious serious formulas to do what he needed to do so no point in re-inventing the wheel. His big interest was how to do all that [...]
Read more...