Short description
Helps students and practitioners use Mircosoft Excel to solve some of the complex problems that the surveyor may come across. This book explores how Visual Basic and macros can simplify and speed up repetitive tasks.
Long description
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 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 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'.