Using Table Structured References in Excel functions

The Excel Table structured references may seem awkward at first, but when you get used to it, you will find many advantages in using them instead of the regular cell references. My favorite one is not having to worry about having to lock ranges with $, when writing a function referring to an entire column or table range. ---------------------- Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer Facebook:   / solveandexcel   Instagram: @solveandexcel LinkedIn:   / celiajordaoalves   LinkedIn:   / solveandexcel   Twitter: @celia_excel Solve & Excel Consulting - https://solveandexcel.ca/ ------------------------- #Excel #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada