=SUM(SalesTable[Amount]) is much easier to audit than =SUM(C2:C100) .
Here is a concise guide to the core concepts likely covered in your file:
You can manage these under the Formulas > Name Manager tab. 5. Circular References
Locks either just the column or just the row. This is essential for creating multiplication tables or dynamic headers. 2. 3D & External References