Tables are one of the most underused features in Excel. 10 Advantages of using Tables in Excel are explained in this video.
Intro (0:00)
1. Excel Tables are Easy to create (0:19)
2. Excel Tables are Easy to Select and Refer (2:20)
3. Excel Tables are Dynamic (3:35)
4. Excel Tables come with Slicers (7:28)
5. Excel Tables has Calculated Columns (9:44)
6. Excel Tables has Structured References (11:10)
7. Total Row that provide Column Aggregations (15:13)
8. Column Headers of the Excel Table always stay visible (16:45)
9. Excel Tables come with more than 50 predefined Table Styles (17:27)
10. Retrieve Data deleted using the in-built Userform of Excel (18:40)
Read about Excel Tables
https://xlncad.com/excel-table/
If you’ve found my videos helpful or enjoyable, consider supporting me with a coffee!
buymeacoffee.com/ajayanand
Top 25 Microsoft Word Tips and Tricks - https://youtu.be/l25Evu4ohKg
7 Most Important Tools in Excel - https://youtu.be/Pc88LGWNO70
Download my free eBook on Excel Macros - http://eepurl.com/gpT0RD
Check these Books on Excel - https://xlncad.com/excel-resources/
Read my articles on Excel - https://xlncad.com/
#exceltable #excelforbeginners #exceltutorial