Google Sheets - beginner intermediate training

Learn Google Sheets in under an hour with 3 case studies.
4.3 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,205 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 18
  • Length 1 hour
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course Description

Getting you up to speed with Google Sheets

Many of us learned Excel a while ago, and we got really good at it. But because change is something we can rely on, we started to notice that there is this "thing" created by Google that tries to compete with Office (Hint: Google Apps).

If you are trying to make the swich from MS Excel to Google Sheets, or just want to get started then this course is for you.

Google Sheets in under an hour

What I try to do in under 1 hour is to get you up to speed with Google Sheets essentials. I am not covering every little button, I focused on the features you'll need the most. I take pride in making the course as short as possible.

What are the requirements?

  • If you have worked with MS Excel it is a plus, some things might be easier

What am I going to get from this course?

  • Use Google Sheets for every day tasks

What is the target audience?

  • This course is for people that are still getting started with Google Sheets / Apps

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:18

Hey, my name is Radu, welcome to my Google Sheets course, a course where you will learn how to use Google Drive by working on a few case studies.

Google Docs was a game changer when it was launched, no more email ping pong, but online collaboration, love it. With more and more companies that make the switch to Google mastering Google Sheets is a must have skill.

This course is built around 3 case studies. In the first one we talk about a conference and the information we collect in a spreadsheet about the participants. In the second one we will develop a custom CRM using Google sheets and in the third one we will go into inventory management.

One of my focuses was to keep the course as short as possible. This is why I did not explain every single little button in Google Sheets, I tried to move around and cover the most important aspects.

Let me introduce myself, my name is Radu, I work as a technical trainer in Romania. This is my 3rd course on Udemy and I am happy to have taught more than 1900bpeople through this platform so far. I am interested on finding ways in which technology can help us be more efficient in what we do, this is why I recorded this course.

I am not a native english speaker, but this is something you already noticed :).

Section 2: Case study 1: conference participants
01:04

In this first case study we will meet Jill, she is the company event manager and she is now organizing the company christmas party.

She wants to throw the best party ever, she is using Google Sheets to make a list of all the people that will be attending. Here is the info that she needs from all participants.

  • Name
  • Department
  • No. people coming
  • Party theme
    • Hawaiian
    • Romanian
    • Brazilian
  • Comments
05:40

Cover the basics in building simple tables:

  • Basic formatting
  • Conditional formatting
  • Filters
  • Frozen panes
02:53

Demonstrate the data validation options that can help us not to waste time on correcting data that was filled in randomly.

04:11

In this session I cover the most important sharing options:

  • Sharing a doc with a person: my boss for review
  • The difference between see, comment, edit
  • Sharing a doc with a secure link
  • Sharing a doc with a public link
  • Email the document as an attachment
  • Email collaborators
Section 3: Case study 2: company CRM
02:55

The previous example was very suitable for basic tasks like filters and formatting. We will continue with a second case study, this one about building a company CRM.

This time we will meet John, he is the sales manager in a company that is doing sales, obviously :). To make the flow of information smoother he decided to create a CRM, and because Google Sheets is highly collaborative, he said why not build one by myself.

04:06

It would be nice if I could have more information about client interactions. I could have a separate column to do this or I could use notes and comments. This session is about using these 2 features.

02:54

This session is for the people that are not familiar with pivot tables, if that is not the case for you, you can skip to the next session. Understanding a pivot for the first time takes a little time, is session is about understanding the mecanism that stands behind.

04:39

A session where I demonstrate how to use a Pivot Table to obtain a simple report.

06:06

In this session I create a column chart from scratch and go through all the customization options that we can find in Google Sheets.

01:47

We have developed a CRM, put a lot of information in it, what happens if someone deletes everything? that would not be very nici wouldn’t it. Maybe things don’t have to be that tragic, maybe it is only about someone deleting an email address of phone number.

The good news is that Google has revision history that protects us against that, this is what this session is about.

Section 4: Case study 3: inventory management
00:57

In the first case study we have seen how to manage a simple table and work with the basic features of Google Docs. In the second one we stepped things up and worked with data analysis features like pivot tables.

We continue the case studies with an example that will enable us to work with formulas. This time we will meet George who works as as handler in the warehouse. Some time ago he discovered Google Sheets and saw it as a great tool for inventory management.

04:03

The VLOOKUP function can be very usefull in helping us to bring together information from multiple sheets. In this session I demonstrate how it can be used.

02:56

The IMPORTRANGE function helps us import information from another sheet / workbook, you will see in this session how to use it.

You can read more about it here: http://www.freshcomputerskills.com/import-range-in-google-sheets/

02:35

Demo on how SUMIF can help us extract data from a table only when a certain condition is met.

01:58

I think the past session was the longest one yet, we put a lot of work into those and it would be ashame to see our work being ruined by a colleague that decides to write a number where we laid our formulas.

Fortunately Google Sheets has revision history, we have seen that in a previous session, so we can undo anything that may happen. That however is fixing instead of preventing, in this session we will see how we can prevent that using the protect sheets feature.

02:23

See how you can be kept up to date with the latest changes in a document using the activity feed and email notifications.

Section 5: Closing
Google Sheets Quizz
12 questions
Closing
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Radu Popa, Technical trainer

Hello, my name is Radu and I live in Romania. That's a country in Europe :) 

I own a training and recruitment company and I blogging and online training is one of my passions. 

Even though I graduated a computer science faculty some during the last study years I decided I don't want to be a software developer but rather work in Human Resources. 4 years of volunteering experience in AIESEC got me very interested in working with people and helping them grow.

So far I have worked in 4 very different companies, a small Dutch-Romanian IT company, a multinational manufacturing corporation, a Romanian HR Consultancy company and in a Swiss-Romanian consultancy company. Now I work in my own company.

Even though I have worked as a HR professional in all these places, my computer science background made me always look for ways in which technology can help me do my work in a more efficient, better and maybe even fun way.

Ready to start learning?
Take This Course