Excel's Hidden Secrets: Mastering Tables
If you use Excel for lists of data, you need to know about Excel tables.
In this step-by-step Excel training (see chapter links below):
• Learn the tips to format Excel data for sorting and filtering
• Find out how to create a table in Excel
• Look at the benefits of Excel tables vs. a data list
• Explore the steps for formatting Excel tables
• Learn how to work with the Total row in a table
⌚VIDEO CHAPTERS (timestamps):
0:00 Introduction
0:12 Organizing Excel Data for Sorting & Filtering
1:34 3 Ways to Create an Excel Table
4:00 Benefits of a Table vs a Data List
5:20 Changing Table Size & Dimensions
6:05 Table Range Names
6:48 AutoFilter in Tables
8:13 Formatting an Excel Table
8:55 Working with the Total Row
10:50 Wrap-Up / Closing
🎬LINKS to mentioned or related videos:
• Working with Excel Range Names: • Excel Range Names: The Ultimate Guide
• Adding Freeze Panes to an Excel Worksheet: • Maximize Excel Productivity: Freeze Panes ...
• Playlist with all my videos on Microsoft Excel: • How to Use Excel; Microsoft Excel Tips & T...
✅MORE Excel Tips & Tricks:
Discover more Microsoft Excel lessons and download a free Excel keyboard shortcuts handout at https://TheSoftwarePro.com/Excel.
Be More Productive with Software!
#ExcelTips #Productivity #Excel
📩NEWSLETTER:
How much time are you wasting trying to get the answers you need for your Microsoft applications? Let's change that! For more time-saving tips for Excel and other top software apps, join our free software tips newsletter at https://TheSoftwarePro.com/Tips AND get access to valuable keyboard shortcuts handouts.
🔽CONNECT WITH ME:
• Web site: https://TheSoftwarePro.com
• LinkedIn: / dawnbjork
• Facebook: / thesoftwarepro
• Instagram: / thesoftwarepro
🔔SUBSCRIBE TO THIS CHANNEL ON YOUTUBE:
https://www.youtube.com/thesoftwarepr...
🙌🏻SUPPORT THIS CHANNEL:
Hit the THANKS button in any video!