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

=B23*(1+C14)

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.