Consolidate and Hyperlink to Files on SharePoint
How to add a hyperlinks to allow you to instantly jump to your source files when consolidating from SharePoint.
Can be used in Excel and Power BI
00:00 Introduction
01:04 Navigating through SharePoint
04:12 Data extraction and consolidation
07:01 Creating hyperlinks in Excel
08:01 Implementing hyperlinks in Power BI
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/