Google Apps for Everyone
4.0 (36 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,141 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Google Apps for Everyone to your Wishlist.

Add to Wishlist

Google Apps for Everyone

A hands on look at using Google Apps for Business and Google Apps for Education .
4.0 (36 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,141 students enrolled
Created by Mike Daugherty
Last updated 5/2014
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • A computer and Internet Access.
  • A Google / Gmail Account is required, but we'll cover how to make on in this series.
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!

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
54 Lectures
03:21:11
+
Google Drive
3 Lectures 10:58

A quick intro to this extensive course.

Preview 00:42

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.

Creating Your Free Account
02:19

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.

Google Drive
07:57
+
Google Docs
12 Lectures 43:31
Creating Your First Google Doc
01:23

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.

Fonts, Sizes and Colors (oh my!)
02:54

A quick tour of some basic design functions.

  • How to bold, underline, and italicize.
  • Set the spacing
  • Justify
  • Clear all your formatting.
Bold, Underline, Spacing, Justify, and Clearing the formatting
02:30

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)

Inserting An Image
03:13

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.

Inserting a Link
01:46

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

Headers and Footers
01:55

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.

Tables - Two Ways to Use Them
05:54

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.

Sharing and collaboration
06:19

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.

Preview 01:46

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.

Uploading and Converting a Document
05:06

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.

Revision History - Always Saving, all the time.
02:36

Making it in Google
08:09

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

Google Docs Quiz
10 questions
+
Google Spreadsheets
10 Lectures 47:33

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

Intro and formatting your data
04:11

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

Preview 05:03

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.

The Power of Conditional Formatting
07:28

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

Validating Your Data
04:55

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

Notifications
01:47

Protecting a row, column or sheet
03:46

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

Sorting Your Data
03:48

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.

Creating and Saving Data Filters
05:07

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

The Big Freeze
03:29

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

Functions and Names Ranges
07:59

A review of your spreadsheet knowledge.

Google Spreadsheets Quiz
10 questions
+
Google Forms
11 Lectures 41:20

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.

Your First Form
04:32

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.

Long Answer Questions
03:03

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

Multiple Choice Questions
02:57

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

Check Box Questions
03:26

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

Drop down Question
02:11

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.

Inserting an Image into Your Form
03:03

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

Inserting a Video
02:02

Dividing your forms with pages and section headers.

Pages and Sections
03:16

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.

Options After Your Form is Submitted
08:12

The last two question types: scale and grid questions.

Scale and Grid Questions
04:23

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

Data Validation
04:15

Google Forms Summary Quiz
10 questions
+
Google Presentations
7 Lectures 19:00

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.

Intro and themes
02:54

Adding Slides
03:03

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.

Transitions and Animations
05:20

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

Preview 02:35

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

Exporting Your Presentation
01:38

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

Options for Showing Your Presentation
02:18

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

Presentation Summary
01:12

Google Presentations Summary Quiz
6 questions
+
Google Drawings
6 Lectures 18:07

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.

Intro and Your First Text Box
01:46

Lets add some simple word art to our drawing.

Word Art in Google Drawings
02:26

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

Lines, Curves, and Scribbles
05:33

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

Adding Shapes
03:00

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

Arranging Images in Your Drawings
04:04

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

Exporting the Drawing
01:18

Google Drawing Summary Quiz
7 questions
+
Bringing it All Together
5 Lectures 20:42

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.

Upload, Convert, and Sharing Something You Have Previously Created
02:32

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

Instant Feedback Quiz / Flash Cards
07:24

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

Self Grading Quiz
06:27

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

Branch Logic
03:32

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

Summary
00:47
About the Instructor
Mike Daugherty
3.9 Average rating
50 Reviews
4,544 Students
2 Courses
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.