Relative & Absolute Cell References :Excel

preview_player
Показать описание
In this video, we will talk about Relative & Absolute cell references in Excel.

Reference cells correctly when writing Excel formulas. If your formulas are not working correctly when you copy them to other cells, you've probably made a mistake with your cell referencing.

Some cell references might need to be fully fixed, some partially fixed. This is called absolute versus relative cell references in Excel. Understanding this concept really simplifies your Excel work.
F4 Key can help you to bring all variations of a cell reference.

You can download the file used from the below link.

Also, check these videos if you want to learn more

1 Min Excel: If you enjoy short videos check this section

Excel: Check this playlist for Excel-related things

Keyboard Shortcuts: Check this section to save some time in everyday excel work

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports

Power Query: Check the Power Query playlist for Data Preparation & its Automation

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations

Please subscribe to our channel and Follow us on other social media platforms for regular updates :

Рекомендации по теме
Комментарии
Автор

Explained beautifully. Easy to understand 👍

theakashsharmaofficial