June 10, 2009

Spreadsheet Modeling Harvard Business School Course

Filed under: — admin @ 4:11 pm

Click here, If you need to learn Excel 2007 look at our online course with Harvard Business School.

The course is ideal for self study if you want to master the intricacies of Excel 2007 and Excel modeling!

The course covers the following topics.

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

4. 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

5. 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

6. 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

7. 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

8. Charts
Creating Charts/Resizing and Moving Charts / Basic Formatting of Charts / Formatting Axes and Data Series / Customizing Charts

9. Importing Data into Excel
Importing from a Text or Word File / Using Web Queries to Import Data from the Web / Exercises

10. 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

11. Using Excel Solver
Solving Optimization Problems / Developing a Solver Model / Configuring Solver to Find Solutions

12. Three Dimensional Formulas and the Table Feature
Three-Dimensional Formulas / Using the Excel Table Feature

13. Monte Carlo Simulation
Uncertainty and the Monte Carlo Simulation / Random Variables / Using @RISK


  1. Is Excel all a person would need? Or are their other tools to compliment or go beyond? e.g. SPSS?

    Comment by Steve Price — October 24, 2009 @ 1:15 pm

  2. Hello,
    I`ve been meaning to get to grips with excel for the last few years ! I see you posted the article afew years ago i want to ask do you still recommend going though the link at the top of the page or is there a better learning course of Excel now ?
    Thanks James

    Comment by Jim — April 8, 2011 @ 4:19 pm

  3. just excel

    Comment by wwinston — April 8, 2011 @ 4:42 pm

  4. I didn’t know excel have so many things we can do. It’s really great to see you summarizing all of them up for your course. It’s seems really interesting.

    Comment by Immunization Schedule — May 16, 2011 @ 3:33 am

  5. Hello Sir, Is this course free or chargeable?

    Comment by Deep — April 19, 2012 @ 4:55 am

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress