"Advanced Excel is the companion to the highly successful Excel for Surveyors. This volume is intended to help both students and practitioners use Mircosoft Excel(t) to solve some of the more complex problems that the surveyor may come across.
It explores how Visual Basic and macros can simplify and speed up repetitive tasks, fulfilling one of the basic aims of computing: ""If it is repetitive teach the machine to do this for you"".
The methodology of portfolio analysis is a relatively new discipline, which may be unfamiliar to many readers. The book provides an introduction to the principles and shows how Excel can help. (readers may even find this of help when assessing their own personal investment portfolios!)
Further ideas for setting up databases; how to arrange for several surveyors to work on a single project; data analysis; and the use of charts in Reports are discussed together with further advice on security and protection.
This title provides clear direction for using facilities of Excel rather than to offer a large reference tome in which it is possible to ""lose the way""."
By:
Philip Bowcock,
Natalie Bayfield
Imprint: Estates Gazette Ltd
Country of Publication: United Kingdom
Dimensions:
Height: 234mm,
Width: 156mm,
Spine: 13mm
Weight: 220g
ISBN: 9780728204133
ISBN 10: 0728204134
Pages: 128
Publication Date: 01 May 2003
Audience:
Professional and scholarly
,
Undergraduate
Format: Paperback
Publisher's Status: Active
Foreword, Preface, 1 Introduction, 2 Some of the new features in Excel, 3 Managing large worksheet models and good practice, 4 Databases, 5 Sharing workbooks, 6 Maps, 7 Protecting your workbook and setting passwords, 8 Visual Basic, 9 Regression analysis, 10 Linear programming, 11 Simulation, 12 Portfolio management, Appendix A Bibliography, Appendix B Add-Ins, Appendix C A note on Excel for Macintosh
Philip Bowcock, Natalie Bayfield
