Explore

The Complete Google Sheets Course: Beginner to Advanced!

8 hours on-demand video

$ 23.99

Save Course

Go to Course

Brief Introduction

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

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

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!

Requirements

A computer, a Google account, and the ability to navigate the internet
Know how to use a keyboard!

Recommended for you

Ultimate Web Designer & Web Developer Course for 2021

Become a Full-Stack Web Designer - Learn Everything from Web Design Fundamentals to Front-End Web Development NEW: COURSE IS BEING UPDATED FOR 2021! Join now to get access!...

Save Course

Full Stack Web Developer Bootcamp

Learn HTML 5, CSS 3, Javascript, Bootstrap 4, Media Queries, PHP, OOP, MYSQL, Database. Become a Full Stack Developer!   This course offers the following programs...

Save Course

Python : Programming / Script / OOP / Advanced for Projects

Python for Projects Script Advanced Python Object Oriented Programming OOP Python Automation Beginner Projects in Python Why learn Python Why take this course...

Save Course