Home Page Icon
Home Page
Table of Contents for
PART Six: Foundations of VBA and Macros
Close
PART Six: Foundations of VBA and Macros
by Michael Rees
Principles of Financial Modelling
Cover
Title Page
Preface
About the Author
About the Website
PART One: Introduction to Modelling, Core Themes and Best Practices
CHAPTER 1: Models of Models
INTRODUCTION
CONTEXT AND OBJECTIVES
THE STAGES OF MODELLING
BACKWARD THINKING AND FORWARD CALCULATION PROCESSES
CHAPTER 2: Using Models in Decision Support
INTRODUCTION
BENEFITS OF USING MODELS
CHALLENGES IN USING MODELS
CHAPTER 3: Core Competencies and Best Practices: Meta-themes
INTRODUCTION
KEY THEMES
PART Two: Model Design and Planning
CHAPTER 4: Defining Sensitivity and Flexibility Requirements
INTRODUCTION
KEY ISSUES FOR CONSIDERATION
CHAPTER 5: Database Versus Formulae-driven Approaches
INTRODUCTION
KEY ISSUES FOR CONSIDERATION
PRACTICAL EXAMPLE
CHAPTER 6: Designing the Workbook Structure
INTRODUCTION
GENERIC BEST PRACTICE STRUCTURES
USING INFORMATION FROM MULTIPLE WORKSHEETS: CHOICE (EXCLUSION) AND CONSOLIDATION (INCLUSION) PROCESSES
PART Three: Model Building, Testing and Auditing
CHAPTER 7: Creating Transparency: Formula Structure, Flow and Format
INTRODUCTION
APPROACHES TO IDENTIFYING THE DRIVERS OF COMPLEXITY
OPTIMISING AUDIT PATHS
IDENTIFYING INPUTS, CALCULATIONS AND OUTPUTS: STRUCTURE AND FORMATTING
CREATING DOCUMENTATION, COMMENTS AND HYPERLINKS
CHAPTER 8: Building Robust and Transparent Formulae
INTRODUCTION
GENERAL CAUSES OF MISTAKES
EXAMPLES OF COMMON MISTAKES
THE USE OF NAMED RANGES
APPROACHES TO BUILDING FORMULAE, TO TESTING, ERROR DETECTION AND MANAGEMENT
CHAPTER 9: Choosing Excel Functions for Transparency, Flexibility and Efficiency
INTRODUCTION
KEY CONSIDERATIONS
CHAPTER 10: Dealing with Circularity
INTRODUCTION
THE DRIVERS AND NATURE OF CIRCULARITIES
RESOLVING CIRCULAR FORMULAE
ITERATIVE METHODS IN PRACTICE
PRACTICAL EXAMPLE
SELECTION OF APPROACH TO DEALING WITH CIRCULARITIES: KEY CRITERIA
CHAPTER 11: Model Review, Auditing and Validation
INTRODUCTION
OBJECTIVES
PROCESSES, TOOLS AND TECHNIQUES
PART Four: Sensitivity and Scenario Analysis, Simulation and Optimisation
CHAPTER 12: Sensitivity and Scenario Analysis: Core Techniques
INTRODUCTION
OVERVIEW OF SENSITIVITY-RELATED TECHNIQUES
DATATABLES
PRACTICAL APPLICATIONS
CHAPTER 13: Using GoalSeek and Solver
INTRODUCTION
OVERVIEW OF GOALSEEK AND SOLVER
PRACTICAL APPLICATIONS
CHAPTER 14: Using VBA Macros to Conduct Sensitivity and Scenario Analyses
INTRODUCTION
PRACTICAL APPLICATIONS
CHAPTER 15: Introduction to Simulation and Optimisation
INTRODUCTION
THE LINKS BETWEEN SENSITIVITY AND SCENARIO ANALYSIS, SIMULATION AND OPTIMISATION
PRACTICAL EXAMPLE: A PORTFOLIO OF PROJECTS
FURTHER ASPECTS OF OPTIMISATION MODELLING
CHAPTER 16: The Modelling of Risk and Uncertainty, and Using Simulation
INTRODUCTION
THE MEANING, ORIGINS AND USES OF MONTE CARLO SIMULATION
KEY PROCESS AND MODELLING STEPS IN RISK MODELLING
USING EXCEL AND VBA TO IMPLEMENT RISK AND SIMULATION MODELS
USING ADD-INS TO IMPLEMENT RISK AND SIMULATION MODELS
PART Five: Excel Functions and Functionality
CHAPTER 17: Core Arithmetic and Logical Functions
INTRODUCTION
PRACTICAL APPLICATIONS
CHAPTER 18: Array Functions and Formulae
INTRODUCTION
PRACTICAL APPLICATIONS: ARRAY FUNCTIONS
PRACTICAL APPLICATIONS: ARRAY FORMULAE
CHAPTER 19: Mathematical Functions
INTRODUCTION
PRACTICAL APPLICATIONS
CHAPTER 20: Financial Functions
INTRODUCTION
PRACTICAL APPLICATIONS
OTHER FINANCIAL FUNCTIONS
CHAPTER 21: Statistical Functions
INTRODUCTION
PRACTICAL APPLICATIONS: POSITION, RANKING AND CENTRAL VALUES
PRACTICAL APPLICATIONS: SPREAD AND SHAPE
PRACTICAL APPLICATIONS: CO-RELATIONSHIPS AND DEPENDENCIES
PRACTICAL APPLICATIONS: PROBABILITY DISTRIBUTIONS
PRACTICAL APPLICATIONS: MORE ON REGRESSION ANALYSIS AND FORECASTING
CHAPTER 22: Information Functions
INTRODUCTION
CHAPTER 23: Date and Time Functions
INTRODUCTION
PRACTICAL APPLICATIONS
CHAPTER 24: Text Functions and Functionality
INTRODUCTION
PRACTICAL APPLICATIONS
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
INTRODUCTION
ISSUES COMMON TO WORKING WITH SETS OF DATA
PRACTICAL APPLICATIONS: FILTERS
PRACTICAL APPLICATIONS: DATABASE FUNCTIONS
PRACTICAL APPLICATIONS: PIVOTTABLES
CHAPTER 27: Selected Short-cuts and Other Features
INTRODUCTION
KEY SHORT-CUTS AND THEIR USES
OTHER USEFUL EXCEL TOOLS AND FEATURES
PART Six: Foundations of VBA and Macros
CHAPTER 28: Getting Started
INTRODUCTION
MAIN USES OF VBA
CORE OPERATIONS
SIMPLE EXAMPLES
CHAPTER 29: Working with Objects and Ranges
INTRODUCTION
OVERVIEW OF THE OBJECT MODEL
WORKING WITH RANGE OBJECTS: SOME KEY ELEMENTS
CHAPTER 30: Controlling Execution
INTRODUCTION
CORE TOPICS IN OVERVIEW
PRACTICAL APPLICATIONS
CHAPTER 31: Writing Robust Code
INTRODUCTION
KEY PRINCIPLES
FURTHER APPROACHES TO TESTING, DEBUGGING AND ERROR-HANDLING
CHAPTER 32: Manipulation and Analysis of Data Sets with VBA
INTRODUCTION
PRACTICAL APPLICATIONS
CHAPTER 33: User-defined Functions
INTRODUCTION
BENEFITS OF CREATING USER-DEFINED FUNCTIONS
SYNTAX AND IMPLEMENTATION
PRACTICAL APPLICATIONS
Index
End User License Agreement
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
CHAPTER 27: Selected Short-cuts and Other Features
Next
Next Chapter
CHAPTER 28: Getting Started
PART Six
Foundations of VBA and Macros
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset