Google Sheets - beginner intermediate training
4.5 (12 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,218 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Google Sheets - beginner intermediate training to your Wishlist.

Add to Wishlist

Google Sheets - beginner intermediate training

Learn Google Sheets in under an hour with 3 case studies.
4.5 (12 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,218 students enrolled
Created by Radu Popa
Last updated 1/2015
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use Google Sheets for every day tasks
View Curriculum
Requirements
  • If you have worked with MS Excel it is a plus, some things might be easier
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.

Who is the target audience?
  • This course is for people that are still getting started with Google Sheets / Apps
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction
1 Lecture 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 :).

Preview 02:18
+
Case study 1: conference participants
4 Lectures 13:48

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
Preview 01:04

Cover the basics in building simple tables:

  • Basic formatting
  • Conditional formatting
  • Filters
  • Frozen panes
Formatting and filters
05:40

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

Data validation
02:53

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
Sharing and collaboration
04:11
+
Case study 2: company CRM
6 Lectures 22:27

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.

Preview 02:55

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.

Notes and comments
04:06

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.

The pivot table concept
02:54

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

Pivot table
04:39

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

Preview 06:06

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.

Managing revisions
01:47
+
Case study 3: inventory management
6 Lectures 14:52

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.

Preview 00:57

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.

VLOOKUP
04:03

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/

Import Range
02:56

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

SUMIF
02:35

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.

Protect sheet
01:58

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

Tracking changes
02:23
+
Closing
1 Lecture 00:47
Google Sheets Quizz
12 questions

Closing
00:47
About the Instructor
Radu Popa
3.6 Average rating
89 Reviews
3,357 Students
3 Courses
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.