All about Excel Tables – 18 benefits

In this video, I’m going to show you 18 powerful ways to use Excel tables to save time and improve data accuracy. By using automatic formulas and auto update dependencies, you’ll be able to work with your data in a more efficient and accurate way!

Watch Video

Download sample file

Contents

1. Formula Auto Update – 00:11
2. Calculated column auto copy – 01:11
3. Name the Table – 02:14
4. Table based formula – 02:42
5. Auto Copy Formatting – 03:50
6. Auto Copy Validations – 04:21
7. Dynamic CountIf – 05:58
8. Better Vlookup formulas – 06:51
9. Avoid duplicates in lookup tables – 07:34
10. Creating tables precisely – 07:58
11. Select Table Column precisely – 09:14
12. Easy selection with Ctrl A – 10:02
13. Easy Navigation – 10:27
14. No more Freeze Pane – 10:50
15. Structured formulas – 11:12
16. Slicers – 11:50
17. Use Tables for Power Query Import – 12:19
18. LisObject in VBA – 12:51
19. Best Practice – 13:32