The Complete Google Sheets Course: Beginner to Advanced! (Udemy.com)
A crash course in basic to advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too!
Created by: Evan Ramsey
Last updated July 2024
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!
How it compares
Against the other 459 rated Udemy courses in Office Productivity on CourseDuck:
- Rating4.7 out of 5higher than 90% of them
- Reviews14,616#12 of 460 by number of reviews
- Length8.1 hourslonger than 74% of them
- Last updatedJuly 2024earlier than 66% of them
Course Description
In this course you will learn the fundamentals of Google Sheets (some of which translates to Microsoft 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 AVERAGE
Shortcuts like filling formulas across THOUSANDS of cells
Advanced charts & Beautiful Visualizations
PIVOT TABLES - though I don't particularly like them...
Advanced functions like INDEX MATCH MATCH and IMPORT RANGE
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!
There are some updates to Google Sheets like Tables and others. We may be adding more content to the course to address these - stay tuned!
Instructor Details
- 4.7 Rating
14,616 Reviews
Evan Ramsey
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've realized how useful spreadsheets are in my professional and personal life, and how much I enjoyed teaching my coworkers and friends about them. I've coached top minds in the ways of Google sheets and Excel, and decided I wanted to share the most important aspects of these tools with you.
I know spreadsheets have a reputation for being boring or difficult to use, but I wanted 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.
More Office Productivity courses
AI-Powered Social Media Management: From Beginner to Pro (2025)
5.0 (211 Reviews)
Provider: Udemy
Time: 1.1h
$19.99
Microsoft Excel + AI: Go From Data Analysis to Visualization (2026)
4.9 (276 Reviews)
Provider: Udemy
Time: 3.8h
$10.99
Complete Introduction to Google Sheets Pivot Tables (2026)
4.8 (3,570 Reviews)
Provider: Udemy
Time: 2.9h
$64.99
Microsoft Excel - Managing Personal Finances with Excel (2024)
4.8 (810 Reviews)
Provider: Udemy
Time: 3h
$19.99
Reviews
By Susan Wothaya Mwangi on 7/6/2026
the courese was a good match for me. It was easy to follow, and i learned practical google sheets skills such as formulas,sorting,filtering and organisationing data.the lessons were clear,and i feel more confident using spreadsheets for work related tasks.thank you.
By Tarannum Chhapra on 6/19/2026
Great course with practical, job-relevant content. I learned several advanced Google Sheets techniques that I was able to apply immediately in my work. The lessons were clear, engaging, and easy to follow. Highly recommended for anyone looking to improve their data management and productivity skills.
By Arihant sancheti on 6/2/2026
It was very amazing at starting i thought the course is very simple but accordingly i was going on it was hard but by paying attention i have finishes it properly thank you for the formulas and everything i wasn't knowing anything of google sheets now i know everything about it .
By LuckyStreak Employee on 4/22/2026
Great course that covers basics and enters into more complex usage of Google Sheets. Information is not outdated for 2026 as well practical part is made on a high level.
By Hannah Müller on 3/26/2026
I was kind of a full beginner concerning google sheets. So this course definitely made me learn how to use google sheets in the basic ways and i got very excited about all the possibilities with functions and what is possible. I just cannot say I can do all of these clever things yet. I need a lot more practice... anyways thank you for this great course and the way you explain things!!!
By Clare Corrigan on 3/5/2026
I am really enjoying this spreadsheets course! I just finished section two and I've already learned so much and am stoked for section 3. It's crazy how I never knew I would be interested in spreadsheets but he keeps it interesting and makes it easy going step by step with examples and activities so you can follow along. I highly recommend this course! Thank you!
By Susan Meda on 2/6/2026
Too fast for beginners
By Alina Chmura on 1/12/2026
i love it the guy is reallly great the only thing is hes going so fast i have to pause the video like a lot in order to keep up maybe im just slow tho
By Judith Oilonye Ujah on 12/2/2025
Its Been very educative and i can relate to section one of this course, because i use spread sheet for my monthly retirement and consumables inventory.
By Devanshu Jain on 11/23/2025
This course surely justifies its name "Beginner to Advanced". Honestly speaking if one practice intensely on the lessons taught in this course, he is already a Pro than most of the people out there. The value delivered in this courses is truly commendable. Love and respect from INDIA.
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!
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 94 / 100






