Name a Table in Excel for Easy Access in Formulas

If you have a set of data that you will be using as a source for multiple queries, it is a good idea to name your data set for quick and easy access. Giving a meaningful name to a table is particularly useful when you have multiple tables on a single worksheet and have formulas that refer to the tables.  By using the names for the tables, you can instantly tell when looking at a formula which table it is referencing!  Hint…It’s really simple! The possibilities for using this are numerous!  Watch the video and give it a try yourself!  As always if you have any questions, let me know!  This trick works in Google Docs as well! (The process is a little different, but if you would like to know how, let me know!)