Google Sheets Complete Tutorial: Gain Beginner-Intermediate Level Skills in 45 Minutes | T Square
Two primary sections of the video provides in-depth details of:
Section (I) Why Leverage This Powerful Tool?
Section (II) How To Use It Covers:
o 1. REVIEW KEY FUNCTIONALITIES OF THE GOOGLE SHEETS APP
o 2. CREATE SPREADSHEETS
o 3. EXTRACT THE DATA FROM MS EXCEL .XLSX FORMAT & COPY/PASTE THAT INTO THE GOOGLE SHEETS TO RECREATE SOME OF THE ANALYSIS DONE IN EXCEL
o 4.LINK MULTIPLE SHEETS THROUGH FORMULAS
o 5.DATA FORMATTING
o CREATE PIVOT TABLE AND CHART
• Bonus Section: How to leverage Google Sheets to create Stocks Tracker Real-Time
Financial Formulas of the Stocks Tracker Real-Time:
1) Stock Price Calculation (Real-Time)
=GOOGLEFINANCE("AAPL")
2) Historical Chart
=SPARKLINE(GOOGLEFINANCE("AAPL","PRICE",TODAY()-365,TODAY(),"DAILY"),{"CHARTTYPE","LINE";"LINEWIDTH",1;"COLOR","#5f88cc"})
Google Docs Video Link:
• Google Docs Tutorial for Beginners | T Square