Google Apps for Everyone

A hands on look at using Google Apps for Business and Google Apps for Education .
3.9 (32 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.
4,132 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 54
  • Length 3.5 hours
  • Skill Level All Levels
  • 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 5/2014 English

Course Description

Google Apps are ushering in a whole new era of word processing, spreadsheets, and presentations. Business, colleges, and K-12 schools have begun using this suite of products instead of Microsoft Office. Don't get left behind.

  • What are Google Docs?
  • Why should I use them if I already use Microsoft Office?
  • Can I do things I can't do with Office?

We'll answer these questions and much more in this unique, detailed course offering dedicated to Google Apps for Business and Google Apps for Education. This is the only course on Udemy that takes an in depth look at the following Google Apps:

  • Google Docs
  • Google Drive
  • Google Spreadsheets
  • Google Forms
  • Google Presentations
  • Google Drawings

The lessons walk you through setting up your account, creating your first Google Doc, sharing your docs with colleagues to collaborate with you, designing forms to collect data, and much, much more. Students can expect to walk away with the ability to switch to Google Apps for their day to day computing needs.

From creating your first document and inviting collaborators to work with you to designing forms to gather and display data. Whether you are a beginner or an expert, you will learn something from this course!

What are the requirements?

  • A computer and Internet Access.
  • A Google / Gmail Account is required, but we'll cover how to make on in this series.

What am I going to get from this course?

  • In this course, you'll learn every aspect of the Google Docs suite of applications.
  • In this course, you will lean how to create and share Google Docs, Spreadsheets, Form and Slides through the Google Apps for Business / Education platform.
  • In this course, you'll learn how to invite colleagues, peers, and anyone else to view, edit, or comment on your document.
  • In this course, you will learn advanced techniques in Google Spreadsheets and Forms
  • In this course, you will learn how to upload and convert a traditional file to a Google Doc.

What is the target audience?

  • This course is intended for anyone who is looking for a better way to work.
  • This course is designed for any level of user, from beginner to advanced, and everything in between.

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: Google Drive
00:42

A quick intro to this extensive course.

02:19

In order to access all that Google has to offer, you'll need a Gmail account. If you do not already have one, use this guide to create one. If you do have one, you can skip to lesson three.

07:57

This lecture is all about getting to know Google Drive. We'll look at how to log in and navigate the Google Drive interface. Even if you have used Google Drive in the past, this lesson is worth a listen.

Section 2: Google Docs
Creating Your First Google Doc
01:23
02:54

A tutorial on how to change the font, add additional fonts, change size, text color and highlights. While these all seems like pretty common tasks, its still helpful to review them. Adding additional fonts is one of those often overlooked features that can really enhance your document.

02:30

A quick tour of some basic design functions.

  • How to bold, underline, and italicize.
  • Set the spacing
  • Justify
  • Clear all your formatting.
03:13

This lesson looks at the various ways to insert an image in your Google docs. We will look at

  • Uploading an image from your computer
  • Taking a Screenshot
  • Pointing to a URL with your image
  • Using Google's built in search function (shown below)

01:46

Google has some helpful functions that make inserting a link easier. Look at the image below. See how Google searches based on what you highlighted to add a link to? Lets take a look how to insert a link to a web page into your document.

01:55

Adding header, footers, and page numbers to your Google Doc.

05:54

This lesson looks at using tables both in the traditional sense (like a mini spreadsheet) as well as the non traditional use in formatting the look and feel of your doc.

06:19

Sharing a document is one of the key features in the Google App suite. Let's look at how to share a document with a colleague, friend, or anyone with an email account. In this lesson, we will explore the various sharing options within each Google Document.

  • Public on the Web
  • Anyone with the Link
  • Specific People

We will also review how to give someone rights to view, comment, or edit a document.

01:46

Sometimes, you need a word processor with more features than what Google can offer. Here's how you can download a copy in a Microsoft Office format.

05:06

We'll look at how to upload and convert a Word document, Excel spreadsheet or Adobe PDF into a Google Doc. We will look at the settings associated with the conversion process as well as how to setup Google to ask you what you want to do with each file.

02:36

Google keeps a revision history of all the changes you or other make to a document. Lets look at how to view those revisions and restore them if you so desire.

Making it in Google
08:09
10 questions

This quiz will review the information we have learned about creating Google Documents.

Section 3: Google Spreadsheets
04:11

In our opening spreadsheet lecture, we'll create our first spreadsheet and look at how to format your data as currency, date, time, etc.

05:03

In this lesson, we'll turn our data into an interactive, eye catching chart.

07:28

Conditional formatting is defined as formatting of data on reports or computer programs that changes based upon specific criteria. We'll look at Google Sheets can offer us in the area of conditional formatting.

04:55

We look at using data validation to prevent unwanted entries into your spreadsheet.

01:47

Data changed? Get an email. New person filled out your form? Get an Email.

Protecting a row, column or sheet
03:46
03:48

This lesson focuses on sorting one or more columns of data using the data sorting features in Google Spreadsheets.

05:07

This lecture describes how to use data filtering to only show subsets of the main data. For example, only show me sales in the month of July.

03:29

Locking rows or columns so you can scroll through the data easily.

07:59

We'll explore the vast amount of predefined functions available to us in Google Sheets include sum, average, left, right and named ranges.

10 questions

A review of your spreadsheet knowledge.

Section 4: Google Forms
04:32

Google forms allow you to collect information from people through a variety of different question types. Google forms can be used to create simple questionnaires and quizzes, but more advanced forms can be used to gather data based on a person's responses. Once the data is collected, you'll have the ability to view and display the responses quickly and easily. Let's create our first Google Form.

03:03

In this lesson, we'll add a second question that allows the user to provide a longer answer than the last lecture. We'll also look at how to edit a question or delete a question.

02:57

This lecture covers adding a multiple choice question to your Google Form.

03:26

This lesson covers adding a fourth question type: Check Box questions.

02:11

How and where you would want to add a drop down question onto your form.

03:03

Quite often, you want to add an image into your form for various reasons. This lecture covers how to add a image onto your form and how to edit it to look the way you would like.

02:02

Similar to adding an image, you can also insert videos into your forms. Lets look at how to do that.

03:16

Dividing your forms with pages and section headers.

08:12

After a person completes your form, there are quite a few things that can be done. We'll look at progress bars, adjusting the message that is displayed, showing the survey results to those who took it, and allowing users to edit their responses.

04:23

The last two question types: scale and grid questions.

04:15

In this session, we'll look at how to control the data being entered into your form using data validation.

Google Forms Summary Quiz
10 questions
Section 5: Google Presentations
02:54

In this lesson, we'll create a new presentation. Once done, we'll give it a title and choose a theme. From there, we'll look at how to modify the theme design to meet our needs.

Adding Slides
03:03
05:20

This lecture covers how to assign special effect transitions to a slide or slides. We will also look at adding animations to text or images on individual slides.

02:35

Google presentations allows you to import slides from existing presentations both in your Google Drive or on your computers hard drive.

01:38

Here's how you can export the presentation for use in Microsoft Powerpoint.

02:18

This lessons looks at the options available to you when its time to present your information.

01:12

Just a quick recap here of the features associated with Google Presentations and the Google Apps suite in general.

Google Presentations Summary Quiz
6 questions
Section 6: Google Drawings
01:46

In this lecture we'll create a Google drawing. From there, we'll look at adding text via a text box and the options associated with it.

02:26

Lets add some simple word art to our drawing.

05:33

We continue on the insert menu with a look at how to insert lines, scribbles, curves, and polylines.

03:00

Google Drawings includes many predefined shapes. We'll add those into our drawing and adjust them accordingly.

04:04

Using the arrange menu to move things in front of or behind other objects.

01:18

Savings your document for use in a Google Document, Presentation, website, or any other application.

Google Drawing Summary Quiz
7 questions
Section 7: Bringing it All Together
02:32

In this lesson, we'll upload a document that was originally created in Microsoft Word and convert it to a Google Doc. From there, we'll use the sharing feature to invite a few collegues to edit the newly created document.

07:24

Using Google Forms to create a instant feedback quiz or flash cards.

06:27

Using Google Forms, Spreadsheets, and conditional formatting to create self grading quizzes.

03:32

Another example of how to direct the questions a person sees based on previous answers.

00:47

Wrapping up. Please PLEASE PLEASE review this course. I am always looking to improve the course so any feedback is thoughtfully reviewed.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mike Daugherty, Accomplished Entrepreneur and IT Director

At age 35, Mr. Daugherty is a married father of two wonderful children. In his professional life, he has successfully formed and sold two technology companies. While he has a talent for Information Technology, his passion is education and helping schools succeed. He has spent much of his professional career mastering the art of personal productivity and how to make the most of the time you are given on this earth.

In his current role as Director of IT for a high performing school district in Ohio, he has successfully implemented a 1:1 computing initiative with Google Chromebooks. The staff and student collaborate using Google Apps for Education. As the program expands into additional grade levels, Mr. Daugherty is responsible for providing training to the staff on how to Google's suite of products to create, share, and collaborate with colleagues and students alike. He is currently working to complete his certified Google Apps Educator coursework.

Ready to start learning?
Take This Course