Uploaded July 2026 | Updated September 2026, 2 weeks ago

---

👩🏻‍🎓Do you want to learn Pro-Level Excel techniques or Power BI?
Check out our amazing course at accessanalytic.thinkific.com

Original Video: youtu.be/3n6gGox4pSk&list=PLlHDyf8d156Xnoph4CbOiMrqQKiJZ8mhn

Excel File:
aasolutions.sharepoint.com/sites/PubliclyAvailableContent/Public%20Files/Forms/AllItems.aspx?id=%2Fsites%2FPubliclyAvailableContent%2FPublic%20Files%2FYouTube%20Content%2F2026%2007%20Dynamic%20Contents%20Page&p=true&ga=1



🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join

📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/


The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/


00:00 Introduction
00:25 The Dynamic Contents Page Problem
00:52 Why the Formula Wasn't Fully Dynamic
01:36 Reuben's Solution Explained
02:25 Testing the Dynamic Hyperlink Fix
02:41 Customising Hyperlink Formatting
03:25 Adding a Visual Arrow Icon
04:15 Fully Dynamic and No More Copying Formulas
04:32 Why Creative Excel Problem Solving Is So Much Fun