Скачать или смотреть Excel Formulas Part 7: Absolute Cell Reference v Relative Cell Reference

In this video we understand absolute cell references in Excel formulas.

There are two main types of cell reference in Excel; absolute and relative. A relative reference is the normal reference you see everyday.

An absolute cell reference is shown with dollar signs and fixes the reference, or refers to the cell absolutely.

This video tutorial will show a 'real world' example of when and why you would want to use an absolute cell reference, how to apply them and a little keyboard shortcut too.

Enroll in the complete Excel Formulas course and become an expert in formulas in just a few hours. Over 100 formula examples - https://www.udemy.com/excel-formulas-...

This video is the Seventh in our series to learn Excel formulas. It is aimed at beginners to Excel formulas to get to an intermediate level quickly and easily.

Previous Video - Calculate difference between two dates including working days only -    • Excel Formulas Part 6: Date Difference inc...  

Next video - Excel COUNTIF function examples -    • Excel Formulas Part 8: Excel COUNTIF Funct...  

Download the FREE eBook of '27 Excel Hacks to make you a Superstar' - http://www.computergaga.com/27-excel-...

Find more great free tutorials at;
https://www.computergaga.com

Connect with us!
LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1