Excel has three cell references - Relative, Absolute, and Mixed. It is critical to understand when to use each reference in Excel. The default reference is relative is used frequently in Excel. The next highly used reference is absolute. Finally, we have two mixed references.
Chapters:
00:00 Introduction
00:27 RELATIVE references
01:53 ABSOLUTE references
04:59 MIXED references
09:11 Vertical Analysis
Examples of References:
A1, B2, C34, and Z90 are relative references - no dollar signs
$AS1, $C$7, and $R$8 are absolute references - two dollar signs
$A4, $C6, A$3, and E$8 are relative references - one dollar sign
Chris Menard's Blog Post
[ Ссылка ]
Microsoft article on cell references [ Ссылка ]
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
![](https://i.ytimg.com/vi/fIGo0fk9pm4/maxresdefault.jpg)