Facebook Twitter Pinterest <Einbetten>
EUR 161,87
  • Alle Preisangaben inkl. MwSt.
Nur noch 2 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.
VBA for Modelers: Develop... ist in Ihrem Einkaufwagen hinzugefügt worden
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Hörprobe Wird gespielt... Angehalten   Sie hören eine Hörprobe des Audible Hörbuch-Downloads.
Mehr erfahren
Alle 3 Bilder anzeigen

VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel [With Access Code] (Englisch) Taschenbuch – 26. August 2011


Alle Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Preis
Neu ab Gebraucht ab
Taschenbuch, 26. August 2011
EUR 161,87
EUR 31,53 EUR 425,24
6 neu ab EUR 31,53 2 gebraucht ab EUR 425,24
-- Dieser Text bezieht sich auf eine andere Ausgabe: Taschenbuch.
click to open popover

Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.

  • Apple
  • Android
  • Windows Phone

Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.

Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


Produktinformation

Produktbeschreibungen

Pressestimmen

Part I: VBA FUNDAMENTALS. 1. Introduction to VBA Development in Excel. Introduction. VBA in Excel 2007 and 2010. Example Applications. Decision Support Systems. Required Background. Visual Basic Versus VBA. Some Basic Terminology. Summary. 2. The Excel Object Model. Introduction. Objects, Properties, Methods, and Events. Collections as Objects. The Hierarchy of Objects. Object Models in General. Summary. 3. The Visual Basic Editor. Introduction. Important Features of the VBE. The Object Browser. The Immediate and Watch Windows. A First Program. Intellisense. Color Coding and Case. Finding Subs in the VBE. Summary. 4. Recording Macros. Introduction. How to Record a Macro. Changes from Excel 2007 to Excel 2010. Recorded Macro Examples. Summary. 5. Getting Started with VBA. Introduction. Subroutines. Declaring Variables and Constants. Built-In Constants. Input Boxes and Message Boxes. Message Boxes with Yes and No Buttons. Using Excel Functions in VBA. Comments. Indenting. Strings. Specifying Objects, Properties, and Methods. With Construction. Other Useful VBA Tips. Good Programming Practices. Debugging. Summary. 6. Working with Ranges. Introduction. Exercise. Important Properties and Methods of Ranges. Referencing Ranges with VBA. Examples of Ranges with VBA. Range Names and Their Scope. Summary. 7. Control Logic and Loops. Introduction. Exercise. If Constructions. Case Constructions. For Loops. For Each Loops. Do Loops. Summary. 8. Working with Other Excel Objects. Introduction. Exercise. Collections and Members of Collections. Examples of Workbooks in VBA. Examples of Worksheets in VBA. Examples of Charts in VBA. Summary. 9. Arrays. Introduction. Exercise. The Need for Arrays. Rules for Working with Arrays. Examples of Arrays in VBA. Array Functions. Summary. 10. More on Variables and Subroutines. Introduction. Exercise. Scope of Variables and Subroutines. Modularizing Programs. Passing Arguments. Function Subroutines. The Workbook Open Event Handler. Summary. 11. User Forms Introduction. Exercise. Designing User Forms. Setting Properties of Controls. Creating a User Form Template. Writing Event Handlers. Displaying a User Form. Looping Through the Controls on a User Form. Working with List Boxes. Modal and Modeless. Working with Excel Controls. Summary. 12. Error Handling. Introduction. Error Handling with On Error Statement. Handling Inappropriate User Inputs. Summary. 13. Working with Files and Folders. Introduction. Exercise. Dialog Boxes for File Operations. The File System Object. A File Renaming Example. Working with Text Files. Summary. 14. Importing Data into Excel from a Database. Introduction. Exercise. A Brief Introduction to Relational Databases. A Brief Introduction to SQL. ActiveX Data Objects (ADO). Discussion of the Sales Orders Exercise. Summary. 15. Working with Pivot Tables and Tables. Introduction. Working with Pivot Tables Manually. Working with Pivot Tables Using VBA. An Example. Working with Excel Tables Manually. Working with Excel Tables with VBA. Summary. 16. Working with Ribbons, Menus, and Toolbars. Introduction. Customizing Ribbons in Excel 2010. Using RibbonX and XML to Customize Ribbons. Using RibbonX to Customize the QAT. CommandBar and Related Office Objects. A Grading Program Example. Summary. 17. Automating Solver and Other Applications. Introduction. Exercise. Automating Solver with VBA. Possible Solver Problems. Programming with Risk Solver Platform. Automating Palisade Add-Ins with VBA. Automating Other Office Applications with VBA. Summary. 18. User-Defined Types, Enumerations, Collections, and Classes. User-Defined Types. Enumerations. Collections. Classes. Summary. Part II: VBA MANAGEMENT SCIENCE APPLICATIONS. 19. Basic Ideas for Application Development with VBA. Introduction. Guidelines for Application Development. A Car Loan Application. Summary. 20. A Blending Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. 21. A Product Mix Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 22. A Worker Scheduling Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 23. A Production Planning Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. 24. A Transportation Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Access Database. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form and Its Event Handlers. The VBA Code in the Module. Summary. 25. A Stock Trading Simulation Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The Module. Summary. 26. A Capital Budgeting Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 27. A Regression Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 28. An Exponential Utility Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 29. A Queuing Simulation Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The Structure of a Queuing Simulation. The Module. Summary. 30. An Option Pricing Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 31. An Application for Finding Betas of Stocks. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. 32. A Portfolio Optimization Application. Introduction. Functionality of the Application. Running the Application. Web Queries in Excel. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. 33. A Data Envelopment Analysis Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets and the Text File. Getting Started with the VBA. Getting Data from a Text File. The Module. Summary. 34. An AHP Application for Choosing a Job. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. -- Dieser Text bezieht sich auf eine andere Ausgabe: Taschenbuch.

