Google Sheets & Forms - Beginner to Expert
4.3 (3 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.
473 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Google Sheets & Forms - Beginner to Expert to your Wishlist.

Add to Wishlist

Google Sheets & Forms - Beginner to Expert

The most complete Google Sheets and Forms course from a best selling instructor. No prior knowledge required.
4.3 (3 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.
473 students enrolled
Created by Joe Buchmann
Last updated 9/2017
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Be able to create, edit, and share spreadsheets quickly and efficiently
  • Understand and add charts to spreadsheets
  • Understand how to work with and filter data
  • Gain a basic understanding of formulas and how to apply them
  • Create forms and surveys
  • Collect and analyze data from forms and surveys
View Curriculum
Requirements
  • Basic familiarity with Google is helpful, but not necessary
  • Basic understanding of spreadsheet functionality is helpful, but not necessary
Description

Google Sheets and Forms are two incredibly powerful office apps that Google provides for free! 

This course will show you how to use Google Sheets to create incredibly powerful and complex spreadsheets, while being able to easily share and collaborate with others all over the world. Make your data stand out with beautiful charts and graphs, and save time with built-in formulas and conditional formatting. 

Learn how to effortlessly collect and organize information with Google Forms. Manage event registrations, quickly take polls, collect email addresses, and more!

Get started now and learn how to use these two tools together and do some amazing things!

Who is the target audience?
  • Business professionals with a desire to increase efficiency and accessibility
  • High school and college students
  • People looking to transition from Microsoft to Google products
  • Anyone who uses office productivity software
Students Who Viewed This Course Also Viewed
Curriculum For This Course
22 Lectures
03:12:23
+
Introduction
2 Lectures 08:41

A short introduction to the course from Joe Buchmann.

Preview 01:36

In this lesson we will be talking about the benefits of using Google's office apps.

Including:

  • No software
  • Platform independent
  • Auto saves
  • Revision history
  • Sharing and collaboration
  • Paperless
Preview 07:05
+
Google Sheets
11 Lectures 01:46:24

A short introduction to Google Sheets from Joe Buchmann.

Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and simultaneously work with other people.

Here are a few things you can do with Google Sheets:

  • Import and convert files to a Google spreadsheet
  • Export to various file formats
  • Use formula editing to perform calculations on your data
  • Use formatting make your sheets look the way you want them to
  • Chat in real time with others who are editing your spreadsheet
  • Create charts with your data
Preview 01:20

In this lesson we'll learn how to create new sheets and get them set up. 

Things we'll cover include:

  • Create new sheets
  • Import and convert
  • Sharing
  • Page setup
  • Preferences
  • Document history
Preview 03:21

Now that we know how to create and set up a sheet, we'll learn how to edit it. 

We'll talk about:

  • Paint format
  • Text styles
  • Font styles
  • Alignment and spacing 
  • Lists and indentation
  • Links
Editing the Spreadsheet
20:45

Commenting can be a powerful tool for collaboration. In this section we'll talk about how comments work in Sheets.

We'll take a look at:

  • Adding, editing and viewing comments
  • Sending comments to specific people
  • Replying to comments
  • Closing and re-opening comments
  • Managing comment notifications
Using Comments
04:40

In this lesson we'll talk about how to format your sheet for printing, as well as how to download to various formats. 

Printing and Downloading
04:46

The ability to filter data in Sheets is a very powerful tool for being able to analyze data in various formats. We'll talk about the differences between filters and filter views, as well as how to use both of them. 

By the end of this lesson you will be able to set up filters, filter views, and share filter views to specific people.

Filtering Data
11:55

Charts are an important part of Sheets that allow you to visually depict your data in an appealing way. In this lesson we'll talk about how to insert a chart, as well as make quick and advanced edits. 

By the end of this lesson, you will be able to insert and edit charts. 

Preview 14:02

In this lesson we'll take a look at some of the common chart types. This includes:

  • Bar charts
  • Scatter plot
  • Pie charts

By the end of this lesson, you will understand how to create and manipulate each of these chart types. 

Chart Types: Bar, Scatter and Pie
10:06

Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. These formulas can be used to create functions that manipulate data and calculate strings and numbers.

In this lesson we'll cover:

  • Auto functions
  • Creating formulas
  • Selecting and editing ranges
  • Nested functions
  • Formula highlighting
  • The formula bar

By the end of this lesson you will understand how formulas work, as well as how to apply them to your data. 

Formulas
13:21

In this lesson we'll take a look at some of the ways we can work with data in Sheets. 

We'll talk about:

  • Splitting data into columns
  • Adding and editing named ranges
  • Protecting sheets and ranges
Preview 15:31

Now that we know how to set up, edit, and manipulate our sheets, it's time to take a look at some tips and advanced items. 

We'll take a look at:

  • Adding images
  • Updating Excel spreadsheets with a Chrome extension
  • Emailing copies as attachments
  • Using add-ons
  • Finding and applying templates
Sheets Tips, Add-Ons and Templates
06:37

Google Sheets Section Quiz
10 questions
+
Google Forms
8 Lectures 01:16:39

A short intro to Google Forms from Joe Buchmann.

Google Forms is an easy to use tool for creating web forms, surveys, or online tests. Anyone can create a web form and tie it to a spreadsheet, without having to know any programming. 

As will other Google apps, you can also collaborate with multiple people on a form at the same time.

Here are a few things you can do with Google Forms:

  • Manage event registrations
  • Create an opinion poll
  • Collect email addresses for a newsletter
  • Create a pop quiz
Preview 01:30

In this lesson we'll talk about how to create a form and start setting it up.

We'll cover the following items:

  • Creating a new form
  • Adding a description
  • Form settings
  • Color and themes

By the end of this lesson you will know how to start a new form, and get it set up how you want.

Preview 12:21

Now that we can set up a form, we need to add some questions. 

In this lesson we'll cover:

  • Adding titles
  • Adding images and videos
  • Changing the order of elements
  • Adding new questions
  • Types of questions

By the end of this lesson you will have an understanding of the various types of questions available in Forms, as well as how to use them in your form.

Add and Edit Questions
18:47

With Google Forms, you can make sure that respondents fill out answers according to rules that you set. For example, you can tell Google Forms to accept only email addresses in a short answer question

In this lesson we'll cover the following validation topics:

  • Validation settings
  • Text validation
  • Checkbox validation

By the end of this lesson you will understand how validation works, as well as be able to add questions to your form to be validated.

Validate Answers
06:02

You can divide your form into sections to control how respondents interact with the form. This allows you to do things such as send users to different sections based on their answers. For example, you can send users who answer "Yes" to a question to page three of your form while sending users who answer "No" to page four.

In this lesson we'll see how to add sections and control responses.

Add Sections
07:13

There are a few ways to send your form to people to start filling it out. In this lesson we'll take a look at those, as well as how to collect responses.

We'll cover the following items:

  • Ways to share the form
  • Pre-populating form answers
  • The responses tab
  • Spreadsheet responses
  • Pausing responses
  • Response options

By the end of this lesson you will understand where responses go, how to view them, and how to control where they go.

Sharing the Form and Collecting Responses
14:47

In this lesson we'll take a look at how to install and use add-ons. We'll also learn how to use one of my favorite add-ons, Form Publisher.

Add-Ons
14:14

Google Forms Section Quiz
10 questions

Google forms allows you to let people upload files when responding to your form. We'll see how to do that in this video.

This video is also available on YouTube: https://youtu.be/FGhvycPp0_o

Preview 01:45
+
What Now?
1 Lecture 00:39

A short thank you video from Joe Buchmann

Wrapping it all Up
00:39
About the Instructor
Joe Buchmann
4.5 Average rating
229 Reviews
5,839 Students
5 Courses
Professional Designer and CX Manager

I have been in the world of design, digital media, and marketing for many years now. Throughout this time, I've honed my skills and become very passionate about what I do. I have taught many things over the years on an individual basis, or in small groups. Becoming an instructor online opens the door for me to be able to share my skills with a much larger group of people.

I believe in giving people the best experience possible. This applies not only to the businesses I have worked for, but also in teaching. To do that, I rely on feedback from you, the student. I love to hear what people think about the things I teach, and suggestions on how I can do it better. So feel free to leave comments, or reach out to me and let me know your thoughts or questions.

Here's some of the boring stuff about my history:

Starting at a young age, I dabbled in digital art and created very complex images with the Paintbrush program on Windows. Yes...pixel by pixel. This was well before I knew that Photoshop existed. Even at that time, though, Photoshop was in it's infancy. Over time, I discovered new and exciting ways to express digital creativity. This included 3D modelling and video production. When I was 22, I chose to pursue a college education and further expand my skills.

I obtained an AA in Multimedia, and BA in Video Game Design and Production. I did a bit of freelancing in various multimedia areas. This included producing 3D models and graphics for companies, designing video game characters, designing and building websites, designing logos and business identity, and various other opportunities.

In my career, I've been a Software Interface Designer, Sr. Web Designer, Marketing Manager, Website Supervisor, and most recently CX Manager. Not only have I expanded my creative knowledge, but I am a bit of a tech junkie as well. I love using new technology and digital tools to improve productivity and efficiency. That sounds nerdy, but hey...that's me!

A bit of personal stuff:

Originally from Washington state, I now live in Northern California with my wife and four kids. I've been here for over a decade, and am thinking of ways to migrate back towards home. Online teaching is my first step in making that happen. Feel free to ask me if there's anything you would like to know more about.

Thank you for your interest in my courses. Happy learning!