国信模型培训2008.ppt

Table of Contents Table of Contents (cont) Purpose of this Workshop What is a Financial model? Different Types of Models End Goal of a Model Essence of a Model: Assumptions Choosing Assumptions An Effective and Efficient Model is ... Excel Best Practices Principles Commonly Used Shortcut Keys Commonly Used Functions Excel Best Practices Excel Best Practices (cont) Moving Between Toolbars Customizing Your Toolbar Move Selection after Enter Formatting Matters! Custom Number Formatting Custom Number Formatting (cont) Custom Number Formatting (cont) Use a Modular Approach Use a Modular Approach (c