Excel basics to blackbelt : an accelerated guide to decision support designs / Elliot Bendoly.

Format:

Book

Author/Creator:

Bendoly, Elliot, author.

Language:

English

Subjects (All):

Decision support systems.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (vii, 333 pages) : digital, PDF file(s).

Place of Publication:

Cambridge : Cambridge University Press, 2008.

Language Note:

English

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 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.

Contents:

Necessary foundations for decision support

Getting data

acquisition, linkage, and generation

Structuring problems and option visualization

Simplification tactics

The analytics of optimization

Complex optimization

Controlled simulation analysis

Scenario generation and optimization

Visualizing complex analytical dynamics

VB editing and code development

Automating application calls

Guided and user-friendly interfaces.

Notes:

Title from publisher's bibliographic system (viewed on 05 Oct 2015).

Includes index.

ISBN:

1-107-18759-1

1-281-75145-6

9786611751456

0-511-41480-3

0-511-41321-1

0-511-41548-6

0-511-41228-2

0-511-75373-X

0-511-41415-3

OCLC:

437219433