HYPERLINK function is used to access information quickly from another file or a web page. The link can be a text or a picture based.
HYPERLINK (link_location, [friendly_name])
link_location – Required. The location of file or page to be opened.
[friendly_name] – Optional. The name or text to display in a cell against the link_location. In case, if it is omitted, Excel will show link_location as the friendly_name.
For more detailed information on the function, visit Microsoft Official Excel website.