Excel - Absolute & Relative Cell Addressing

With the basics of formulas and functions covered, you are going to need to copy these calculations across your spreadsheet. All well and good until you notice that in some cases the formula isn't copying properly.

Ever had a formula that when copied references the wrong cell? Well this is down to Absolute & Relative cell referencing.

Before you suddenly get cold shivers down your back and are running for the nearest exist, I assure you its not complicated, its something you need to understand.

By watching this video you will be able to understand what Absolute Versus relative cell referencing is and how to control it to your bidding!

This video comprises of an example file that can be obtained by registering at my website PCTeach.me

Category:

Education

Tags:

• Absolute
• Cells
• Copy
• Excel
• Formula
• Formulas
• Function
• Functions
• Microsoft
• Paste
• Relative
• Spreadsheet
• tips & tricks
• tutorial
• software
• data
• Microsoft Excel

[PCTeachME]

thanks

[TheGeshe]

awesome video..thanks for the upload....:D