Excel Intermediate #13 - Stop Breaking Your Excel Models: Named Ranges & Structured References

In this video, you’ll learn how to stop breaking your Excel models by using two essential professional tools: 👉 Named Ranges 👉 Structured References in Excel Tables These features make your formulas: - Easier to read - Easier to maintain - Far harder to break when your spreadsheet changes If you’ve ever looked at a formula like =C2*C5 and had no idea what it actually represents, this lesson is for you. We’ll start by solving a common problem: formulas that technically work, but are unclear and fragile. You’ll see how named ranges turn numbers into meaningful inputs like tax rates, assumptions, and parameters, making your formulas read almost like plain English. Next, we’ll move on to structured references inside Excel tables. Instead of hard-coded ranges like =SUM(C11:C14), you’ll learn how to use table and column names so formulas automatically expand as your data grows. You’ll also learn how to: - Rename tables for clearer formulas - Use structured references that scale automatically - Manage and edit named ranges using the Name Manager 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/cLyC1boJD88 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) Named Ranges: (0:25) Structured References: (3:18)