The Complete Google Sheets Course: Beginner to Advanced! (Udemy.com)

A crash course in basic and advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too!

( 312 Reviews )

Created by: Evan Ramsey

Produced in 2021

What you will learn

Create beautiful spreadsheets with amazing formatting tricks
Learn to manipulate text in formulas
Connect multiple Google Sheets together using a single formula
Analyze data sets with ease using complex functions & formulas
Learn to build incredible data visualizations using charts
Feel completely comfortable in a spreadsheet environment
Learn formulas that work in both Google sheets & Excel!

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

Course Description

In this course you will learn the fundamentals of Google Sheets (much of which translates to MS Excel!). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like VLOOKUP, INDEX(MATCH()MATCH()), and IMPORTRANGE.
Never heard of those before? Don't worry! I start from the beginning - so those terms will become clear when the time is right. Along the way, you will develop an amazing spreadsheet toolkit. Wondering what tools will be in that toolkit? Check out the list below for some highlights of the course:
Learn the basics like how to create a Google Account and a Google Spreadsheet Arithmetic Functions like SUM, COUNT, and AVERAGEShortcuts like filling formulas across THOUSANDSof cellsAdvanced charts & Beautiful VisualizationsPIVOTTABLES - though Idon't particularly like them...
Advanced functions like INDEX MATCH MATCH and IMPORTRANGEQUERY, the function that DOESITALL! NOTE:
More lectures incoming on this one :) Ultimately, the point of this course is to get some awesome skills for professional or personal use. And - above all - have fun doing it!
My course isn't like a lot of other online Excel or Google Sheet courses. Most of these courses force you to watch them build things and hope that you understand what they are doing. Instead of that old model, I've incorporated everything I've learned from my experience in the real professional world to make this the best online Google sheets course. The course includes:
LecturesActivitiesProjectsExercisesSlidesComprehensive Workbooks WITH Answer KeysExtra Learning ResourcesIf you have any questions, please don't hesitate to contact me. Sign up today and see how fun, exciting, and rewarding web development can be!
Who this course is for:
Spreadsheet users of all levels, those who want to get better at analyzing data or building spreadsheets for personal use!
This course is not for you if you are an experienced data analyst or power spreadsheet user.
Students who want to start a career in management consulting or tech operations!

Time: 8h

Instructor Details

Evan Ramsey

4.5 Rating
312 Reviews

Hey! My name is Evan. I've worked in analytics and operations roles at several top tier Silicon Valley companies like LinkedIn and Udemy after earning a degree in Economics at Harvard.
Mastering spreadsheets has allowed me to accelerate my career and dramatically increase my efficiency. I'verealized how useful spreadsheets are in my professional and personal life, and how much Ienjoyed teaching my coworkers and friends about them. I've coached top minds in the ways of Google sheets and Excel, and decided Iwanted to share the most important aspects of these tools with you.
Iknow spreadsheets have a reputation for being boring or difficult to use, but Iwanted to teach the world that ANYONE can use a spreadsheet like a pro. Join me and enroll in my course to build an incredible spreadsheet skillset that will set you up for success, no matter what your passions are.

MS-700 Managing Microsoft Teams Training & Lab Simulations

MS-700 Managing Microsoft Teams Training & Lab Simulations (2021)
4.9 (52 Reviews)

- Provider: Udemy
- Time: 9.5h

$11.99

How to Create Animated Videos with Powerpoint

How to Create Animated Videos with Powerpoint (2021)
4.8 (312 Reviews)

- Provider: Udemy
- Time: 4.5h

$11.99

Microsoft PowerPoint From Beginner to Advanced

Microsoft PowerPoint From Beginner to Advanced (2019)
4.8 (312 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Productivity Hacks for Writers (Writing Mastery)

Productivity Hacks for Writers (Writing Mastery) (2021)
4.8 (311 Reviews)

- Provider: Udemy
- Time: 3h

$11.99

Powerpoint 2016 2019 - Master powerpoint presentation

Powerpoint 2016 2019 - Master powerpoint presentation (2021)
4.8 (300 Reviews)

- Provider: Udemy
- Time: 11h

$11.99

Master Microsoft Word Beginner to Advanced

Master Microsoft Word Beginner to Advanced (2019)
4.8 (288 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

All office productivity courses

Reviews

4.5

312 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Mae Dawson on 11/15/2020

Yes, I have been using Lotus and I could make it do everything. Now it doesn't like new computers. Your spreadsheets are more like what I was using than anything else and will probably be better. It is different enough that I need help. Thank you,
Mae

By Mary Craig on 11/8/2020

This is a very helpful course thank you!

By John Vincent Trinidad on 11/8/2020

Very useful, Straightforward and Easy to grasp

By Baha Karim on 11/8/2020

Its very crystal clear and easy to follow up

By Ingrid Henderson on 11/8/2020

Love the info, great pace and easy to comphrehend

By Mete Kaplan on 11/8/2020

I rarely rate courses. But this one, oh this one. One amazing course. Thank you for your efforts.

By Sarah Martin on 11/8/2020

Really intuitive; as I developed my spreadsheet skills in the workplace the course always had the next thing I needed to learn

By Mikdat Ycel on 10/26/2020

EXCELLENT

By Benoit DENIS on 10/22/2020

Perfect match for me!

By Savannah Palmer on 10/19/2020

It is pretty good so far.

By Shelley Burkard on 10/17/2020

I think it's super helpful and insightful, I feel like it could go a little slower. But this is also a crash course. He does a great job of keeping you engaged which is awesome.

By Jessica Jennings on 10/15/2020