What it does: The Hyperlink() function links the cell to a local location (another point in the spreadsheet, another tab, specific cell, etc..) or to an actual URL like Google.com.

Plain English: This function can be used to link to a very specific points in OTHER workbooks, the workbook you’re currently in, or most commonly to a live URL.

Arguments: HYPERLINK(link,[name])

• Link – The link you want to visit (local or world wide web URL)
• Name – Optional – How you want the link to appear in the cell. Example: Google