How to use Excel HYPERLINK Function

Hyperlink function helps you create a link
Syntax is =HYPERLINK (link_location, [friendly_name])
link_location - The path to the file or page to be opened.
friendly_name - [optional] The link text to display in a cell.
HYPERLINK function can be used to create links to workbook locations, pages on the internet, or to files on network servers.