006: Excel Tables with Zack Barresse from ExcelTables

Listen on Web Browser >>

Zack Barresse is an Excel MVP since 2005 and is an expert on Excel Tables.

He is a full time Excel consultant and runs an Excel blog over at www.ExcelTables.com 

He has recently published the only in depth book relating to Excel Tables: A Complete Guide For Creating, Using and Automating Lists and Tables

You can subscribe to the show on iTunes to get automatic updates so you don’t miss out on these awesome interviews and Excel insights!

Zack´s new Excel book

• Excel Tables: A Complete Guide For Creating, Using and Automating Lists and Tables on Amazon
• Excel Tables: A Complete Guide For Creating, Using and Automating Lists and Tables eBook on the MrExcel store
• Excel Tables: A Complete Guide For Creating, Using and Automating Lists and Tables Print Edition on the MrExcel store
• Co Authored by:
  • Kevin Jones

Zack´s Excel Favorites

• Keyboard Shortcut:
  • CTRL+Z   (to Undo)
• Excel Tip: CTRL+ENTER to fill down formulas
• Function: INDEX
• Excel Add-In:
  • Asap-Utilities by Bastien Mensink
  • MZ Tools to make your programming life easier
  • Excel Utilities by Rob Bovey
• Online Learning Resource:
  • MrExcel Forum for all Excel questions & answers
  • VBA Express Forum for VBA questions & answers
  • Tech Support Guy for free computer help
  • Experts Exchange for solving technical problems
  • TheSpreadsheetGuru blog by Chris Macro
  • ExcelCampus blog by Jon Acampora
  • PeltierTech Charts & Programming blog by Jon Peltier
  • Contextures blog by Debra Dalglish
  • ExcelGuru blog by Ken Puls
  • ExcelIsFun YouTube channel by Mike Girvin
  • Charles Williams expert on Excel speed
• Excel Book:
  • Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA and .NET 
  • Bill Jelen’s books on Amazon, his ebooks and and Print Edition on the MrExcel store
  • Tracy Syrstad’s books which you can also find on Amazon 
  • Excel VBA 24-Hour Trainer by Tom Urtis

Interview Links

• Xtreme Pivot Table online course
• Excel Table blog tutorials on the MyExcelOnline Blog
• Dynamic Data Validation List tutorial
• Excel 2013 Templates created by Zack Barresse
• Structured Referencing explanation
• Tableau Business Intelligence & Analytics
• Excel 2010: The Missing Manual book
• MrExcel.com FORUM
• VBA Express Forum for VBA questions & answers
• The Spreadsheet at 25 book
• ExcelHero blog by Daniel Ferry
• MyOnlineTrainingHub blog by Mynda Treacy

Zack´s Products

• Excel Tables: A Complete Guide For Creating, Using and Automating Lists and Tables on Amazon, ebook and Print Edition on the MrExcel store
• Excel Tables website

Connect with Zack

• LinkedIn
• Website
• Twitter

Listen to the MyExcelOnline Podcast on your favorite platform!

Free Resources!

1. 1. Excel Tutorial Blog: Learn all the essential tips to get you up and running and using Excel to its full potential.  Choose from Formulas, Pivot Tables, Charts, Analysis, Shortcuts, Macros plus more >> CLICK HERE TO VIEW

 

1. Free Excel Webinars: Learn the power of Pivot Tables and Power Query with our free webinars.  CLICK HERE TO VIEW NOW

Thanks for Listening!

Thank you for joining me this week. If you have some feedback that you’d like to share, then please leave a note in the comment section below!

If you enjoyed this episode, please share it using the social media buttons you see at the bottom of the post.

Also, please leave an honest review for The MyExcelOnline Podcast on iTunes! Ratings and reviews are extremely helpful and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.

If you have any questions you can send me an email to [email protected]

Don’t forget to subscribe to the show on iTunes to get automatic updates so you don’t miss out on these awesome interviews and Excel insights!