@bjbrooks
Excellent romp through the capabilities of tables. But what I must comment on is the sheer quality of the video presentation. The content, the text, the pace, the examples, the fluent delivery, the highlighting, all perfect. Awesome, using the word in its proper sense. Thank you 🙂
@BenWolverton-m1t
In starting a new job or whenever I open Excel for the very first time, the first thing I do is customize the Quick Access Toolbar to include: freezing pains, trace dependents and remove arrows, and, the best tool ever!, the camera tool (and other tools as well). The camera tool literally takes a picture of whatever object or data I want to appear somewhere else in the workbook. Say for example you're building a dashboard and you want to put a small chart or little table in an area that doesn't conform to the columns and rows where it needs to go. Putting a dynamic chart or table there as a picture, that's automatically updated whenever the data or calculation changes, is very handy.
@kgadeberg
I have been using tables for years and can now hardly enter a single value in Excel without turning it into a table 🙂 I think my favourite benefit is the ability to reference cells using the structured formulas but also find the filtering very useful (right-click any cell and use 'Filter by Selected Cell's value' is one I use all the time)
@lewesmariner
For Tables, I use keyboard shortcuts CTRL and full stop/period to cycle through the four corners of the Table (good for getting to the bottom of a large Table). Also CTRL and spacebar to select the Table column you are in (excluding heading - repeat to include heading) - great shortcut for functions such as SUM and SUMIFS
@martinstannard2859
Great video as always Mynda :) Couple of things that I think could be also worth mentioning with tables: Every time I create the first table in new workbook, I always duplicate the Table Style and use that instead. The two changes I always make are to remove the internal horizontal borders (not required because of the banded rows) and add internal vertical borders (so the columns have borders). Looks much better I think! And it makes the data easier to read. The other great thing about table ranges that no one seems to mention is that if you use Conditional Formatting with formulas, it is of course dynamic. If you don't use a table, as I am sure you already know, every time you add a new row/s or copy and paste rows, it duplicates every CF formula rule in that range. This can make the CF list really messy after a while, and at worst, after a long time it can slow down the workbook.
@waterbourne9282
Wow. I'd been doing all that table functionality manually. This will save me so much time. Much appreciated.
@msmith3090
Great look at tables and their value! I didn't learn about tables until I started studying Power Query a few years ago. Once I realized how useful they are, I started incorporating them into my workflows.
@bjornkumpf274
I love the way you explain ... precise, unagitated, without gimmickry (Ich liebe es, wie Sie erklären ... präzise, unaufgeregt, ohne Effekthascherei)
@jokearney3540
Tables are a complete game-changer in being able to safely and accurately update a table of data, and the pivots and graphs that feed off it. So great!
@AlexandersPappa
Thanks for a great video as always! One thing not mentioned (I think?) is that the Ctrl+Shift+L shortcut works equally well with tables as with ranges. One of my most used shortcuts for sure, a real time saver especially with large tables where you can't see every column header and might not be sure whether there is a filter applied somewhere.
@DrDamoStrikesBack
I've been using tables for years and can't live with out them. I literally use them many times a day. The default behaviour of copying formulae down when adding rows is amazing. Structured referencing is also a boon for any non-trivial work. Lookups and aggregation that refer to a table (or its component columns) as named objects saves significant time and prevents the possibility ranging errors when expanding the table. Also, tables are fantastic as a data source for pivot tables—hugely useful.
@traciesmobile683
Named tables are great. They make formulae so much easier.
@ifoster3011
Thanks for the great content that you produce Mynda; I’ve learned a lot from you. My table tips are: I use table column references in calculations in other tables, and I was originally frustrated by not being able to ‘drag out’ those calculations, as Excel changed the column references accordingly. The way to freeze those references is to write in the form table[[col1]:[col1]] I use tables to hold lookup values for data validation settings. Create a table, then create a named range of the same cells in the table; use that range for the data validation setting. As users need a new valid input, they can append to the table and the range grows to match.
@sethazimmerman
One of the first things i do when setting up Excel is create a macro in my personal workbook for center across selection. I assign a keyboard shortcut and boom! So much easier than going to the format menu.
@babydadoo
Love this content! A few months back I was blown away when looking at a coworkers code which used tables to easily manipulate data in VBA, and will be looking at more options to use them in my work go forward
@thearchibaldtuttle
Absolutely! Tables help a lot in organizing your data and make working with data much easier.
@paulgattini5075
tables are great for getting the data set up for power query conversion to form an output that can be easily be updated when ingesting other like data
@robsbisa1411
Establishing and naming tables is almost always my first step. It's especially useful with 365 features, like LET() or INDEX(MATCH), where I'm able to create complex formulas quickly, knowing the names of my tables.
@yvlove77
I use tables almost exclusively; while not always an option, I especially prefer them to non-tables when working with dynamic arrays. One of my favorite tricks is to put the column numbers in the row above the table with the sequence function to use with CHOOSECOLS formulas (=SEQUENCE(,COUNTA(TableName[#Headers]))); that way the count will automatically be updated as more columns are added. And the little black arrow (down or right) is very helpful to select only something within the table; it makes deleting rows much easier. Yeah, I love tables and I encourage people to use them whenever I can.
@MyOnlineTrainingHub