Google 2 In 1 Quick Starter: Looker Studio And Google Sheets

Published 11/2023
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 474.95 MB | Duration: 1h 10m

Learn Google Sheets and Looker Studio to track stock investments

What you’ll learn
Learn enough to track anything within Google Sheets
Understand the use of GOOGLEFINANCE function within Google Sheets
Create dropdown pick lists within Google Sheets for column data entry
Be able to create a interactive dashboard in Looker Studio using Google Sheets as the source of data
Be able to track stock investments

Requirements
No experience needed. You will need a Google Account for which I will show you how to get one. Also, its free to acquire and use Google Sheets and Looker Studio

Description
Either you are new to Google Sheets and/or Google Looker Studio you will learn to create a simple interactive dashboard in Looker Studio. We will use the Google Sheet as the data source in this crash course.What you will learn can be applied to many situations.I will use the case of multiple investments in the stock market within multiple accounts, e.g. personal investment account and retirement account. You will learn how to use the google finance function in google sheets to get current information on a held position.This powerful crash course will help you create a consolidated view. Having a single view of your investments can simplify the ongoing management of your financial assets.After learning this course you could test your investment strategy over time. You could even have a challenge with another person to see who’s investment strategy is performing better without any real money or getting an account at a financial institution. Below is what you will learn in each Google Sheets and Looker StudioSheetsGOOGLEFINANCE function and useBuild dropdown picklists for columnsCreate multiple columns to track the investmentsLooker StudioUse that google sheet as the data sourceLearn about metrics and dimensionsDiscuss data typesCreate an interactive dashboard that will contain a table, graphs, scorecard & dropdown controlUnderstand 3 levels of filtersDefine conditional formatting on a tableOther useful tips

Overview
Section 1: Introduction

Lecture 1 Introduction

Section 2: Google Sheets

Lecture 2 Google Finance in Google Sheets

Lecture 3 Google Sheets: building more columns and calculated columns

Lecture 4 Google Sheets: building pick lists for columns dropdowns

Lecture 5 Google Sheets: inserting more rows, sorting, and named range.

Section 3: Looker Studio

Lecture 6 What is Looker Studio Getting into Looker Studio

Lecture 7 Learning about Data Types and correcting them

Lecture 8 Building your first charts

Lecture 9 Change the look of the charts