Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs

by
Edition: 1st
Format: Hardcover
Pub. Date: 2008-07-07
Publisher(s): Cambridge University Press
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $52.00

Rent Textbook

Select for Price
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$62.40
*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.
$62.40*

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

Excel Basics to Blackbelt is intended to serve as an accelerated guide to decision support designs. Its structure is designed to enhance the skills in Excel of those who have never used it for anything but possibly storing phone numbers, enabling them to reach to a level of mastery that will allow them to develop user interfaces and automated applications. To accomplish this, the major theme of the text is "the integration of the basic"; as a result readers will be able to develop decision support tools that are at once highly intuitive from a working-components perspective but also highly significant from the perspective of practical use and distribution. Applications integration discussed includes the use of MS MapPoint, XLStat and RISKOptimizer, as well as how to leverage Excel's iteration mode, web queries, visual basic code, and interface development. There are ample examples throughout the text.

Author Biography

Elliot Bendoly is an associate professor at Emory University's Goizueta Business School. He holds a Ph.D. from Indiana University in operations management and decision sciences with an information systems specialization in enterprise resource planning (ERP) and knowledge management. Professor Bendoly serves on the editorial boards of the Journal of Operations Management and Decision Sciences. His research has been published in leading academic journals, including the Journal of Operations Management, Production and Operations Management, MIS Quarterly, Information Systems Research, Journal of Applied Psychology, Decision Sciences, and the Journal of Service Research. He is also the coeditor of Strategic ERP Extension and Use.

Table of Contents

Getting Oriented
Necessary Foundations for Decision Supportp. 3
The Development Environmentp. 8
Fixed Datap. 8
Formattingp. 12
Labeling (Naming)p. 15
Commentsp. 18
Hyperlinksp. 19
Formulaep. 19
Copying Content and Formatsp. 23
Built-In Toolsp. 23
Supplement: Logic and Structure in Conditional Statementsp. 27
Practice Problemsp. 33
Getting Data - Acquisition, Linkage, and Generationp. 34
Text File Imports and Basic Table Transfersp. 34
More Sophisticated Application Transfersp. 36
Online Data Acquisitionp. 47
Simulating Data: The Basicsp. 49
Living Data Records: The Basicsp. 53
Living Records in Practicep. 56
Practice Problemsp. 58
Harvesting Intelligence
Structuring Problems and Option Visualizationp. 63
Value of Data Visualizationp. 64
Selective Pruning for Presentation and Analysisp. 78
Visualizing Constraintsp. 82
Practice Problemsp. 87
Simplification Tacticsp. 89
Heuristics in Decision-Making Practicep. 90
Heuristics Applied to Data Rationalizationp. 94
Attribute Grouping Approachesp. 95
Data Grouping Approachesp. 102
Giving Form to Future Categorizationp. 112
Cited Referencesp. 116
Chapter 5 Supplement: Making Heuristics Automatic (the Non-Elegant Way)p. 116
Practice Problemsp. 119
The Analytics of Optimizationp. 122
Optimization with Solverp. 122
Deeper Insights into Optimization Solutionsp. 133
Practice Problemsp. 150
Complex Optimizationp. 154
How Solver "Solves"p. 154
The Benefit of Alternate Optimization Optionsp. 157
Chapter 7 Supplement: A Primer on Genetic Algorithmsp. 173
Practice Problemsp. 179
Leveraging Dynamic Analysis
Controlled Simulation Analysisp. 183
Approaches to the Use of Simulation in Analysisp. 184
Assessing Simulated Variantsp. 187
Assessing System Simulationsp. 192
An Introduction to Stochastic System Structuresp. 199
Chapter 8 Supplement: Simulation Control Made Friendlyp. 202
Practice Problemsp. 207
Scenario Generation and Optimizationp. 209
Basic Simulation Optimization Capabilitiesp. 210
Optimization of Simulated Variantsp. 213
Optimization of System Simulationsp. 216
Practice Problemp. 227
Visualizing Complex Analytical Dynamicsp. 229
Random Walksp. 230
Frictionless Boxesp. 231
Path-Directed Flowsp. 232
Chapter 10 Supplement: Visually Derived Pathsp. 240
Advanced Automation and Interfacing
VB Editing and Code Developmentp. 249
The Visual Basic Editorp. 249
Object Manipulationsp. 254
Syntax and Codingp. 259
User-Defined Functionsp. 273
Practice Problemsp. 279
Automating Application Callsp. 281
Calls to MapPointp. 281
Calls to Solverp. 285
Calls to RiskOptimizerp. 288
Calls to XLStatp. 294
A Final Note on the Value of Linguisticsp. 296
Practice Problemsp. 296
Guided and User-Friendly Interfacesp. 298
Interface Locking and Protectingp. 300
Dynamic Interfacing: Pop-Ups/Dialogsp. 303
Customizing Primary Excel Interfacesp. 306
Don't Give Up on the Spreadsheetp. 314
Practice Problemsp. 314
Glossary of Key Termsp. 317
Appendix - Shortcut (Hot Key) Referencep. 325
Indexp. 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.