Atjaunināt sīkdatņu piekrišanu

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

(Emory University, Atlanta)
  • Formāts: PDF+DRM
  • Izdošanas datums: 29-Jul-2013
  • Izdevniecība: Cambridge University Press
  • Valoda: eng
  • ISBN-13: 9781107240780
  • Formāts - PDF+DRM
  • Cena: 57,09 €*
  • * š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: 29-Jul-2013
  • Izdevniecība: Cambridge University Press
  • Valoda: eng
  • ISBN-13: 9781107240780

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.

This second edition of Excel Basics to Blackbelt capitalizes on the success of the first edition and leverages some of the advancements in visualization, data analysis, and sharing capabilities that have emerged over the past five years. As with the original text, the second edition is intended to serve as an accelerated guide to decision support designs for consultants and service professionals. This 'fast track' enables a ramping up of skills in Excel for those who may have never used it to reach a level of mastery that will allow them to integrate Excel with widely available associated applications, make use of intelligent data visualization and analysis techniques, automate activity through basic VBA designs, and develop easy-to-use interfaces for customizing use. In other words, this book provides users with lessons and examples on integrative Excel use that are not available from alternative texts.

Recenzijas

Review of previous edition: '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 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 Review of previous edition: '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 stat-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 the chapter on 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 Review of previous edition: '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 Review of previous edition: 'Excel Basics to Blackbelt provides the guidance and tools needed to help anyone develop a solid analytical skill set from the ground up. The skills I learned were instrumental in helping me differentiate myself from my peers and [ become] a go-to resource for both my team members and clients.' Geoffrey Grant, Deloitte

Papildus informācija

This second edition is designed for those interested in developing their skills in the construction of analytical tools and rich visual demonstrations in Excel.
Associated Links ix
Preface xi
SECTION 1 GETTING ORIENTED
1 Necessary Foundations for Decision Support
3(4)
2 The Development Environment
7(30)
2.1 Fixed Data
8(3)
2.2 Formatting
11(4)
2.3 Labeling (Naming)
15(3)
2.4 Comments
18(1)
2.5 Hyperlinks
19(1)
2.6 Formulae
19(4)
2.7 Copying Content and Formats
23(1)
2.8 Built-in Tools and Matrix Functions
24(13)
Supplement: Logic and Structure in Conditional Statements
30(5)
Practice Problems
35(2)
3 Getting Data: Acquisition, Linkage, and Generation
37(26)
3.1 Text File Imports and Basic Table Transfers
37(2)
3.2 More Sophisticated Application Transfers
39(5)
3.3 Online Data Acquisition
44(4)
3.4 Simulating Continuous Data: The Basics
48(2)
3.5 Discrete Random Number Generation
50(2)
3.6 Living Data Records: The Basics -
52(3)
3.7 Living Records in Practice
55(8)
Supplement: Unique Data Generation and Sharing Tactics
57(2)
Practice Problems
59(4)
SECTION 2 HARVESTING INTELLIGENCE
4 Structuring Problems and Option Visualization
63(43)
4.1 Value of Data Visualization
64(10)
4.2 Visualizing Continuous Data
74(5)
4.3 Less Conventional Depictions of Means and Variance
79(1)
4.4 Depictions in More Than Two Dimensions
79(7)
4.5 Complex-Form Heat Mapping
86(10)
4.6 Selective Pruning for Presentation and Analysis
96(4)
4.7 Visualizing Constraints
100(6)
Practice Problems
105(1)
5 Simplification Tactics
106(34)
5.1 Heuristics in Decision-Making Practice
107(4)
5.2 Heuristics Applied to Data Rationalization
111(2)
5.3 Attribute Grouping Approaches
113(5)
5.4 Data Grouping Approaches
118(11)
5.5 Giving Form to Future Categorization
129(11)
References
133(1)
Supplement: Making Heuristics Automatic (the Inelegant Way)
133(3)
Practice Problems
136(4)
6 The Analytics of Optimization
140(37)
6.1 Optimization with Solver
140(14)
6.2 Deeper Insights into Optimization Solutions
154(23)
Supplement: The OUtCoMES Roadmap
171(2)
Practice Problems
173(4)
7 Complex Optimization
177(30)
7.1 How Solver "Solves"
177(4)
7.2 The Benefit of Alternate Optimization Options
181(26)
Supplement: A Primer on Genetic Algorithms
197(6)
Practice Problems
203(4)
SECTION 3 LEVERAGING DYNAMIC ANALYSIS
8 Controlled Simulation Analysis
207(38)
8.1 Approaches to the Use of Simulation in Analysis
208(2)
8.2 Assessing Simulated Variants
210(17)
8.3 Assessing System Simulations
227(8)
8.4 An Introduction to Stochastic System Structures
235(10)
Supplement: Simulation Control Made Friendly
237(7)
Practice Problems
244(1)
9 Simulation Search, Optimization, and Reporting
245(24)
9.1 Basic Simulation Optimization Capabilities
246(3)
9.2 Optimization of Simulated Variants
249(3)
9.3 Optimization of System Simulations
252(17)
Practice Problem
268(1)
10 Visualizing Complex Analytical Dynamics
269(22)
10.1 Random Walks
270(1)
10.2 Frictionless Boxes
271(1)
10.3 Dynamics in Google Documents Visualization
272(2)
10.4 Path-Directed Flows
274(17)
Supplement: Visually Derived Paths
283(8)
SECTION 4 ADVANCED AUTOMATION AND INTERFACING
11 Visual Basic Editing and Code Development
291(43)
11.1 The Visual Basic Editor
291(4)
11.2 Additional VBA Capabilities: Object Manipulations
295(8)
11.3 Syntax and Storage
303(8)
11.4 Common Operations in VBA
311(9)
11.5 User-Defined Functions
320(9)
11.6 Error Handling
329(2)
11.7 Making Functions and Macros Available to Other Workbooks: Creating Add-Ins
331(3)
Practice Problems
332(2)
12 Automating Application Calls
334(25)
12.1 Calls to MapPoint
334(4)
12.2 Calls to Solver
338(3)
12.3 Calls to RiskOptimizer
341(6)
12.4 Calls to XLStat
347(2)
12.5 A Final Note on the Value of Linguistics
349(10)
Supplement: Setups for Embedded MapPoint Controls
350(7)
Practice Problems
357(2)
13 Guided and User-Friendly Interfaces
359(22)
13.1 Interface Locking and Protecting
361(2)
13.2 Dynamic Interfacing: Pop-Ups and Dialogs
363(7)
13.3 Customizing Primary Excel Interfaces
370(7)
13.4 Ribbon Editing for Packaged Add-Ins
377(1)
13.5 Don't Give Up on the Spreadsheet
377(4)
Practice Problem
378(3)
Glossary of Key Terms 381(8)
Appendix: Shortcut (Hot Key) Reference 389(2)
Index 391
Elliot Bendoly is an associate professor at Emory University's Goizueta Business School. He serves as an associate editor for the Journal of Operations Management, a senior editor for Production and Operations Management, and an associate editor for Decision Sciences. His research has been published in several academic journals including MIS Quarterly, Information Systems Research, and the Journal of Applied Psychology. He is the co-editor of Strategic ERP Extension and Use and of the Handbook of Research in Enterprise Systems, as well as the author of the first edition of Excel Basics to Blackbelt (Cambridge University Press, 2008). He holds a PhD from Indiana University.