Easier Table References in Excel - EQ 92

Excel Quickie Playlist:    • Excel Quickies  
Excel File: https://www.teachexcel.com/excel-tuto...

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 Resources
Complex Structured References (Table Formulas) in Excel: https://www.teachexcel.com/excel-tuto...
Using structured references with Excel tables (msft): https://support.microsoft.com/en-us/o...

Excel Courses:
VBA/Macro Course: https://www.teachexcel.com/vba-course...
Building Professional Forms: https://www.teachexcel.com/premium-co...
Email Course: https://www.teachexcel.com/premium-co...

TeachExcel.com

#msexcel #excelquickie #tutorial