In this lesson, I’m going to be showing you how to:
- Understand what is an absolute cell reference in Excel
- Understand why it is important to use absolute cell reference to a formula before replicating in Excel
- Apply an absolute cell reference to a formula before replicating in Excel
Go ahead, open the video below and watch the tutorial at your own pace:
If I have not covered anything 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 30 – Best method to format numbers to display as PERCENTAGES in Excel
Or go back to:
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 (£) and apply 2 Decimal places to numbers in Excel?
Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?
Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?
Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?
Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?
Lesson 8 – What is the IF function, and how to insert it in Excel?
Lesson 7 – What is the ROUND function, and how to insert it in Excel?
Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?
Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?
Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?
Lesson 3 – Simple Subtraction Formula using Excel
Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel
Lesson 1 – Simple multiplication Formula using Excel
Hope you are enjoying your learning 🙂
Habib Ali – ICT Tutor