ABOUT THIS Lesson
HOW TO USE EXCEL RELATIVE AND ABSOLUTE REFERENCES BY EXCEL IN A MINUTE
Excel’s Relative and Absolute References.
Welcome to Excel in a Minute!
Most of you have probably seen the dollar sign in some Excel formulas and wondered what this is for. This sign is very important on Excel formulas as this prompts Excel whether to change the cell reference in the formula when you move or copy it to another cell.
There are two main classifications of cell references in Excel. The relative references and the absolute references.
A relative reference is a cell reference without the dollar sign before the row and column coordinates. When you move or copy a formula containing a relative reference to another cell, the reference changes based on the position of the new cell in terms of row and column.
For example, using this data, you want to get the total sales for each product by multiplying the price for each and the quantities sold.

________________________________________________________________________________________________

VIEW THE BLOG POST (in here you can download the presentation and the excel file)

https://excelintuitive.com/how-to-use-excel-relative-and-absolute-references/

______________________________________
SUBSCRIBE TO EXCEL IN A MINUTE ON YOUTUBE

https://www.youtube.com/channel/UCJhmJ7vzNgitvrn8XoivUEw?sub_confirmation=1

___________________________________________________________________
FOLLOW EXCEL IN A MINUTE ON SOCIAL MEDIA

Instagram ► https://www.instagram.com/excelintuitive
Facebook ► https://www.facebook.com/excelinaminute/
LinkedIn► https://www.linkedin.com/company/excel-in-a-minute

___________________________________________________________________
ABOUT EXCEL IN A MINUTE

ABOUT US
Excel can be Challenging , but EXCEL IN A MINUTE has simplified it for you. In less than 3 minutes, our videos will help you learn Excel tips and tricks faster than you have ever imagined. Learning is fast, skills are retained for life.
New Excel tutorials are released twice a week. Subscribe to our channel to be notified of new videos

Website ► www.excelintuitive.com

RECOMMENDED RESOURCES

If you found this video valuable, give it a like.
If you know someone who needs to see it, share it.
Leave a comment below with your thoughts.
Add it to a playlist if you want to watch it later.

DISCLAIMER: The information contained on this YouTube Channel and the resources available for download/viewing through this YouTube Channel are for educational and informational purposes only.​

This description may contain affiliate links. If you purchase a product through one of them, I will receive a commission (at no additional cost to you). I only ever endorse products that I have personally used and benefitted from personally. Thank you for your support!

#excelinaminute, #Msexcel,#excelintuitive,#msexcel,#ABSOLUTE,#RELATIVE

Please take the opportunity to connect and share this video with your friends and family if you find it useful.