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