VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel

Albright, S.

ISBN 10: 1285869613 / ISBN 13: 9781285869612

Published by Cengage Learning, 2015

About this Item

This copy may contain significant wear, including bending, heavy writing, tears, and or water damage. This book is a functional copy, not necessarily a beautiful copy. Copy may have loose pages. May not include access codes or CDs. May be an Ex library book with stickers and stamps. Dustjacket may be missing.

Seller Inventory # GBV.1285869613.A

Bibliographic Details

• Title: VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel
• Publisher: Cengage Learning
• Publication Date: 2015
• Language: English
• ISBN 10: 1285869613
• ISBN 13: 9781285869612
• Binding: Soft cover
• Edition: 5th or later Edition
• Condition: acceptable

About this title

Synopsis

Now you can master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office. VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E teaches you how to automate common spreadsheet tasks as well as create the sophisticated management science applications needed in business today. The first half of the book introduces you to the fundamentals of VBA for Excel. The second half of the book puts knowledge into action as it illustrates how to automate a number of management science models using VBA. You learn how to create user-friendly interfaces for inputs and results. This new edition improves code readability, introduces PowerPivot and the new Excel Data Model and shows you how to pass information between modules and user forms while avoiding the use of global variables. VBA FOR MODELERS, 5E offers insights you need to maximize your skills in VBA.

About the Author

S. Christian Albright received both his B.S. degree in mathematics and his Ph.D. in operations research from Stanford University. He then taught in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University until his retirement in 2011. He has taught courses in management science, computer simulation and statistics to all levels of business students, including undergraduate, M.B.A. and Ph.D. students. He has published more than 20 articles in leading operations research journals in applied probability. After retiring, he worked for several years for the Palisade Software Company and is the author of several successful textbooks.