ABSTRACT

This book is an introduction to Microsoft Excel™ concentrating on the program's unique application to the work of surveyors. Useful operations such as the creation of valuation tables and automation of conventional valuations are explained with the aid of step by step examples and screen-shots. The setting up of discounted cash flow problems and development appraisals are given special attention, and specific problems posed by over-rented property and leaseholds are also considered, additionally the book includes examples of database and chart functions useful to management and agency surveyors

chapter 1|2 pages

Your computer

chapter 2|9 pages

Introduction to Excel

chapter 3|3 pages

Formulae and operators

chapter 4|6 pages

Formatting cells

chapter 5|3 pages

Functions

chapter 6|9 pages

Valuation tables

chapter 7|3 pages

Standard valuations

chapter 8|4 pages

Some useful tools

chapter 9|12 pages

Discounted cash flow

chapter 10|8 pages

Charts

chapter 11|7 pages

More valuations

chapter 12|7 pages

Using Excel for managing data

chapter 13|5 pages

Viewing the worksheet

chapter 14|11 pages

More uses for Excel

chapter 15|2 pages

Other facilities in Excel

chapter 16|5 pages

Printing

chapter 17|3 pages

Security