Using Excel to track property rent and expenses | 02 of 02 – Getting the overview with a pivot table

Published: Fri, 11/22/13

The Excel Expert

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

Using Excel to track property rent and expenses | 02 of 02 – Getting the overview with a pivot table- 2013-11-18 07:49:11-05

In the first of these blog posts I showed you how to set up your data entry sheet to make it pivot table friendly. Now in this blog post we are going to use pivot tables to show the following… Analysis of each property’s performance (using total income) for a year Analysis of each property’s [...]
Read more...