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.