Excel for Beginners #8 – How to Use Excel Tables (Step-by-Step Tutorial)

In this lesson, you’ll learn how to transform ordinary data into dynamic Excel Tables that automatically update, calculate, and format themselves — just like a professional dashboard. We’ll cover step by step how to: • Convert any range into an Excel Table using Ctrl + T • Rename and style your tables for clarity and consistency • Add Total Rows with built-in calculations • Use Structured References to create readable, self-updating formulas • Automatically expand tables as new data is added • Insert Slicers for easy, interactive filtering • Convert back to a normal range when needed By the end, you’ll understand why Excel Tables are the foundation for efficient data management, analysis, and reporting. Access the templates featured in The Excel Hub's video tutorials here: https://theexcelhub.myshopify.com/ Subscribe for weekly Excel tutorials, techniques and examples: https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation=1 Please share this video with others that may find it useful: https://youtu.be/wtSr9N2jF0M Please comment below if you have any feedback or any suggestions for videos you would like us to upload next! 🌍 The Excel Hub website: https://theexcelhub.com/ 📸 Instagram: https://www.instagram.com/theexcelhub/ ABOUT US: The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level. For any enquiries, please contact: [email protected] Overview: (0:00) Insert Table: (1:07) Rename Table: (1:43) Table Style: (2:00) Total Row: (2:15) Structured References: (3:00) Expand Table: (4:00) Slicers: (4:45) Convert Table To Range: (5:40)