Microsoft Excel: Relative & Absolute Cell References

Understand why a formula that works in one cell gives the wrong answer when you copy it, and how to fix it. This course explains relative, absolute and mixed references, the F4 shortcut, references to other sheets and named cells, with worked examples you can try straight away.

Tutwoo is an independent learning provider and is not affiliated with or endorsed by Microsoft. Menu names and features can vary between versions and platforms and change with updates. This course is general skills training and is not an accredited qualification.