Thank you so much this benefit tutorial. I wanna add an information about tables that if you drag a cell (including formula) within the specific table field, the cell belongs to column fiels also drags the next table field unfortunatelly. So it needs to be carreful if you drag a cell in a table. Most important issue is that you should copy cell using CNTR+C and paste it as formula. It keeps the correct fields in table and return correct values. ‼
Thank you Wyn. I have been trying in vain to apply a Timeline to just a table (NOT a pivot table). Just displaying the data of a table based on period based on the Timeline selection. Is that possible?
The auto fill for calculated columns in an Excel table can be unwanted for users that want to use tables old school style. It is actually an auto complete feature that can be disabled. Then you’ll get an extra context button that allows you to fill down the formula when you do want that to happen.
@@AccessAnalytic try working on a common table with other users. Some fill in the columns for their records with data (numbers,…) others wanna be smart and use a formula for their records, and then the fun starts… The thing is: it’s a per computer setting you need to change. You can’t store the desired behaviour in the file.
@@GeertDelmulle, @AccessAnalytic, yep, exactly this. I use Excel for inventory counting with my other users and have to instruct them to turn off auto format as you type before they begin. If they use formulas instead of entering plain numbers, it will replace everything under it with the formula, hence losing all previously entered data.
Tables are amazing , I use them mainly cos of autofill and formatting (builtin formatting 😀, I hate playing with colors) And Ofcourse the auto update for pivot tables no need to change the source
@@AccessAnalytic Undisputable, Tables are great feature in Excel. Arguably, Pivot Table could rank first. Power Query could be regarded as a stand alone Analytical Tool, though it is native to Excel. Just thinking loud!
Love Tables! It makes it so much easier to work with data.
Great video which is extremely helpful. Thank you!
You’re very welcome
Great tutorial! Tables are essential for building a proper dataset. Thank you!
Thanks for taking the time to leave a kind comment
Another great video with wonderful tips for using tables. Tables rock!
Spread the word!
Great vid! some tips I'd never come across. thanks!
No worries. I appreciate you taking the time to let me know you found it useful
Thanks Wyn. Tables are definitely critical
Spread the word!
Thanks for the video
You’re welcome
Thank you so much this benefit tutorial. I wanna add an information about tables that if you drag a cell (including formula) within the specific table field, the cell belongs to column fiels also drags the next table field unfortunatelly. So it needs to be carreful if you drag a cell in a table. Most important issue is that you should copy cell using CNTR+C and paste it as formula. It keeps the correct fields in table and return correct values. ‼
Ah that’s a good one. I should’ve mentioned that ( along with how to fix a column reference - maybe another video - Table Traps! )
Hi Wyn, one reason I sometimes avoid tables is there 'incompatibility' with dynamic array formulas.
Yeah would be good if arrays worked in tables
Thank you Wyn. I have been trying in vain to apply a Timeline to just a table (NOT a pivot table). Just displaying the data of a table based on period based on the Timeline selection. Is that possible?
No unfortunately not
The auto fill for calculated columns in an Excel table can be unwanted for users that want to use tables old school style.
It is actually an auto complete feature that can be disabled. Then you’ll get an extra context button that allows you to fill down the formula when you do want that to happen.
Interesting. I can’t think why I wouldn’t want it to autofill though
@@AccessAnalytic try working on a common table with other users.
Some fill in the columns for their records with data (numbers,…) others wanna be smart and use a formula for their records, and then the fun starts… The thing is: it’s a per computer setting you need to change. You can’t store the desired behaviour in the file.
@@GeertDelmulle, @AccessAnalytic, yep, exactly this. I use Excel for inventory counting with my other users and have to instruct them to turn off auto format as you type before they begin. If they use formulas instead of entering plain numbers, it will replace everything under it with the formula, hence losing all previously entered data.
Plz tell about Access Analytic tab and how we can get it?
Link is in the description of this video: 5 reasons we love the Access Analytic Toolbar
th-cam.com/video/YyK2MnBgBmE/w-d-xo.html
Tables are amazing , I use them mainly cos of autofill and formatting (builtin formatting 😀, I hate playing with colors)
And Ofcourse the auto update for pivot tables no need to change the source
Good stuff!
❤❤❤❤❤ Thanks 👍 by Excel spreadsheet lover
Yw
Ctrl + space 🎉
My favourite
What is Excel's 1st best feature?
Finally… someone asked 🤣.
Power Query
@@AccessAnalytic
Undisputable, Tables are great feature in Excel. Arguably, Pivot Table could rank first.
Power Query could be regarded as a stand alone Analytical Tool, though it is native to Excel.
Just thinking loud!