A great time-saving trick is to use a prefix when naming your tables.
I use “tbl”, but some people use “t_” as the prefix. You can use whatever you want, but the key is to be consistent.
Why is this a good habit to get into?
Because it makes writing formulas easier.
You can see that all of the tables in my workbook are listed when I type “tbl” as I'm writing a formula. Instead of navigating to various sheets in the workbook and selecting the table I want, I can just choose from the list that appears when I type my prefix.
As long as I've used descriptive names when labelling my tables, this is a great timesaver for me.
I hope it proves helpful for you as well. Do you have a favorite tip or shortcut when it comes to using tables in Excel? I'd love to hear it. Leave a comment and let me know.