We are in the process of updating the site, so some pages still have the older design.
Easier Table References in Excel
Some simple tips to make table references easier in Excel, even when you don't remember the name of the table or its columns.
This little trick shows off some of Excel's auto-complete type features for formulas and also a great tip for naming your tables so that its always easy to reference them in your formulas.
Additional References
Download the Project Files
Follow along with the tutorial by downloading the files used in it. (Completely Free)
Phone number is optional - we use it to send course discounts and weekly updates via SMS.
View our Privacy Policy | Terms of Use
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: How to use complex structured references, table formulas, in Excel. If you don't already...
Tutorial: In this tutorial I am going to cover the difference between Absolute and Relative Cell Ref...
Tutorial: In Microsoft Excel you reference columns as letters by default - A1, B3, C5, etc. But you ...
Tutorial: Convert a table back into a regular set of cells. This removes any automated table fea...
Tutorial: How to create dynamic charts that update automatically when new data is added to Excel. T...
Tutorial: Have one simple formula that will reference the same cell or range of cells on multiple w...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)