Fans of the channel know I’ve had a love / hate relationship with Excel tables over the years.  But, recently, I’ve come to love them.  Whether you’re starting out in Excel, or you’re an experienced pro, tables are the basic unit of currency for organizing data in Excel - and mastering them is key. 

WATCH THE VIDEO HERE

FREE DOWNLOAD: EXCEL CHEATSHEET (1 Page PDF) 

If you’re not using Excel tables, I recommend you start now.  In the video, I walk you through creating a table while pointing out the time-saving benefits of Excel tables.  Want to get professional formats quickly?  Use tables.  Want to work easily with a dataset where rows will be added / deleted? Use tables.  Want to quickly analyse data with Excel formulae?  Yes, use Excel tables! 

I also share the time-saving tips and tricks I’m using everyday in my Excel consulting work for working with Excel tables. 

But there’s more.  This video is not just about basic data organization in Excel, it’s about using Excel tables for Excel automation.  And Excel automation means 1000s of hours saved – it’s why our customer here at Tiger love working with us.  Most of the time! 

In the video, I show you how to apply Excel VBA to a table to automate time-consuming tasks.  We look at how to delete table rows, add a value to specific cell in a table, and how to delete all data in a table with Excel VBA.  And, don’t worry if you’ve never used Excel VBA before – I walk you through it from beginner level.  As usual, the Excel file is available for you to download and build your confidence in Excel automation. 

EXCEL DOWNLOAD FILE LINK HERE 

Finally, I show you how to automate a typical time-consuming task in Excel.  Suppose you had to change all rows in a dataset where a specific value appears.  You might say, ‘that’s not too bad, I could use filters!’  Well, wait until you see how easy it is with Excel VBA and Excel tables!  It’s literally ‘click-of-a-button’ stuff.  You won’t reach for filters again for this kind of Excel task … 

So, are you using Excel tables, and are you combining them with Excel VBA?  I would love to learn your impression of this video in the YouTube comments.  I will answer your queries there. 

FOLLOW UP VIDEOS

EXCEL VBA ABSOLUTE BEGINNER

EXCEL VBA LOOPS FOR BEGINNERS

26 EXCEL PRODUCTIVITY TIPS

HOW TO FORMAT AN EXCEL SPREADSHEET 

📹Edited by BUBI Productions