Microsoft Office Tutorials and References
In Depth Information
Figure 13-14: Creating an index from growth data.
This formula returns 3.13%, which represents the change in retail space (from $89.4 to $92.3). This formula is
copied to the other cells in the table (range C14:H18). This information is useful, but it is difficult to track over-
all performance between periods of more than a year. That's why indices are required.
Calculating the indices in the third table is also straightforward. The 2006 index is set at 100 (column B) and is
the base for the indices. The formula in cell C23 is
This formula is copied to the other cells in the table (range C23:H27).
These indices make it possible to compare performance of, say, offices between any two years, and to track the
relative performance over any two years of any two types of property. So it is clear, for example, that industrial
property rental grew faster than retail property rentals between 2011 and 2012.