Home » Blog » The Complete Google Sheets Course: Beginner to Advanced!

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.

What you’ll 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.

Requirements

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

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:

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

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!

See more Google Sheets courses here

See also...

Tableau 2020 A-Z - Hands-On Tableau Training for Data Science online course for health economists

Tableau 2020 A-Z: Hands-On Tableau Training For Data Science!

Learn Tableau 2020 for data science step by step. Real-life data analytics exercises & quizzes ... Read more

How to Write a Resume (Project-Centered Course) Online Course for health economists

How to Write a Resume

Online Course. Looking for a job? Create an eye-catching resume with this project course. Let ... Read more

Beginners to Expert Excel and Excel VBA 38 Hours Mega Online Course for health economists

Beginners to Expert Excel and Excel VBA – 38 Hours Mega Course

Online Course. Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with ... Read more

Why health economists should learn R to improve their career prospects?

Should You Be Learning R?

We reviewed the 100 health economics jobs on EuropeanHealthEconomics.com. It’s clear that R is becoming ... Read more

Microsoft Excel Advanced Excel Formulas and Functions online course for health economists

Microsoft Excel – Advanced Excel Formulas & Functions

Online Course. Master 75+ Excel formulas with hands-on demos from a best-selling Microsoft Excel instructor. ... Read more

R Tidyverse Reporting and Analytics for Excel Users online course for health economists

R Reporting and Analytics for Excel Users

Online Course. From Excel To Big Data and Interactive Dashboard Visualizations in 5 Hours. What ... Read more

Categories

Tags