Beginners guide to Relative, Absolute and Mixed Cell References in Excel (and the shortcut)
This guide is a beginners tutorial looking at Relative, Absolute and Mixed References in Excel. We also learn the keyboard shortcut to switch a cell reference from relative to absolute and back!
The file is also available to download from our Google Drive - so you can follow along or use it for reference in your own time.
Chapters:
0:00 Introduction
1:03 Relative Cell References
1:54 Absolute Cell References
3:02 Mixed Cell References
Download the file here: https://drive.google.com/file/d/1HNR6...
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our other videos and playlists, such as our 'Week 4 - Introduction to formulas and functions' playlist: • FREE Excel course for beginners: Week...
Or check out our other cell reference videos:
Excel for Beginners: ABSOLUTE and RELATIVE cell references: • Excel for Beginners: ABSOLUTE and REL...
ABSOLUTE CELL REFERENCE: learn the shortcut! (beginners excel tutorial): • ABSOLUTE CELL REFERENCE: learn the sh...
