By Zack Barresse
If you haven’t noticed I have a thing for tables. I like them so much I’ve dedicated this site to them, as well as co-authoring the first book of its kind, and have an Excel add-in developing due out soon. The idea being we’re all tables all the time. There’s so much you can do with them, albeit not perfect, these versatile little bastards are pretty awesome.
In strict accordance with our mission to get the word out about tables, show effective ways to use them, and generally look like a boss with Excel, I’ll be doing a series of webinars. Two of these will be hosted by VBAX. The first will be on August 8th, 2014, from 2-3 PM (PST) covering the basics of tables, benefits, basic fundamentals, why you should use them, the added benefits they give, and some of the most common pitfalls when using them. Some of the topics covered will be:
- Various ways to create a table
- Applying and modifying table styles
- Demystifying table formulas
- Common workarounds with structured referencing
- Easily filter and sort your data
- Things to avoid when using tables
Make tables work for you, reap the benefits of working with good data and making them look extraordinarily professional with the click of a button. The idea is to take these underused tools and make them do the work for you. They’re severely underused and our goal is to show people all the good which can come with utilizing them.
The next week on August 15th, 2014, at 2-3 PM (PST) will be a follow-up webinar covering VBA with tables, again hosted by VBAX. Learn best practices for working with table ranges, how to apply calculated columns, returning data from queries and external sources, and pitfalls to avoid. Some of the topics covered will be:
- Working with table objects
- Why the macro recorder fails with tables
- Parts of a table
- Table structure properties
- Creating and naming a table
- Adding multiple rows or columns
- Looping through rows and columns
- Custom table procedures
Using tables with VBA can be confusing at first, especially since it doesn’t show up with the macro recorder
A related video of mine can be seen at Experts Exchange covering tables, PivotTables, slicers and timelines, as well as some of their upcoming Micro Tutorials.