Google Apps For Everyone

Creating Your First Google Doc Preview 01:23

Fonts, Sizes and Colors (oh my!) Preview 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.

Bold, Underline, Spacing, Justify, and Clearing the formatting Preview 02:30

A quick tour of some basic design functions.

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

Inserting An Image Preview 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)

  

Inserting a Link Preview 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.

Headers and Footers Preview 01:55

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

Tables - Two Ways to Use Them Preview 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.

Sharing and collaboration Preview 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.

Downloading a Copy of Your File in Microsoft Word Preview 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.

Uploading and Converting a Document Preview 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.

Revision History - Always Saving, all the time. Preview 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 Preview 08:09

Google Docs Quiz

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

Intro and formatting your data Preview 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.

Creating Charts Preview 05:03

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

The Power of Conditional Formatting Preview 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.

Validating Your Data Preview 04:55

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

Notifications Preview 01:47

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

Protecting a row, column or sheet Preview 03:46

Sorting Your Data Preview 03:48

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

Creating and Saving Data Filters Preview 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.

The Big Freeze Preview 03:29

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

Functions and Names Ranges Preview 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.

Google Spreadsheets Quiz

A review of your spreadsheet knowledge.

Your First Form Preview 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.

Long Answer Questions Preview 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.

Multiple Choice Questions Preview 02:57

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

Check Box Questions Preview 03:26

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

Drop down Question Preview 02:11

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

Inserting an Image into Your Form Preview 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.

Inserting a Video Preview 02:02

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

Pages and Sections Preview 03:16

Dividing your forms with pages and section headers.

Options After Your Form is Submitted Preview 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.

Scale and Grid Questions Preview 04:23

The last two question types: scale and grid questions.

Data Validation Preview 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

Intro and themes Preview 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 Preview 03:03

Transitions and Animations Preview 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.

Importing Slides Preview 02:35

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

Exporting Your Presentation Preview 01:38

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

Options for Showing Your Presentation Preview 02:18

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

Presentation Summary Preview 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

Intro and Your First Text Box Preview 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.

Word Art in Google Drawings Preview 02:26

Lets add some simple word art to our drawing.

Lines, Curves, and Scribbles Preview 05:33

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

Adding Shapes Preview 03:00

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

Arranging Images in Your Drawings Preview 04:04

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

Exporting the Drawing Preview 01:18

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

Google Drawing Summary Quiz

Upload, Convert, and Sharing Something You Have Previously Created Preview 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.

Instant Feedback Quiz / Flash Cards Preview 07:24

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

Self Grading Quiz Preview 06:27

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

Branch Logic Preview 03:32

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

Summary Preview 00:47

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