Googledocsandsheets Course

Master Course in Google Docs & Sheets; free,cloud based alternative to Microsoft Office, Excel, & Word

Last updated 2022-01-10 | 4.1

- Utilize Google Docs & Sheets to their maximum potential
- to include project collaboration
- data sorting and interpretation
- and writing business proposals and documents.
- Create complex spreadsheets to effectively collect and interpret data within your organization.
- Create professional documents with Google Docs
- including Business Proposals and summaries.

What you'll learn

Utilize Google Docs & Sheets to their maximum potential
to include project collaboration
data sorting and interpretation
and writing business proposals and documents.
Create complex spreadsheets to effectively collect and interpret data within your organization.
Create professional documents with Google Docs
including Business Proposals and summaries.
Transition your business or non-profit into using Google Docs & Sheets smoothly
if you are new to G Suite.

* Requirements

* Students should have basic computer skills mastered
* Students should have access to a computer

Description

Master Google Docs & Sheets, as well as supplemental Apps in the G Suite including Google Drive and Slides, and learn to use these tools to improve your business, market yourself as a professional, and collaborate effectively on cloud based projects. 

Over 1000 students are enrolled in this course to date, highlighting the demand for excellence in the area of G Suite, Google Drive, and cloud based software and competition in general. With more companies headed to G Suite's solutions everyday, being an expert in these apps has become a necessity for professionals. Major corporations and even Universities have been making the transition from local network drives office software to Google Drive and the G Suite apps. This has driven the demand for extensive training on G Suite.

This course is designed to teach you to use Google Docs & Sheets as well as Google Drive to their maximum potential for personal use or for within your organization. We will cover the basics of constructing documents within each of the apps, and to do so we will be using mock Business Plans, P&L Statements, and Balance Sheets so that you can gain business application for each of these. Though, if you're just learning for personal use or school, these exercises will teach you to master the apps for whatever use you have as well. We will also learn to collaborate effectively within each app using the tools that Google provides us with. This is an excellent course for anyone from an individual just looking to become proficient, to the entrepreneur looking for more effective and efficient business solutions, to someone who works within a large organization that has moved to using Google Apps exclusively, as many have, and just needs to catch up. 

In this course, you will:

  • Learn to use Google Sheets as effectively as you use Microsoft Excel or other spreadsheet solutions
    • Master Formulas
    • Put together complex P&Ls, Balance Sheets, and other forms that you use Spreadsheet solutions for
    • Use Tables, Charts, Forms, and Sorting tools
    • Learn Spreadsheet Terminology & Shortcuts
    • Use Templates, Images, and Hyperlinks to polish your Spreadsheet Documents
    • Sort & Interpret Data Effectively
  • Learn to use Google Docs as effectively as you use Microsoft Word or other word processing software
    • Build professional documents using Google Docs, to include Business Proposals, Executive Summaries, and learn to locate thousands of templates on Docs to save yourself time, and make your Business stand out
    • Master the Formatting Tools of Google Docs
    • Use Images, Tables, and other Tools to Polish your Google Docs
  • Learn to use Google Docs & Sheets to collaborate effectively within your business or organization, as well as on external projects. 

Google Apps afford businesses a wide variety of resources that would otherwise be rather costly. Consider, for example, what you pay for office suite software on every company computer, and then the storage space you have to maintain on both local drives and servers. Google Apps provides a free, cloud based office suite, and up to 30GB of free storage per user. Storage can also be increased as needed at very affordable rates. As of this course posting, you can get an extra 100GB for $1.99 per month, a full TB for $9.99 per month, or you can switch to unlimited storage with G Suite for Business at $10/month per user.

Why wait? Enroll in this course risk free, and start to Master Docs & Sheets TODAY!

Who this course is for:

  • Anyone who needs to learn to use, and master Google Docs & Sheets
  • Entrepreneurs, small business owners, non-profit leaders
  • Business leaders considering a change to Docs & Sheets from Microsoft Office, Excel, and Word

Course content

11 sections • 55 lectures

Introduction to the Course Preview 03:41

Course overview

Getting started with Google Preview 04:43

This lecture walks you through the process of getting started with a Google Account. If you already have one, or are familiar with it, feel free to move on to the next lecture. 

Starting a new Google Doc Preview 01:28

Naming & Filing Google Docs Preview 02:58

Google Doc Navigation Preview 07:20

Text Formatting Preview 07:52

Working with Font Styles Preview 04:25

Demonstrating Page Breaks Preview 03:50

Adding lines, footnotes, & links Preview 02:32

Page numbering, headers, & footers Preview 04:28

Table of Contents Preview 05:39

Page View Settings Preview 06:03

Inserting & modifying images Preview 05:47

Image adjustments and placement Preview 07:32

Copying Google Docs/Working with Drafts Preview 03:59

Deleting and restoring a doc Preview 02:47

Download options with Docs Preview 07:12

Using revision history Preview 03:33

Including add-ons in a doc Preview 05:17

Publishing to the internet Preview 03:32

Emailing and Printing your Google Doc Preview 04:35

Sharing docs and editing a doc simultaneously with collaborators Preview 09:41

Using Google Drive to share Docs. Preview 02:39

Using comments to collaborate Preview 02:16

Polishing with the Tools Menu Preview 02:39

Getting to Google Sheets Preview 02:27

Naming & Filing your Sheet Preview 01:56

Spreadsheet terms to know Preview 03:24

Google Sheet Navigation Preview 08:00

Adding, Formatting, and Editing cell content Preview 01:48

Page Setup, text formatting, and merging cells Preview 04:26

Inserting, moving, clearing, & deleting rows or columns Preview 03:25

Working with multiple sheets in a Google Sheet file Preview 03:28

Shortcuts Preview 03:38

Using series of numbers or dates Preview 02:34

More with editing and formatting (exercise) Preview 13:28

Using templates, images, and hyperlinks Preview 04:37

Using View Options Preview 04:51

Using Conditional Formatting Preview 04:14

Sorting data with Sheets Preview 04:17

Using the Quick Sum tool Preview 08:03

Using Formulas and Functions Preview 07:42

Advanced Formulas & Functions Preview 06:24

Creating Charts Preview 06:11

Using filters and creating filter views Preview 02:43

Copying Google Sheets/Working with Drafts Preview 02:29

Deleting and restoring a Sheet Preview 01:17

Import/Export options with Sheets Preview 02:50

Using revision history Preview 02:58

Including add-ons in a sheet Preview 07:22

Publishing to the internet Preview 05:34

Emailing and Printing your Google Sheet Preview 06:29

Sharing Sheets and editing a file simultaneously with collaborators Preview 06:12

Using Forms Preview 05:20