Structured References in Excel Tables

Lesson 2 of EXCEL Tables

In this lesson, let’s learn about the structured references that are used in the calculation in Excel table’s calculated columns and totals row. Unlike the regular cell reference, the structured reference is easy to read. Also, it is dynamic and gets updated automatically whenever you add or remove data from an Excel Table.

---------------
Other videos on Excel Tables:

E016(a) - Overview & Creation of Excel Table

---------------------
My Other videos on Excel:

E001 - 10 ways to Auto Fill in Excel

E002 - 9 Examples to Fast-track Data Entry in EXCEL using 'FLASH FILL'

E003 - 20 Different Ways to PASTE your Data in EXCEL

E004 - All about PIVOT TABLE in EXCEL

E005 - Learn to TRANSPOSE your Data in Excel

E006 - All about CTRL+A to CTRL+Z Shortcuts in Excel

E007 - Master the Basics of VLOOKUP in EXCEL

E008 - Excel VLOOKUP - When to use Approximate or Exact match?

E009 - Handling Errors in VLOOKUP in EXCEL

E010-Excel Shortcuts F1 to F6

E011-Excel Shortcuts F7 to F9

E012-Excel Shortcuts F10 to F12

E013-Analyze Data Instantly using Quick Analysis Tool

E014-Conditional Formatting in Excel

E015(a) - Excel SUBTOTAL Function: Understand the Basics & Syntax

E015(b) - SUM Vs SUBTOTAL

E015(c) - Work with SUBTOTAL: How to Insert SUBTOTAL in a Data Range in a Worksheet

E015(d) - How to use Nested SUBTOTALS?

E015(e) - How to Insert SUBTOTALs in Excel Pivot Tables?

E015(f) - Remove SUBTOTALS

---------------------
My Other YouTube Channel in Tamil Language:
---------------------------
#Excel
#MicrosoftExcel
#Exceltable
#MSExcel
#Spreadsheet
#Spreadsheets
#MSOffice
#Office
#Microsoft
#OfficeOnTheWeb
#Microsoft365
#Office365
#SUM
#SUBTOTAL