Learn Google Sheets interactively using openly shared data!
- 40%
Original price was: $24.99.$14.99Current price is: $14.99.
Disclosure
What you will study
-
Use Google Spreadsheets at an intermediate/superior degree
-
Format information, create charts and tables
-
Quickly manipulate and clear information to uncover developments and talk actionable insights
-
Link information throughout a number of interdependent Google Sheets using ImportRange
-
Display inventory worth data and arrange a portfolio tracker
-
Much, way more (suppose useful ideas + shortcuts + finest practices)
Save time at your job and construct marketable expertise by mastering Google Sheets. This course takes you from newbie degree to intermediate/superior (suppose business analyst degree). You’ll discover ways to:
- Create, title, share sheets
- Format sheets, finest practices
- Conditional formatting
- Filter and type information
- Use TEXT features to wash/manipulate information
- CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE
- Use fundamental math features, together with
- SUM
- AVERAGE
- COUNT
- MIN
- MAX
- ROUND
- More superior math features
- SUMIFS
- COUNTIFS
- AVERAGEIFS
- Create and customise charts
- Pivot tables
- Lookups
- VLOOKUP, INDEX/MATCH
- Use logical features akin to IF, OR, AND
- Use INDIRECT and pair with INDEX/MATCH
- Link information collectively from a number of spreadsheets using IMPORTRANGE
This course gives you you the whole lot you should learn about Google Spreadsheets, an more and more necessary instrument and quickly rising within the enterprise sector.
Additionally, this course will offer you the instance sheets lined, so you’ll be able to comply with alongside! How enjoyable 🙂
Who this course is for:
- This course is for all ranges, I’ll cowl the entry degree stuff up entrance and progress down in issue, so those that are extra superior can skip to lectures of curiosity
- Anyone who’s being an analyst or just desires to enhance their talent with Google Sheets or Excel
10 reviews for Learn Google Sheets interactively using openly shared data!
Show all
Most Helpful
Highest Rating
Lowest Rating
Add a review
Learn Google Sheets interactively using openly shared data!
Original price was: $24.99.$14.99Current price is: $14.99.
Bruce Edgar –
I really found this course useful for two reasons:
I’m working on a dashboard for work, and you solved most of my questions in the first 3 sections.
Playing with my data is great fun, you’ve given me a new toolset to play with.
Thanks
Vanessa M –
I like how the instructor gives me the data to follow along with! Thanks!!
Christina Hugh –
Course covers a ton, will be a great reference and help get me as proficient at Google Sheets as I am at MS Excel (intermediate/advanced). (my company is transitioning to Google products for the office)
David Edwards –
Good course for people just getting started with Google Sheets as well as a few advanced tips. Personally was hoping for more advanced linking sheets + app scripts, but still a good one.
Bency Kurian –
Since the course is for “All-Level” the explanation should be simpler. The intonation is very monotone.
Benjamin Hare –
Content is good. Erik covers the basics efficiently using high quality screen recordings. We see what he’s doing and listen to his explanation as he’s manipulating the software. By working along with him on your own data (or that erik has kindly provided) I’m learning Google Sheets program very quickly.
Desiree Fuller –
I have only watched one lecture so far, but it has helped me so much already! I am really excited to continue this course in the areas I need help. I would definitely recommend this course. I didn’t think I was a beginner, but I guess I am. Cant wait to learn more!!!
David Lewis –
Great course, gave me a great starting point to start producing some complex reports for work.
Bill Hengen –
This is a really good introduction to google sheets. Covers all of the basic stuff to get you up and running… Well done!
John Cousins –
Helpful and mostly clear. The examples to work with were helpful. I think more written materials and data examples that better show the utility of each function would help make this better.