Atjaunināt sīkdatņu piekrišanu

E-grāmata: Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs

3.43/5 (12 ratings by Goodreads)
(Emory University, Atlanta)
  • Formāts: PDF+DRM
  • Izdošanas datums: 07-Jul-2008
  • Izdevniecība: Cambridge University Press
  • Valoda: eng
  • ISBN-13: 9780511410888
Citas grāmatas par šo tēmu:
  • Formāts - PDF+DRM
  • Cena: 39,24 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
  • Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.
  • Formāts: PDF+DRM
  • Izdošanas datums: 07-Jul-2008
  • Izdevniecība: Cambridge University Press
  • Valoda: eng
  • ISBN-13: 9780511410888
Citas grāmatas par šo tēmu:

DRM restrictions

  • Kopēšana (kopēt/ievietot):

    nav atļauts

  • Drukāšana:

    nav atļauts

  • Lietošana:

    Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
    Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

    Nepieciešamā programmatūra
    Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

    Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

    Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Bendoly (operations management and decision sciences, Emory U.) takes mere mortals and turns them into super-users while explaining the powers of this ubiquitous software tool. With accessible text and plenty of useful graphics, he explains the development environment of Excel, then challenges readers to acquire, link, and generate data to create useful, organized intelligence.. He shows how to structure problems and visualize options, and gives a series of simplification tactics that produce effective data groupings for decision support. He explains the analytics of optimization, including complex optimization, and demonstrates leveraging dynamic analysis, including controlled simulation analysis, scenario generation and optimization. His sections on visualizing complex analytical dynamics, advanced automation and interfacing are especially good. This should be on every manager's bookshelf as a reference, but Bendoly's excellent exercises also make this a strong self-study guide and classroom text. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)

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.

Recenzijas

'There's nothing else out there that covers the full potential of Excel in the way that this text does. It's easy to read even if you're a novice to graphical decision support tool development, but it has gems that I doubt even some of the most advanced developers are even aware of. The presentation of various approaches to leveraging Excel with other applications such as MS MapPoint, XLStat and RISKOptimizer is particularly valuable. Similarly eye-opening are the unique tactics Bendoly presents for capitalizing on many of the built-in but underutilized capabilities of Excel. The application examples provided serve as the building blocks for a whole universe of DSS development now made accessible to readers at all levels. This book should become a standard reference for analysts and consultants regardless of industry.' Daniel Bachrach, University of Alabama 'This is a must-read book for people seeking to get the best out of the wonderful tool of Excel. It fits in the sweet spot between the 'Excel made simple' and the math- and statistics-based Excel technical manuals. The practical feel of the book is conveyed through such evocative section headings as Harvesting Intelligence and Leveraging Dynamic Analysis. Though each of the chapters is worthy of comment, I think that Chapter 9, Scenario Generation and Optimization is of particular interest to managers wanting to put some real muscle behind their search for the best decision in the face of uncertainty. All together, this book is a major contribution to the business literature.' Richard B. Chase, University of Southern California 'Excel is the duct tape of decision support handy, pervasive, and surprisingly effective. Bendoly's book helps users unlock its considerable power while avoiding costly errors. You'll be amazed at all you can do with a spreadsheet.' Thomas H. Davenport, Babson College 'This should be on every manager's bookshelf as a reference, but Bendoly's excellent exercises also make this a strong self-study guide and classroom text.' SciTech Book News

Papildus informācija

