Google Sheets - Analyst training with openly shared data! MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1.5 Hours | 453 MB
Genre: eLearning | Language: English
Learn to become a Google Sheets master. Data used is shared, you are encouraged to follow along!
Save time at your job and build marketable skills by mastering Google Sheets. This course takes you from beginner level to intermediate/advanced (think industry analyst level). You'll learn how to:
Create, name, share sheets
Format sheets, best practices
Conditional formatting
Filter and sort data
Use TEXT functions to clean/manipulate data
CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE
Use basic math functions, including
SUM
AVERAGE
COUNT
MIN
MAX
ROUND
More advanced math functions
SUMIFS
COUNTIFS
AVERAGEIFS
Create and customize charts
Pivot tables
Lookups
VLOOKUP, INDEX/MATCH
Use logical functions such as IF, OR, AND
Use INDIRECT and pair with INDEX/MATCH
Link data together from multiple spreadsheets using IMPORTRANGE
This course will give you you everything you need to know about Google Spreadsheets, an increasingly important tool and rapidly growing in the enterprise sector.
Additionally, this course will provide you with the example sheets covered, so you can follow along! How fun
Google Sheets - Analyst training with openly shared data!Title: Google Sheets Analyst Training with openly Shared Data
Size: 373.42 MB | Format: rar
Download:
- Code:
-
http://uploaded.net/file/uf1p31xt/hotfile-jypo9.G.S.A.t.w.o.s.d.rar
https://userscloud.com/zbmbjpxrxnch/hotfile-jypo9.G.S.A.t.w.o.s.d.rar
http://go4up.com/dl/ba471b00c09b
http://rapidgator.net/file/4eb0aadc2867a0b503af974940c690d3/hotfile-jypo9.G.S.A.t.w.o.s.d.rar.html