Introduction to Structural References | ExcelTutorials

Introduction to Structural References | ExcelTutorials

Do Subscribe, Like & Share my video if you like!!

Click The Below Link To SUBSCRIBE:

[ChandooD]

Sorry about the audio. I was using my laptop's built in mic for this. Will try to re-record the video once I am back home and can use my professional mic.

[jayi]

Structural References have really impoved my spreadsheets. Although, if you are distrubuting a spreadsheet to users who are unfamiliar with Structured Tables, it can be frustrating trying to intentionally place an inconsistent formula into a column that already has a formula as the whole column changes. Of course, you just need to do a Undo (Ctrl + Z) to counter the autofill of the calculation to the column. Unfortunately, now you have lost a key feature of a structured table.

[predpalina]

How do you use Excel to make ABC Inventory Analysis?

[jamesperry]

Hello Chandoo & here's my Q:
Is it okay to use the Table1 ref in the =SUM formula instead of mySales ??
Thank$.

[r_b]

Great information, but the audio is annoying. My speaker volume setting is at 90% and I can barely hear the audio. And what is that garbled sound at 7:45? Keyboard strokes drowns out the inaudible explanation at various times. Is the mic laying on the keyboard?

Is so annoying I stopped the tutorial at 9:00, and went looking for another tutorial on structured references.

[rautorama]

Hey Chandoo, the structured references are not working when i am putting formula in conditional formatting. It says my formula has error, why is that. Named ranges are fine but table references are not working? any ideas?

On your forum one member advised to use structured references as a named range which works, however iam wondering why this happens?

[bhushansabbani]

The information is great. The volume is too low.

I am unable to hear in spite of full volume.

[wong]

You might want to re-do the audio track. It is unclear and too low in volume.

[LisbethLog]

Valuable information here but I can hardly understand what you're saying, not because of the accent, but because of the low volume. I have already turned up my PC's volume to maximum.

[robertclark]

Sorry, but audio is too fuzzy to understand clearly.