Link to the ebook : https://login.ezproxy.univ-catholille.fr/login?url=https://s...

eISBN : 9781118904008

Contents : Preface
About the Author
About the Website

Part One Introduction to Modelling, Core Themes and Best Practices
Chapter 1 Models of Models
Chapter 2 Using Models in Decision Support
Chapter 3 Core Competencies and Best Practices: Meta-themes

Part Two Model Design and Planning
Chapter 4 Defining Sensitivity and Flexibility Requirements
Chapter 5 Database Versus Formulae-driven Approaches
Chapter 6 Designing the Workbook Structure

Part Three Model Building, Testing and Auditing
Chapter 7 Creating Transparency: Formula Structure, Flow and Format
Chapter 8 Building Robust and Transparent Formulae
Chapter 9 Choosing Excel Functions for Transparency, Flexibility and Efficiency
Chapter 10 Dealing with Circularity
Chapter 11 Model Review, Auditing and Validation

Part Four Sensitivity and Scenario Analysis, Simulation and Optimisation
Chapter 12 Sensitivity and Scenario Analysis: Core Techniques
Chapter 13 Using GoalSeek and Solver
Chapter 14 Using VBA Macros to Conduct Sensitivity and Scenario Analyses
Chapter 15 Introduction to Simulation and Optimisation
Chapter 16 The Modelling of Risk and Uncertainty, and Using Simulation

Part Five Excel Functions and Functionality
Chapter 17 Core Arithmetic and Logical Functions
Chapter 18 Array Functions and Formulae
Chapter 19 Mathematical Functions
Chapter 20 Financial Functions
Chapter 21 Statistical Functions
Chapter 22 Information Functions
Chapter 23 Date and Time Functions
Chapter 24 Text Functions and Functionality
Chapter 25 Lookup and Reference Functions
Chapter 26 Filters, Database Functions and PivotTables
Chapter 27 Selected Short-cuts and Other Features

Part Six Foundations of VBA and Macros 395
Chapter 28 Getting Started 397
Chapter 29 Working with Objects and Ranges
Chapter 30 Controlling Execution
Chapter 31 Writing Robust Code
Chapter 32 Manipulation and Analysis of Data Sets with VBA
Chapter 33 User-defined Functions
Index

Language : English

Place of publishing : TORONTO

Location : Nice Library

Material : Electronic

Statement : Présent

Owner : Bibliothèque