Synopses & Reviews
Synopsis
Help your students master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office, with this essential tool. Chris Albright�s VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E provides everything you need to teach students 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 students to the fundamentals of VBA for Excel. The second half puts knowledge into action as it illustrates how to automate a number of management science models using VBA. Students learn how to use applications to present a user-friendly interface for inputs and results. This new edition improves code readability, introduces PowerPivot and the Excel Data Model and demonstrates a new method to pass information between modules and user forms that avoids using global variables.
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 his B.S. degree in mathematics from Stanford in 1968 and his Ph.D. in operations research from Stanford in 1972. Since then, he has been teaching in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University. He has taught courses in management science, computer simulation, and statistics to all levels of business students: undergraduates, MBAs, and doctoral students. His current interest is in spreadsheet modeling, including development of VBA applications in Excel. Dr. Albright has published more than 20 articles in leading operations research journals in the area of applied probability as well as a number of successful textbooks, including DATA ANALYSIS AND DECISION MAKING, DATA ANALYSIS FOR MANAGERS, and SPREADSHEET MODELING AND APPLICATIONS.