In this Microsoft Excel video tutorial, I explain how to create a LIVE stocks and shares tracker without an Excel 365 licence. This can be achieved by setting up a tracker in Google Sheets using the GOOGLEFINANCE function. The tracker in Google Sheets can be published to the web and then imported into Excel.

GOOGLEFINANCE Video Tutorial https://youtu.be/GpXAJF9Fx4Q

️Timestamps
00:00 Introduction
00:11 Create a free Google account
00:57 The GOOGLEFINANCE function
02:45 Publish Google Sheets tracker to the web
03:22 Import published data into Excel
04:26 Set up data refresh properties

#exceltips #exceltutorial #exceltricks