Google 2 in 1 Quick Starter: Looker Studio and Google Sheets

Focused View

Albert Schlein

1:09:49

22 View

1 - Introduction

1 - Introduction.mp4

02:18

2 - Google Sheets

2 - Google Finance in Google Sheets.mp4

06:07

3 - Google Sheets building more columns and calculated columns.mp4

02:20

4 - Google Sheets building pick lists for columns dropdowns.mp4

10:46

5 - Google Sheets inserting more rows sorting and named range.mp4

07:30

3 - Looker Studio

6 - What is Looker Studio Getting into Looker Studio.mp4

04:47

7 - Learning about Data Types and correcting them.mp4

10:50

8 - Building your first charts.mp4

09:05

9 - Change the look of the charts.mp4

07:12

10 - Creating filters and dropdown control.mp4

06:53

4 - Course Review

11 - Course Review.mp4

02:01

Description

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

Who is this for?

Anyone who wants to learn Google Sheets and Looker Studio

What You Need to Know?

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

More details

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 Studio
Sheets
GOOGLEFINANCE function and use
Build dropdown picklists for columns
Create multiple columns to track the investments
Looker Studio
Use that google sheet as the data source
Learn about metrics and dimensions
Discuss data types
Create an interactive dashboard that will contain a table, graphs, scorecard & dropdown control
Understand 3 levels of filters
Define conditional formatting on a table
Other useful tips
Who this course is for:
Anyone who wants to learn Google Sheets and Looker Studio

User Reviews

Rating

average 0

Total votes0

Focused display

Your instructor Al, is a successful international Business Intelligence consultant with decades of BI and end user training experience specialize in automation between applications. He resides in the US and worked in South Korea, Hong Kong, Singapore, Mexico City and Amsterdam in the past. He enjoys teaching people tips and tricks to solve complex tasks. He is passionate to take any process to make it easier by using software applications. Throughout his career, he led many projects with IT including transformative process improvement projects.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.