How to use Excel formula references - A1 vs. $A$1 vs $A1 vs A$1 explained

Want to write better & smarter formulas? Then you must master the reference styles in Excel. There are 6 styles in Excel cell refs.
1) Relative reference - A1
2) Absolute reference - $A$1
3) Mixed reference style - $A1
4) Also mixed reference style - A$1
5) Table reference - Table[Column]
6) Table relative - [@Column]

In this video ⏱👇
==============

0:00 - Introduction to Excel reference styles (relative)
1:33 - How to make a reference Absolute
2:20 - Cell reference used in business situation - Example
3:49 - Using Mixed Reference style (A$1, $A1)
5:06 - Using Absolute Reference ($A$1)
6:57 - Using Reference Style in a Range ($A$1:A1) - IMPORTANT TIP
8:10 - Structural References
9:55 - Closing Remarks

Sample file 📗📈
==============
https://chandoo.org/wp/wp-content/uploads/2021/09/references.xlsx

Learn more about Excel formulas 📚👇
===============================

Top 10 Excel formulas for data analysis work - https://youtu.be/Q-XGJbHG8Vo
10 Awesome things you can do in Excel without Formulas - https://youtu.be/W1QhTQCasb4
Data Analysis in Excel - Beginner to PRO course - https://youtu.be/v2oNWja7M2E

#ExcelReferences

Видео How to use Excel formula references - A1 vs. $A$1 vs $A1 vs A$1 explained канала Chandoo