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

Description:

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 📗📈 ============== Learn more about Excel formulas 📚👇 =============================== Top 10 Excel formulas for data analysis work - 10 Awesome things you can do in Excel without Formulas - Data Analysis in Excel - Beginner to PRO course - #ExcelReferences