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
- Formula Auto Update – 00:11
- Calculated column auto copy – 01:11
- Name the Table – 02:14
- Table based formula – 02:42
- Auto Copy Formatting – 03:50
- Auto Copy Validations – 04:21
- Dynamic CountIf – 05:58
- Better Vlookup formulas – 06:51
- Avoid duplicates in lookup tables – 07:34
- Creating tables precisely – 07:58
- Select Table Column precisely – 09:14
- Easy selection with Ctrl A – 10:02
- Easy Navigation – 10:27
- No more Freeze Pane – 10:50
- Structured formulas – 11:12
- Slicers – 11:50
- Use Tables for Power Query Import – 12:19
- LisObject in VBA – 12:51
- Best Practice – 13:32
2 Responses
Dear sir, You covered all aspects of Table in a easily followable narration. Very easy follow for beginners too.
Thanks for the feedback.
You may also like these Word related videos:
Word top 10 settings – https://youtu.be/_8r7vNrqh34
Word Tables – 8 ways to create: https://youtu.be/X-G8bZVCGBk
Word Tables – 13 problems solved: https://youtu.be/y5IblpvN_Jg
Word Styles – https://youtu.be/7f_aOgsvKA0
Word Sections – https://www.youtube.com/playlist?list=PL-UPeBWRvha036g2sTc69H85sUd0pb4RY
Handing long, complex word documents – https://youtu.be/9jrYJHQ7YmQ
Thanks.
Dr. Nitin.