Surprisingly, tables are the most misunderstood and, hence, underused feature of Excel. While some people confuse this feature with data tables developed by Scenario Manager, most people just plainly ignores it owing to its alien syntax. Microsoft Search Analytics revealed that less than 1% of the Excel users employ tables in their workbooks. This is a worrisome statistic given the multitude of difficult tasks tables simplify.
With Jordan Goldmeier facilitating the session, we have Oz du Soleil, Rick Grantham and our special guest Zack Barresse on the panel in this episode. And the topic is, you guessed it, Tables!
Zack goes on at lengths about how tables let you overshoot in many things you might want to do to the data. They can make a data analyst’s life much easier. But not all is hunky-dory. Tables do have some restrictions one needs to be aware of.
Zack list the following aspects of using tables as the source of his obsession with them:
Most of the time there is no good without some bad. And same is the case with Excel tables. Be sure to commit the following to memory:
There is no ugly side to using tables. We won’t be encouraging more use of this feature otherwise.
Rick brought up the topic of Zack’s new book “Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables”. The book is about tables, of course, but within the context of importing external data, Power BI, Data Models and Power Query.
Get your hands dirty and start learning about the tables. The more you do, the more it will fascinate you.
Do not forget to share this discussion with your friends or colleagues. Maybe tables is the solution to what keeps them up at night. And write to us with your views in the comments section below.
"Laminate Worthy" Quick Guides for the Excel Power User. Includes: