
Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs
by Elliot Bendoly-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
Rent Textbook
Rent Digital
New Textbook
We're Sorry
Sold Out
Used Textbook
We're Sorry
Sold Out
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Author Biography
Table of Contents
Getting Oriented | |
Necessary Foundations for Decision Support | p. 3 |
The Development Environment | p. 8 |
Fixed Data | p. 8 |
Formatting | p. 12 |
Labeling (Naming) | p. 15 |
Comments | p. 18 |
Hyperlinks | p. 19 |
Formulae | p. 19 |
Copying Content and Formats | p. 23 |
Built-In Tools | p. 23 |
Supplement: Logic and Structure in Conditional Statements | p. 27 |
Practice Problems | p. 33 |
Getting Data - Acquisition, Linkage, and Generation | p. 34 |
Text File Imports and Basic Table Transfers | p. 34 |
More Sophisticated Application Transfers | p. 36 |
Online Data Acquisition | p. 47 |
Simulating Data: The Basics | p. 49 |
Living Data Records: The Basics | p. 53 |
Living Records in Practice | p. 56 |
Practice Problems | p. 58 |
Harvesting Intelligence | |
Structuring Problems and Option Visualization | p. 63 |
Value of Data Visualization | p. 64 |
Selective Pruning for Presentation and Analysis | p. 78 |
Visualizing Constraints | p. 82 |
Practice Problems | p. 87 |
Simplification Tactics | p. 89 |
Heuristics in Decision-Making Practice | p. 90 |
Heuristics Applied to Data Rationalization | p. 94 |
Attribute Grouping Approaches | p. 95 |
Data Grouping Approaches | p. 102 |
Giving Form to Future Categorization | p. 112 |
Cited References | p. 116 |
Chapter 5 Supplement: Making Heuristics Automatic (the Non-Elegant Way) | p. 116 |
Practice Problems | p. 119 |
The Analytics of Optimization | p. 122 |
Optimization with Solver | p. 122 |
Deeper Insights into Optimization Solutions | p. 133 |
Practice Problems | p. 150 |
Complex Optimization | p. 154 |
How Solver "Solves" | p. 154 |
The Benefit of Alternate Optimization Options | p. 157 |
Chapter 7 Supplement: A Primer on Genetic Algorithms | p. 173 |
Practice Problems | p. 179 |
Leveraging Dynamic Analysis | |
Controlled Simulation Analysis | p. 183 |
Approaches to the Use of Simulation in Analysis | p. 184 |
Assessing Simulated Variants | p. 187 |
Assessing System Simulations | p. 192 |
An Introduction to Stochastic System Structures | p. 199 |
Chapter 8 Supplement: Simulation Control Made Friendly | p. 202 |
Practice Problems | p. 207 |
Scenario Generation and Optimization | p. 209 |
Basic Simulation Optimization Capabilities | p. 210 |
Optimization of Simulated Variants | p. 213 |
Optimization of System Simulations | p. 216 |
Practice Problem | p. 227 |
Visualizing Complex Analytical Dynamics | p. 229 |
Random Walks | p. 230 |
Frictionless Boxes | p. 231 |
Path-Directed Flows | p. 232 |
Chapter 10 Supplement: Visually Derived Paths | p. 240 |
Advanced Automation and Interfacing | |
VB Editing and Code Development | p. 249 |
The Visual Basic Editor | p. 249 |
Object Manipulations | p. 254 |
Syntax and Coding | p. 259 |
User-Defined Functions | p. 273 |
Practice Problems | p. 279 |
Automating Application Calls | p. 281 |
Calls to MapPoint | p. 281 |
Calls to Solver | p. 285 |
Calls to RiskOptimizer | p. 288 |
Calls to XLStat | p. 294 |
A Final Note on the Value of Linguistics | p. 296 |
Practice Problems | p. 296 |
Guided and User-Friendly Interfaces | p. 298 |
Interface Locking and Protecting | p. 300 |
Dynamic Interfacing: Pop-Ups/Dialogs | p. 303 |
Customizing Primary Excel Interfaces | p. 306 |
Don't Give Up on the Spreadsheet | p. 314 |
Practice Problems | p. 314 |
Glossary of Key Terms | p. 317 |
Appendix - Shortcut (Hot Key) Reference | p. 325 |
Index | p. 327 |
Table of Contents provided by Ingram. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.