1. Introduction
  • The Company
  •  Spreadsheet Modeling
2. The Excel Environment

  • Opening a Workbook
  •  The Excel 2007 Ribbon
  •  The Quick Access Toolbar
  •  Worksheets 
  • Moving Around a Worksheet and Workbook 
  • Printing a Worksheet 
  • Saving a Workbook File
3. Working with Data: Basic Techniques

  • Cells and Ranges 
  • Selecting Ranges 
  • Selecting All Cells in a Dataset Using Shortcut Keys
  •  Selecting All Cells on a Worksheet
  •  Selecting Noncontiguous Ranges
  •  Selecting Cells and Named Ranges
  •  Using “Go To Special”
  •  Filling Series
  •  Copying and Moving Cell Entries
  •  The Undo Command
4. Increasing Spreadsheet Readability

  • Working with Rows and Columns
  • Making Good Use of Screen Space
  • Basic Cell Formatting
  • Basic Number Formatting
  • Conditional Formatting
  • Paste Special
  • Setting Up a Worksheet for Printing
5. Excel Formulas

  • Copying Formulas
  • The Autocomplete Formula Option
  • Entering Formulas by Pointing
  • Alternate Ways to Copy Formulas
  • “Absolute” Addressing
  • Using the “F4″ Key
  • Hierarchy of Mathematical Operations
  • Summation Icon
  • Editing or Correcting Formulas
  • Showing Actual Formulas in Cells
  • “Do It Yourself” Exercise
6. Useful Excel Functions

  • IF Statements
  • Text Functions
  • Basic Date and Time Functions
  • Range Names
  • Lookup Functions
  • Other Lookup & Reference
  • Functions
  • lookup, Sumif, and Countif functions
  • Error Trapping
  • Rounding Functions
  • The SUMPRODUCT Function
  • Modeling Uncertainty in Excel
  • Excel Financial Functions
  • COUNT, COUNTA, and COUNTBLANK Functions
  • Excel Statistical Functions
  • Conditional Counts
  • Conditional Sums
  • Removing Duplicates
  • Sorting in Excel
  • Filtering Data
  • Subtotals
  • Pivot Tables
  • Pivot Charts
  • Conditional Formatting: The Formula Option
7. Charts

  • Creating Charts
  • Resizing and Moving Charts
  • Basic Formatting of Charts
  • Formatting Axes and Data Series
  • Customizing Charts
8. Importing Data into Excel

  • Importing from a Text or Word File
  • Using Web Queries to Import Data from the Web
  • Exercises
19. The Art of Spreadsheet Modeling

  • Model Building Blocks
  • Model Terminology
  • The Spreadsheet Model Building Process
  • Rules to Guide Intelligent Modeling
  • Constructing a Model
  • Designing the Spreadsheet Model
  • Data Tables
  • Two Way Data Tables
  • Goal Seek
  • Auditing Spreadsheets
  • Flexibility
  • Using Comments and Text Boxes
  • Error Trapping
  • Using “F9″ and Evaluate Formula Feature
  • Generating Scenarios
  • Spinners
  • Model Limitations
10. Using Excel Solver

  • Solving Optimization Problems
  • Developing a Solver Model
  • Configuring Solver to Find Solutions
11. Three Dimensional Formulas and the Table Feature

  • Three-Dimensional Formulas
  • Using the Excel Table Feature
12. Monte Carlo Simulation

  • Uncertainty and the Monte Carlo Simulation
  •  Random Variables
  •  Using @RISK
13. Final Exam