Are you using tables in Excel but sometimes find them more confusing than helpful? This video uncovers the "Table Traps" that can cause unexpected issues, like hidden formulas reappearing, total rows behaving unpredictably, and frustrating formula references that refuse to stay locked. With practical solutions and tips, you'll learn how to handle these quirks confidently and efficiently.
From mastering table features like drag-and-drop totals and managing dropdown lists to implementing custom fixes for name-scoping errors, this guide equips you with everything you need to avoid common pitfalls. Plus, discover time-saving hacks, including setting up quick access toolbar icons and clever formulas for detecting hidden filters. Simplify your Excel workflow and conquer tables like a pro!
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
00:31 Ghost Formulas
02:51 Locking Table References
07:03 Filtering Tips
10:51 The Named Table bug
The ISFILTERED formula
=LET(_tblName, tblSales2, IF( AGGREGATE(3,4,_tblName)=AGGREGATE(3,5,_tblName)," ✅ no filter", "⚠️ FILTERED!" ) )=LET(_tblName, tblSales2, IF( AGGREGATE(3,4,_tblName)=AGGREGATE(3,5,_tblName)," ✅ no filter", "⚠️ FILTERED!" ) )
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/