A downside to using the table names in a formula: without the @ symbol for structured cell reference, you are likely to get a #SPILL error. Took me a while to figure that out.
Full disclosure- I am a big proponent of using tables, precisely because of the way they do referencing. It's interesting that you can turn that feature off, but I don't understand how that would benefit anyone? I guess there are people who are set in their ways, but whenever I show this to someone, they greatly prefer the way that tables use named referencing like that. Anyway, that's just my personal experience over the years, I enjoy your channel and I appreciate the videos you put out.
Great question Joe! One of the biggest complaints I see for users that are NEW to tables is the structured references (table formulas). It surprises users when they are writing formulas in a file that someone else created. They don't immediately understand the notation and just want to see regular cell referencing. I completely agree that structured refernces can make formulas easier to read and write, once you understand the syntax. Since it's an application level setting, each user will have to turn the setting on/off on their own computer. The settings doen't travel with workbooks. Which IMO would actually be a nice feature. I go into more depth on the pros and cons of this in our training programs, but I hope that helps. Thanks! 🙂
Is there not a keyboard shortcut to toggle that? I took an excel class recently through work and he showed the "defined names" stuff. Is that totally different? Cuz I feel like he showed a way to show the cell reference or the named reference. Should've taken notes on it
Cool! Question from fellow youtuber --what do you use to record the screen cast? Was the software moving the frame following your mouse cursor or was it just nice editing?
A downside to using the table names in a formula: without the @ symbol for structured cell reference, you are likely to get a #SPILL error. Took me a while to figure that out.
No Jon, don’t do it! That is crazy 🤪
Don’t turn them off. Open your heart and embrace them! 🤗
Structured references are amazing.
That's crazy, that is exactly why I loved about tables!
I love and am very suitable using table names in formulas.
Thank you for this awesome tip, that will definitively reconcile me with "tables".
Glad it was helpful, @MrsCathT! 😀
Control shortcut option thankyou
Amazing and thanks a ton 👍👍
Full disclosure- I am a big proponent of using tables, precisely because of the way they do referencing. It's interesting that you can turn that feature off, but I don't understand how that would benefit anyone? I guess there are people who are set in their ways, but whenever I show this to someone, they greatly prefer the way that tables use named referencing like that. Anyway, that's just my personal experience over the years, I enjoy your channel and I appreciate the videos you put out.
Great question Joe! One of the biggest complaints I see for users that are NEW to tables is the structured references (table formulas). It surprises users when they are writing formulas in a file that someone else created. They don't immediately understand the notation and just want to see regular cell referencing.
I completely agree that structured refernces can make formulas easier to read and write, once you understand the syntax.
Since it's an application level setting, each user will have to turn the setting on/off on their own computer. The settings doen't travel with workbooks. Which IMO would actually be a nice feature.
I go into more depth on the pros and cons of this in our training programs, but I hope that helps. Thanks! 🙂
thanks John
Thank you Jon for this great tip :)
You're welcome, Nader! :)
Is there not a keyboard shortcut to toggle that? I took an excel class recently through work and he showed the "defined names" stuff. Is that totally different? Cuz I feel like he showed a way to show the cell reference or the named reference. Should've taken notes on it
Awesome 😊
Awesome trick. Keep up the great work, Jon.
Thanks, Nestor! :)
Cool! Question from fellow youtuber --what do you use to record the screen cast? Was the software moving the frame following your mouse cursor or was it just nice editing?
But the problem with tables is that many necessary formulas do not work and you got a spill error like right, left, textafter...etc.
Kinda hate that pivot tables use their own reference formulas as well. Makes it a challenge to have helpers
Untick the Getpivot formulas on excel option.
@@quadriatharutech Nice
Nice but could formula for running total writen in table with normal cell reference work properly if i remove or add rows ????
😊