Tutorial 9: Create a formula in Excel

Excel Video Tutorial 9: Creating and using a Formula in ExcelThis video tutorial provides advice and guidance on how to create and use formulae in a spreadsheet. The use of formulae is the single most important skill to develop in using Microsoft Excel. This video will show how easy it is to acquire this skill.

This tutorial also explains the anomaly that can occur when you autofill a column for formulae and then need to use an absolute cell references.

Examples of Cell References

Placing the $ sign in the correct place changes a relative reference to an absolute reference. The $ (dollar sign - second top row on keyboard) can be typed or use the F4 key.

Explanation Sample
Relative Reference (cell reference will change when formula is copied to different location) D2
Absolute Reference (cell reference will NOT change when formula is copied to different location) $D$2
Mixed Reference (the column is "fixed" (i.e. column D) when the formula is copied to a different location. The row number will change when the formula is copied to a different location $D2
Mixed Reference (the row is "fixed" (i.e. row 2) when the formula is copied to a different location. The column number will change when the formula is copied to a different location D$2

Downloads for Practise

The following download provides a spreadsheet as seen in the video tutorial"

 

 

 

 

Event Operations Manual
Software for Club Treasurers