CHAPTER 1: INTRODUCTION.1.1 Models and Modeling.1.1.1 Why Study Modeling?1.1.2 Models in Business.
1.1.3 Models in Business Education.1.1.4 Benefits of Business Models.1.2 The Role of Spreadsheets.
1.2.1 Risks of Spreadsheet Use.1.2.2 Challenges for Spreadsheet Users.1.2.
3 Background Knowledge for Spreadsheet Modeling.1.3 The Real World and the Model World.1.4 Lessons from Expert and Novice Modelers.1.4.1 Expert Modelers.
1.4.2 Novice Modelers.1.5 Organization of the Book.1.6 Summary.CHAPTER 2 MODELING IN A PROBLEM-SOLVING FRAMEWORK.
2.1 Introduction.2.2 The Problem-Solving Process.2.2.1 Some Key Terms.2.
2.2 The Six-Stage Problem-Solving Process.2.2.3 Mental Models and Formal Models.2.3 Influence Charts.2.
3.1 A First Example.2.3.2 An Income Statement as an Influence.2.3.3 Principles for Building Influence.
2.3.4 Two Additional Examples.2.4 Craft Skills for Modeling.2.4.1 Simplify the Problem.
2.4.2 Break the Problem into Modules.2.4.3 Build a Prototype and Refine It.2.4.
4 Sketch Graphs of Key Relationships.2.4.5 Identify Parameters and Perform Sensitivity Analysis.2.4.6 Separate the Creation of Ideas from Their Evaluation.2.
4.7 Work Backward from the Desired Answer.2.4.8 Focus on Model Structure, not on Data Collection.CHAPTER 3 BASIC EXCEL SKILLS.3.1 Introduction.
3.2 Excel Prerequisites.3.3 The Excel Window.3.4 Configuring Excel.3.5 Manipulating Windows and Sheets.
3.6 Navigation.3.7 Selecting Cells.3.8 Entering Text and Data.3.9 Editing Cells.
3.10 Formatting.3.11 Basic Formulas.3.12 Basic Functions.3.13 Charting.
3.14 Printing.3.15 Help Options.3.16 Summary.CHAPTER 4 ADVANCED EXCEL SKILLS.4.
1 Introduction.4.2 Keyboard Shortcuts.4.3 Controls.4.4 Cell Comments.4.
5 Naming Cells and Ranges.4.6 Advanced Formulas and Functions.4.6.1 R1C1 Reference Style.4.6.
2 Mixed Addresses.4.6.3 Nesting Calculations.4.6.4 Parameterization.4.
6.5 Advanced Functions.4.7 Recording Macros And Using VBA.4.7.1 Recording a Macro.4.
7.2 Editing a Macro.4.7.3 Creating a User-Defined Function.4.8 Summary.CHAPTER 5 SPREADSHEET ENGINEERING.
5.1 Introduction.5.2 Designing a Spreadsheet.5.2.1 Sketch the Spreadsheet.5.
2.2 Organize the Spreadsheet into Modules.5.2.3 Start Small.5.2.4 Isolate Input Parameters.
5.2.5 Design for Use.5.2.6 Keep It Simple.5.2.
7 Design for Communication.5.2.8 Document Important Data and Formulas.Designing a Workbook.5.3.1 Use Separate Worksheets to Group Similar Kinds of Information.
5.3.2 Design Workbooks for Ease of Navigation and Use.5.3.3 Design a Workbook as a Decision-Support System.5.4 Building a Workbook.
5.4.1 Follow a Plan.5.4.2 Build One Worksheet or Module at a Time.5.4.
3 Predict the Outcome of Each Formula.5.4.4 Copy and Paste Formulas Carefully.5.4.5 Use Relative and Absolute Addressing to Simplify Copying.5.
4.6 Use the Function W.