Excel-Normal vs Structured Data Ranges

Описание: Excel Table vs Normal Data Range Secrets Exposed
In this video I show you how you can easily work with official excel tables by converting a normal range of cells into an excel table to harness on the powerful features of an excel table. I expose four major advantages of using an official excel table in excel instead of sticking to a normal data range and all these advantages of using an excel table are crucial for a daily excel user.
You can quickly jump to your desired secret by navigating the video using the following timestamps.
00:00 Secrets of Using Official Excel Tables Introduction
00:06 Dynamic Formula Updates in Excel Tables
00:17 How to use the COUNTA function in excel to count values
00:49 How to turn on and off the Total Row feature in excel tables
01:11 How to auto sum using the keyboard shortcut key Alt‪@EqauLs‬
01:15 Highlighting ROWS and COLUMNS in excel tables
01:37 Adding and updating data in excel tables