20+ reason to love Excel Tables | Excel Table Tricks you MUST know!

A comprehensive list discussing 21 reasons why every Excel user must love Excel tables.

To read these tricks in text please visit: http://pakaccountants.com/20-excel-ta...

Time stamps:
0:00 Intro
Trick # 1: 0:08 - Named Excel tables
Trick # 2: 1:03 - Resize easily
Trick # 3: 1:26 - Structured referencing system
Trick # 4: 4:33 - Calculated Columns
Trick # 5: 5:16 - Endless table styles
Trick # 6: 5:59 - Filter Independently from other data
Trick # 7: 7:08 - Dedicated row for formula
Trick # 8: 7:58 - Remove duplicates easily
Trick # 9: 9:00 - Show/hide header row
Trick # 10: 10:20 - Convert Excel table to normal/simple data range
Trick # 11: 10:49 - Super fast selection of data
Trick # 12: 12:06 - Table headers replace default column headers for better scroll experience
Trick # 13: 13:12 - Easily navigate and insert rows without disturbing other data
Trick # 14: 14:12 - Move data with ease
Trick # 15: 15:35 - Print specific table only
Trick # 16: 16:11 - Use Excel table as dynamic input data source
Trick # 17: 16:59 - Custom format first and last columns of Excel tables
Trick # 18: 17:48 - Create dynamic ranges using Excel tables
Trick # 19: 20:27 - Use Excel table tables as input data source for Excel Pivot tables
Trick # 20: 21:41 - Connect Excel tables with Power Query
Trick # 21: 22:19 - Ready made data input form for every Excel table

  / learnexceltoexcel  
  / exceltoexcel