Excel Tables

Purchase this course to access all lessons and start learning.

Getting started
Video Time
Save Video 1. What is an Excel Table Watched 3:08
Save Video 2. How to create an Excel Table Watched 3:08
Save Video 3. Anatomy of an Excel Table Watched 2:42
Save Video 4. How to remove an Excel Table Watched 3:08
Save Video 5. Excel Table Options Watched 4:06
Save Video 6. How to use Calculated Columns Watched 2:49
Working with tables
Video Time
Save Video 7. Working with table rows and columns Watched 3:28
Save Video 8. How Excel Table ranges work Watched 2:56
Save Video 9. How to use Table filters Watched 3:29
Save Video 10. How to sort an Excel Table Watched 3:19
Save Video 11. Shortcuts for Excel Tables Watched 3:17
Save Video 12. How to add a totals row to a Table Watched 2:44
Save Video 13. How to remove duplicates from a table Watched 2:54
Structured references
Video Time
Save Video 14. Introduction to structured references Watched 3:34
Save Video 15. Structured reference syntax examples Watched 3:33
Save Video 16. Structured references inside a table Watched 2:53
Save Video 17. Formulas to query a table Watched 3:49
Save Video 18. How to copy and lock structured references Watched 3:36
Table formula examples
Video Time
Save Video 19. How to use SUMIFS with an Excel Table Watched 3:35
Save Video 20. How to use VLOOKUP with a table Watched 3:46
Save Video 21. How to use INDEX and MATCH with a table Watched 3:20
Save Video 22. How to set up a running total in a table Watched 3:44
Save Video 23. Conditional formatting formula in a table Watched 3:09
Save Video 24. Data validation with an Excel table Watched 3:09
Save Video 25. How to use named ranges with tables Watched 2:38
Table Slicers
Video Time
Save Video 26. How to add a slicer to a table Watched 3:16
Save Video 27. How to use table slicer options Watched 3:06
Save Video 28. How to use table slicer styles Watched 2:53
Table styles
Video Time
Save Video 29. Introduction to table styles Watched 1:35
Save Video 30. How to apply a table style Watched 2:29
Save Video 31. How to create a new table style Watched 3:41
Save Video 32. How to copy a table style to another file Watched 2:26
Save Video 33. How to set a default custom table style Watched 3:29
Practical table examples
Video Time
Save Video 34. Why you should use a table for your pivot table Watched 3:14
Save Video 35. How to build a simple summary table Watched 3:01
Save Video 36. How to count items in a filtered list Watched 3:15