In this Microsoft Excel video tutorial I explain how to create hyperlinks to files and folders in Microsoft Excel. The tutorial features the HYPERLINK function and Power Query. Power Query can be used to list all the files and sub-folders within a folder.
Table of Contents:
00:00 - Introduction
00:21 - Link to a specific folder
00:57 - Link to specific file (Excel, Word pdf etc)
01:24 - Link to a specific sheet in an Excel workbook
02:15 - Link to a particular cell in another Excel workbook
03:52 - Link to a particular place in a Word document
05:00 - Create links to all files in a folder and its subfolders using Power Query and the HYPERLINK function
08:26 - Create links to all subfolders within a folder using Power Query and the HYPERLINK function
------------------------