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
Table of Contents
Your Computer. Introduction to Excel Formulae and Operators. Formatting Cells. Valuation Tables. Standard Valuations. Some Useful Tools. Discounted Cash Flow. Charts. More Valuations. Using Excel for Managing Data. Viewing the Worksheet. More Uses for Excel. Other Facilities in Excel. Printing. Security. Appendix 1: Formulae for the Creation of Valuation Tables. Appendix 2: Glossary.