How to Use Structured References in Excel

Подписаться 542

Просмотров 4,2 тыс.

50% 1

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.

Хобби

Опубликовано:

27 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 18

@Pankaj-Verma- 3 месяца назад

Thanks.

@AnnetteSlager 2 месяца назад

Your Welcome

@user-tc5pl3zw3h 3 месяца назад

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.

@user-nv7tq9nt6p 3 месяца назад

You are wonderful at explaining. Thank you!

@AnnetteSlager 3 месяца назад

You're very welcome!

@heshamsaad9883 4 месяца назад

You are doing very well - like your vedios

@AnnetteSlager 4 месяца назад

Glad you like them!

@user-lb3ll3me5b 4 месяца назад

Vary nicely explained, thanks a lot 🙏

@AnnetteSlager 4 месяца назад

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

@praveenips4149 7 месяцев назад

Which version of excel are you using?

@AnnetteSlager 7 месяцев назад

I am using Excel 365.

@praveenips4149 7 месяцев назад

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 7 месяцев назад

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 4 месяца назад

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 4 месяца назад

This is working in office 365 but not in office 2016

@user-wb7ei2ii5l 2 месяца назад

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

@julialewis8794 2 месяца назад

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