- Cover
- Title Page
- Preface
- About the Author
- About the Website
- PART One: Introduction to Modelling, Core Themes and Best Practices
- PART Two: Model Design and Planning
- PART Three: Model Building, Testing and Auditing
- 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
- INTRODUCTION
- PRACTICAL APPLICATIONS: BASIC REFERENCING PROCESSES
- PRACTICAL APPLICATIONS: FURTHER REFERENCING PROCESSES
- PRACTICAL APPLICATIONS: COMBINING MATCHING AND REFERENCE PROCESSES
- PRACTICAL APPLICATIONS: MORE ON THE OFFSET FUNCTION AND DYNAMIC RANGES
- PRACTICAL APPLICATIONS: THE INDIRECT FUNCTION AND FLEXIBLE WORKBOOK OR DATA STRUCTURES
- PRACTICAL EXAMPLES: USE OF HYPERLINKS TO NAVIGATE A MODEL, AND OTHER LINKS TO DATA SETS
- CHAPTER 26: Filters, Database Functions and PivotTables
- CHAPTER 27: Selected Short-cuts and Other Features
- PART Six: Foundations of VBA and Macros
- Index
- End User License Agreement
PART Three
Model Building, Testing and Auditing
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.