This is the first part of a two-part tutorial illustrating a range of
techniques useful for creating all kinds of spreadsheets in Excel.
Starting with basic data entry and formatting this part goes on to
build a simple interactive financial model. It includes formulas
that use percentages. It uses the Autofill tool to simplify the entry
of text and calculations, and illustrates the significance of
absolute references in formulas. Finally, a drop-down list is added
to create a simple interactive tool.
This video has an audio commentary and is best viewed at 720p (HD)
If you don't have an audio facility you can also view this video as
step-by-step viewlet with text annotations.