Uploaded July 2026 | Updated November 2026, 10 hours ago
👩🏻🎓Do you want to learn Power BI or Pro-Level Excel techniques?
Check out our amazing course at accessanalytic.thinkific.com
Download the workbook here:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/IgDOqQS-ziQGRIi0ULJYCMDJAQG3qkdDAzJEmmJ7ha8S8KQ?e=nQ5W3n
Video on setting up default settings such as styles:
youtu.be/PlitF5GgQ2o?si=tF71qdPeNcewX_Pq
🫶🏻 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:50 Setting Up the Start and End Sheets
01:11 Creating the Sheet Name and Home Button Formula
04:45 Building the Dynamic Sheet List with TOCOL
06:37 Creating Clickable Hyperlinks to Each Sheet
10:05 Grouping Helper Columns and Final Notes
👩🏻🎓Do you want to learn Power BI or Pro-Level Excel techniques?
Check out our amazing course at accessanalytic.thinkific.com
Download the workbook here:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/IgDOqQS-ziQGRIi0ULJYCMDJAQG3qkdDAzJEmmJ7ha8S8KQ?e=nQ5W3n
Video on setting up default settings such as styles:
youtu.be/PlitF5GgQ2o?si=tF71qdPeNcewX_Pq
🫶🏻 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:50 Setting Up the Start and End Sheets
01:11 Creating the Sheet Name and Home Button Formula
04:45 Building the Dynamic Sheet List with TOCOL
06:37 Creating Clickable Hyperlinks to Each Sheet
10:05 Grouping Helper Columns and Final Notes










