Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, Edition Revised for Excel 2013

Contents

1. Preface
   1. BOOK OVERVIEW
   2. ACKNOWLEDGMENTS
2. CHAPTER 1 What Is Financial Modelling?
   1. WHAT’S THE DIFFERENCE BETWEEN A SPREADSHEET AND A FINANCIAL MODEL?
   2. TYPES AND PURPOSES OF FINANCIAL MODELS
   3. TOOL SELECTION
   4. WHAT SKILLS DO YOU NEED TO BE A GOOD FINANCIAL MODELLER?
   5. THE IDEAL FINANCIAL MODELLER
   6. SUMMARY
   7. NOTES
3. CHAPTER 2 Building a Model
   1. MODEL DESIGN
   2. THE GOLDEN RULES FOR MODEL DESIGN
   3. DESIGN ISSUES
   4. THE WORKBOOK ANATOMY OF A MODEL
   5. PROJECT PLANNING YOUR MODEL
   6. MODEL LAYOUT FLOW CHARTING
   7. STEPS TO BUILDING A MODEL
   8. INFORMATION REQUESTS
   9. VERSION-CONTROL DOCUMENTATION
   10. SUMMARY
4. CHAPTER 3 Best Practice Principles of Modelling
   1. DOCUMENT YOUR ASSUMPTIONS
   2. LINKING, NOT HARD CODING
   3. ENTER DATA ONLY ONCE
   4. AVOID BAD HABITS
   5. USE CONSISTENT FORMULAS
   6. FORMAT AND LABEL CLEARLY
   7. METHODS AND TOOLS OF ASSUMPTIONS DOCUMENTATION
   8. LINKED DYNAMIC TEXT ASSUMPTIONS DOCUMENTATION
   9. WHAT MAKES A GOOD MODEL?
   10. SUMMARY
   11. NOTE
5. CHAPTER 4 Financial Modelling Techniques
   1. THE PROBLEM WITH EXCEL
   2. ERROR AVOIDANCE STRATEGIES
   3. HOW LONG SHOULD A FORMULA BE?
   4. LINKING TO EXTERNAL FILES
   5. BUILDING ERROR CHECKS
   6. SUMMARY
   7. NOTES
6. CHAPTER 5 Using Excel in Financial Modelling
   1. FORMULAS AND FUNCTIONS IN EXCEL
   2. EXCEL VERSIONS
   3. HANDY EXCEL SHORTCUTS
   4. BASIC EXCEL FUNCTIONS
   5. LOGICAL FUNCTIONS
   6. NESTING: COMBINING SIMPLE FUNCTIONS TO CREATE COMPLEX FORMULAS
   7. CELL REFERENCING BEST PRACTICES
   8. NAMED RANGES
   9. SUMMARY
7. CHAPTER 6 Functions for Financial Modelling
   1. AGGREGATION FUNCTIONS
   2. LOOKUP FORMULAS
   3. NESTING INDEX AND MATCH
   4. OFFSET FUNCTION
   5. REGRESSION ANALYSIS