Welcome
This is a basic tutorial for spreadsheet modelling in a business context. Specific examples and graphics may refer to Microsoft Excel 2007; however, most items should work in other spreadsheet software as well. Please go through one section after another starting with the section "Basics".
MS Excel
This tutorial is optimised for MS Excel 2007. It is recommended that you have EXCEL running at the same time. You can try what you are reading. On an PC you can toggle back and forth between the Tutorial and Excel using the ALT-TAB. If you are using this on a Mac, switch back and forth with APPLE-TAB.
Section Link List
1. Basics
What is a spreadsheet? Why a computer? What are the basics of spreadsheets?
2. Data Types
What types of data do we use? Labels, constants, formulas. Basics of formula design. Referencing, changing formulas, selecting cells.
3. Formulas
Important functions: SUM, MAX, MIN, AVERAGE, COUNT, IF, SUMIF, SUMPRODUCT, NPV, IRR, PMT, CHOOSE, LOOKUP, INDEX(MATCH)
4. How to
How to copy formulas, fill down and right, absolute positioning, formatting, inserting rows and columns.
5. Graphs
Quick overview on how to create useful graphs and charts.
6. Excel Shortcuts
Excel speed trick: Forget the mouse! Forget the mouse! Forget the mouse! Forget the mouse! Forget the mouse!
Navigation
This website uses simple buttons for forward/backward navigation. At any point, hit the home button to get back to the start screen.
 |
Jump to previous section |  |
Jump to next section |
Quizz
Take the Quizz
You may take the quizz before or after completing the tutorial to check your knowledge of basic spreadsheet modelling. Multiple attempts are possible.
Credits
Credits
If you have any comments, please email me at m.harder (at) jbs.cam.ac.uk. The initial pages (basics and data types) of this tutorial are based on the Excel 97 tutorial by Brad James who has compiled key elements for a concise tutorial. Any mistakes remain my own.
