Advanced Excel for Surveyors

Philip Bowcock, Natalie Bayfield (Autoren)

Buch | Hardcover

128 Seiten

2016
CRC Press (Verlag)
978-1-138-14647-1 (ISBN)

Artikel merken

Advanced Excel for Surveyors 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 further advice on security and protection.

Philip Bowcock, Natalie Bayfield

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

Erscheinungsdatum	23.07.2016
Verlagsort	London
Sprache	englisch
Maße	156 x 234 mm
Gewicht	453 g
Themenwelt	Informatik ► Office Programme ► Excel
	Naturwissenschaften ► Biologie ► Ökologie / Naturschutz
	Sozialwissenschaften ► Kommunikation / Medien ► Buchhandel / Bibliothekswesen
	Technik ► Bauwesen
	Wirtschaft ► Betriebswirtschaft / Management ► Rechnungswesen / Bilanzen
	Betriebswirtschaft / Management ► Spezielle Betriebswirtschaftslehre ► Immobilienwirtschaft
ISBN-10	1-138-14647-1 / 1138146471
ISBN-13	978-1-138-14647-1 / 9781138146471
Zustand	Neuware