How to Use Structured References in Excel
Тәжірибелік нұсқаулар және стиль
How to use Excel Structured References both in tables and out of tables. Use Structured Reference to perform math functions on multiple tables. This tutorial starts with brief look at Relative Cell Addressing so that you can compare it to how Structured Referencing works. Use Excel Structures to copy all or part of a table. Learn how to use Structured References to copy a portion of a table such as a row, column, headers, totals, etc. If you are interested in taking the Excel certification test for the MO-210 exam, this Excel tutorial covers what you need for step 4.1.2 Structured References in formulas,
Don't forget to subscribe to our channel for more handy Excel tutorials!
Free content to those who Subscribe: professoroffice.com/contact
0:00 - Relative Cell Addressing
1:24 - Structured References using Column Headings
2:30 - Use Structured References Outside of Tables
4:12 - Use Structured References to perform math on multiple tables
5:55 - Use Structured References to copy all or a portion of a table.
Пікірлер: 18
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
3 ай бұрын
Thank you so much for your kind words and feedback! I'm glad the tutorial was helpful to you.
You are wonderful at explaining. Thank you!
@AnnetteSlager
4 ай бұрын
You're very welcome!
Vary nicely explained, thanks a lot 🙏
@AnnetteSlager
5 ай бұрын
Thanks a lot for the comment! I'm really glad it was helpful to you.
You are doing very well - like your vedios
@AnnetteSlager
5 ай бұрын
Glad you like them!
Thanks.
@AnnetteSlager
3 ай бұрын
Your Welcome
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
8 ай бұрын
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
5 ай бұрын
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
5 ай бұрын
This is working in office 365 but not in office 2016
Which version of excel are you using?
@AnnetteSlager
8 ай бұрын
I am using Excel 365.
She keeps saying SA. She did not explain. What does SA mean?
@julialewis8794
3 ай бұрын
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