Excel Basics to Blackbelt is intended to serve as an accelerated guide to decision support designs.
SECTION
1. GETTING ORIENTED
Necessary Foundations for Decision Support
3(5)
The Development Environment
8(26)
Fixed Data
8(4)
Formatting
12(3)
Labeling (Naming)
15(3)
Comments
18(1)
Hyperlinks
19(1)
Formulae
19(4)
Copying Content and Formats
23(1)
Built-In Tools
23(11)
Supplement: Logic and Structure in Conditional Statements
27(6)
Practice Problems
33(1)
Getting Data - Acquisition, Linkage, and Generation
34(29)
Text File Imports and Basic Table Transfers
34(2)
More Sophisticated Application Transfers
36(11)
Online Data Acquisition
47(2)
Simulating Data: The Basics
49(4)
Living Data Records: The Basics
53(3)
Living Records in Practice
56(7)
Practice Problems
58(5)
SECTION
2. HARVESTING INTELLIGENCE
Structuring Problems and Option Visualization
63(26)
Value of Data Visualization
64(14)
Selective Pruning for Presentation and Analysis
78(4)
Visualizing Constraints
82(7)
Practice Problems
87(2)
Simplification Tactics
89(33)
Heuristics in Decision-Making Practice
90(4)
Heuristics Applied to Data Rationalization
94(1)
Attribute Grouping Approaches
95(7)
Data Grouping Approaches
102(10)
Giving Form to Future Categorization
112(10)
Cited References
116(1)
Suppliement: Making Heuristics Automatic (the Non-Elegant Way)
116(3)
Practice Problems
119(3)
The Analytics of Optimization
122(32)
Optimization with Solver
122(11)
Deeper Insights into Optimization Solutions
133(21)
Practice Problems
150(4)
Complex Optimization
154(29)
How Solver ``Solves''
154(3)
The Benefit of Alternate Optimization Options
157(26)
Supplement: A Primer on Genetic Algorithms
173(6)
Practice Problems
179(4)
SECTIONS
3. LEVERAGING DYNAMIC ANALYSIS
Controlled Simulation Analysis
183(26)
Approaches to the Use of Simulation in Analysis
184(3)
Assessing Simulated Variants
187(5)
Assessing System Simulations
192(7)
An Introduction to Stochastic System Structures
199(10)
Supplement: Simulation Control Mde Friendly
202(5)
Practice Problems
207(2)
Scenario Generation and Optimization
209(20)
Basic Simulation Optimization Capabilities
210(3)
Optimization of Simulated Variants
213(3)
Optimization of System Simulations
216(13)
Practice Problem
227(2)
Visualizing Complex Analytical Dynamics
229(20)
Random Walks
230(1)
Frictionless Boxes
231(1)
Path-Directed Flows
232(17)
Supplement: Visually Derived Paths
240(9)
SECTION
4. ADVANCED AUTOMATION AND INTERFACING
VB Editing and Code Development
249(32)
The Visual Basic Editor
249(5)
Object Manipulations
254(5)
Syntax and Coding
259(14)
User-Defined Functions
273(8)
Practice Problems
279(2)
Automating Application Calls
281(17)
Calls to MapPoint
281(4)
Calls to Solver
285(3)
Calls to RiskOptimizer
288(6)
Calls to XLStat
294(2)
A Final Note on the Value of Linguistics
296(2)
Practice Problems
296(2)
Guided and User-Friendly Interfaces
298(19)
Interface Locking and Protecting
300(3)
Dynamic Interfacing: Pop-Ups/Dialogs
303(3)
Customizing Primary Excel Interfaces
306(8)
Don't Give Up on the Spreadsheet
314(3)
Practice Problem
314(3)
Glossary of Key Terms 317(8)
Appendix - Shortcut (Hot Key) Reference 325(2)
Index 327
Dr Elliot Bendoly is an Associate Professor in Information Systems and Operations Management at Emory University's Goizueta Business School. Prior to academia he worked as a research engineer for the Intel Corporation. He holds a PhD from Indiana University in the fields of Operations Management and Decision Sciences, with an Information Systems specialization in ERP and Knowledge Management. His research has been published in a wide range of elite academic journals including the Journal of Operations Management, the Journal of Applied Psychology, Production and Operations Management, Information Systems Research and MIS Quarterly, among others (full vita at www.bizbreed.com). Dr Bendoly is also the co-editor of Strategic ERP Extension and Use (Stanford University Press, 2005) which complements the 2008 Cambridge University Press text catering to the ramp up of tool-developer skills and the integration of applications such as Map Point, XL State, and RiskOptimizer in Excel for decision support system creation. His current research focuses on operational issues in IT utilization and behavioral dynamics.