Über den Autor und weitere Mitwirkende

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(R). Dr. Albright has published more than 20 articles in leading operations research journals in the area of applied probability. He has also published a number of successful textbooks, including DATA ANALYSIS AND DECISION MAKING, DATA ANALYSIS FOR MANAGERS, and SPREADSHEET MODELING AND APPLICATIONS. -- Dieser Text bezieht sich auf eine andere Ausgabe: Taschenbuch.

Kundenrezensionen

Es gibt noch keine Kundenrezensionen auf Amazon.de
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Stern

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: 3.6 von 5 Sternen 11 Rezensionen
18 von 19 Kunden fanden die folgende Rezension hilfreich
1.0 von 5 Sternen Good Content but no Excel Sheets for People outside USA 9. November 2012
Von Amazon Customer - Veröffentlicht auf Amazon.com
Format: Taschenbuch
I reside in India and I purchased the book but there was no mention of the site to download the excel sheets from. I wrote to the publisher but still no access. It is just the tactics to publish the old editions of the books prevalent in USA. There is nothing wrong with this approach but for a book like this where the entire value lies in the accompanying the publisher refuses to provide it then its outright outrageous and of no use. Buying the book without accompanying excel sheets is just like throwing money down the drain.
12 von 12 Kunden fanden die folgende Rezension hilfreich
2.0 von 5 Sternen Avoid CENGAGE Learning Books if you're not a student! 5. Mai 2013
Von Andrew Wheelwright - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
This text uses an online solution provided by CENGAGE Learning ([...]) for accessing the necessary code samples. Unless you are a student or are willing to lie about it (which you should not do), you will not be able to access the online materials. The website is poorly designed with significant reliability and design issues (frequent timeouts, the inability for non-academic users to create accounts, the inability for non-account holders to submit support requests to customer service, etc).

If you are a student then read on. This book is for non-programming business professionals and is intended as a rough and limited introduction to Visual Basic for Applications as it applies to Microsoft Excel in context of business modeling. Most of the book discusses business models for which the author assumes prior knowledge of business management and for which the author suggests his book "Practical Management Science". If you are a professional developer, this book is not for you and will provide limited value. If on the other hand, your a business manager with minimal programming experience and want to enhance your skills and decision making tools, this book will be very helpful to you.
6 von 6 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen VBA for Modelers: good book, bad product 24. Juni 2013
Von Amazon Customer - Veröffentlicht auf Amazon.com
Format: Kindle Edition Verifizierter Kauf
VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel - Kindle version
This is a very good book if we look to the content: good tutorials on VBA, very useful examples, clear explanations.
But, unfortunately, it is a bad product. There is no access to the codes, as promissed in the preface:
"The companion Web site for this book can be accessed at www.cengagebrain.com. There you will have access to all of the Excel (.xlsx and .xlsm) and other files mentioned in the chapters, including those in the exercises."
At such site there is a box for product registering, but the access code (should be similar to PP8XLP3XD528HC, as informed there) was never provided.
Also, if we spend a time trying to obtain any support, we only find FAQ technical support and sales support. By trying to register a question, after filling a series of boxes, we must inform the educational institution. As a common customer isn't linked to any institution, in practical terms, it is impossible to register the customer or the book in this site.
So, if you like to read extreme small letters (all the codes are small images which size is always the same small, independent of text size you set), if you like to type large codes and if you like to support yourself, then this book is for you.
7 von 8 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Well-written, fun and useful 25. November 2011
Von Chaz McCaz - Veröffentlicht auf Amazon.com
Format: Taschenbuch
This is easily the best book I have ever seen on learning and using VBA for Excel. Unlike the "Dummies" series, this book is geared more towards those with operational or analytic inclinations (not just simply formatting or automating a spreadsheet). However, the first half of the book is also suitable for any VBA beginner that is interested in starting from the ground up. The second half has some very interesting and fun examples from OR/mgmt science/decision science that could actually be used on the job. Yet they are fun enough to work through even if you're not in that field, and don't require any "high-level" math to understand.

I'd say the main strengths of the book are as follows:

1)Very well written - I got the sense that the author went through a ton of trial and error (and googling) to figure out how to do the things he teaches in this book. Hence, it is written from the perspective of a real user rather than a typical computer book author who recycles old and sometimes suspect information from other sources without fully understanding it.
2)Comprehensive examples - the author never leaves you hanging without examples to illustrate what he teaches. Virtually every point comes with code examples that can be used to complete the exercises at the end of the chapters.
3)Comprehensive premium online content - the book comes with free access to premium online content that includes code examples in pre-constructed spreadsheets (so you can actually see how it works) and code-free spreadsheets for the exercises (the author gives you the data and your job is to write code for it). You also get to learn how to integrate code with Excel Solver and @Risk (you get limited access to @Risk with the book).
4)Interesting problems - the author gives some classic mgmt science problems (e.g. Travelling Salesman) and shows you how to use VBA to solve the problem. It is very fun to work the problems and actually becomes kind of addictive. Later in the book the problems become more advanced and range from scheduling to stock trading.

The Dummies books may be cheaper but this book is far better. Also, the problems and examples in this book are much more interesting that what you find elsewhere, so it actually motivates you to learn the material.
2 von 2 Kunden fanden die folgende Rezension hilfreich
1.0 von 5 Sternen Did NOT include Access Card 16. Januar 2013
Von BaDnNC - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
I would attempt to return this item but my class has started and I need the book. It looked brand new and was packaged like new, but when I went to attempt to open the envelope for the access card there was nothing in it and the top of the envelope was NOT sealed. This is very frustrating because I'm stuck now without the files needed for the book.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.