4.7 out of 5
4.7
6515 reviews on Udemy

The Complete Google Sheets Course: Beginner to Advanced!

A crash course in basic and advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too!
Instructor:
Evan Ramsey
25,995 students enrolled
English [Auto] More
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!

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:

  1. Learn the basics like how to create a Google Account and a Google Spreadsheet

  2. Arithmetic Functions like SUM, COUNT, and AVERAGE

  3. Shortcuts like filling formulas across THOUSANDS of cells

  4. Advanced charts & Beautiful Visualizations

  5. PIVOT TABLES – though I don’t particularly like them…

  6. Advanced functions like INDEX MATCH MATCH and IMPORT RANGE

  7. QUERY, the function that DOES IT ALL!

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:

  • Lectures

  • Activities

  • Projects

  • Exercises

  • Slides

  • Comprehensive Workbooks WITH Answer Keys

  • Extra Learning Resources

If 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!

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.7
4.7 out of 5
6515 Ratings

Detailed Rating

Stars 5
3941
Stars 4
2041
Stars 3
441
Stars 2
57
Stars 1
35
23a5fe191e70fe7886487b78f4b01300
30-Day Money-Back Guarantee

Includes

8 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed