How to Use Structured References in Excel

[@user-tc5pl3zw3h]

I cannot believe how painstaking and patient this was. I needed a tutorial with every keystroke explained. EVERYONE else wants to breeze through this stuff. For context, I'm blind, and I followed this entire thing completely. I don't know if blind people are who you had in mind, but this was phenomenal. I want you to teach me everything now! Now I'm wondering about using structured references in formulas like COUNTA and COUNTIF where I reference a whol column At least I have the confidence now to take a shot at it. Could have used an exit comment, though...

[@AnnetteSlager]

Thank you so much for your kind words and feedback! I'm glad the tutorial was helpful to you.

[@DeniseSibrian]

You are wonderful at explaining. Thank you!

[@AnnetteSlager]

You're very welcome!

[@user-lb3ll3me5b]

Vary nicely explained, thanks a lot 🙏

[@AnnetteSlager]

Thanks a lot for the comment! I'm really glad it was helpful to you.

[@heshamsaad9883]

You are doing very well - like your vedios

[@AnnetteSlager]

Glad you like them!

[@kennethstephani692]

Great video!

[@AnnetteSlager]

Glad you enjoyed it

[@Pankaj-Verma-]

Thanks.

[@AnnetteSlager]

Your Welcome

[@praveenips4149]

Plzz help me with this, Does table reference #all work in excel 2016. If is it work ,then why It shows me the #value error. And if not then in which version of excel does it work.

[@AnnetteSlager]

I am using version 365. When you enter the table name and the left bracket =TableName[ do you see the #All option? If not there maybe a problem with your table. Be sure it is actually a table. Make sure you are enclosing the #all within a left and right bracket [ ] and not parenthesis. You can also click on any cell in your table then click on Table Design on the ribbon's menu and verify that you are using the correct table name.

[@zoranstojanovski8407]

I use excel 2019 and got same error #VALUE! I got that error if I use #All, #Data, #Headers, but not if I use Table1[SomeColumn]. I also notice that array formulas not expand to more then one cell.

[@praveenips4149]

This is working in office 365 but not in office 2016

[@praveenips4149]

Which version of excel are you using?

[@AnnetteSlager]

I am using Excel 365.

[@CornelBuckley-p3f]

She keeps saying SA. She did not explain. What does SA mean?

[@julialewis8794]

Sa is literally the first 2 letters of the words "sales table". When she types sa Excel filters the named ranges and tables etc for items beginning with sa and then she can double click on the selection she wants without having to type the whole thing out