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-made-easy/?couponCode=FormulasYouTube 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 - https://youtu.be/hZCsyHyDpw8 Next video - Excel COUNTIF function examples - https://youtu.be/gg0S9GBNfR0 Download the FREE eBook of '27 Excel Hacks to make you a Superstar' - http://www.computergaga.com/27-excel-hacks-to-make-you-a-superstar.html Find more great free tutorials at; https://www.computergaga.com