Copy formula WITHOUT cell reference change- $ signs in XL formula
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
Understanding the $ signs in Excel formula that make it easier to build a single formula and copy it across and down without having to change the cell references all the time.
------------------------------------------------------------------------------------------------------------------------------------------------------
- Free check of your Excel Skill Level-
- Test employee Excel skill levels-
- Improve you Excel Skill Levels-
- Our main website-
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 What are the $ in Excel formula?
00:14 Build Excel formula you can easily copy across/ down
01:24 $ in Excel formula tells Excel to not change the cell reference
02:15 Copy/ paste a formula across a row and it still works
02:45 Absolute referencing very important in Excel
