In this lesson, I’m going to be showing you how to:
- Understand what is a Relative cell reference in excel
- Understand what is an absolute cell reference in excel
- The differences between relative & absolute cell references
- Know when to use relative & absolute references in a formula before replicating it
Go ahead, open the video below and watch the tutorial at your own pace:
If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)
Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂
Thanks for watching!
When you’re ready move onto:
Lesson 32: What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel
Or go back to:
Lesson 30: Best method to format numbers to display as PERCENTAGES in Excel
Lesson 29: Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel
Lesson 28: A simple DIVISION formula in Excel | How to DIVIDE in Excel
Lesson 27: What is the thousand separator in Excel | How to use the thousand separator in Excel
Lesson 26: Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?
Lesson 25: Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?
Lesson 24: How to SORT data in ASCENDING order in Excel
Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel
Lesson 22: How to RENAME a worksheet in Excel
Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel
Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?
Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?
Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?
Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel
Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel
Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel
Lesson 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?
Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel
Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit
Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells
Lesson 10: How to use the INSERT FUNCTION command in Excel
Lesson 9: Simple Subtraction Formula in Excel
Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data
Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel
Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel
Lesson 5: Average Function in Excel | What does Average mean
Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel
Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive
Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons
Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)
Hope you are enjoying your learning 🙂
Habib Ali – ICT Tutor