Google Workspace Productivity Bundle

Master Google Workspace Tools to boost productivity, streamline collaboration, and optimize workflow across teams.

What you'll learn

Access Google Sheets through various methods and familiarize yourself with the interface.

Insert links, images, checkboxes, notes, and comments.

Utilize Google Drawings to embed drawings and videos effectively.

Enhance sheets with data validations and dropdowns.

Apply basic formulas and functions to perform calculations and explore the versatile Query function for advanced data analysis

Share and collaborate on sheets seamlessly with other users and download, print, and publish your Google Sheets files.

Apply Gmail settings that increase day-to-day ease of use.

Practice smart email habits that filter and label incoming and outgoing emails.

Personalize messages with signatures and templates.

Use built-in Gmail features to increase productivity and ultimately reduce the number of messages in the inbox.

Navigate Google Drive's interface with ease for efficient file access.

Enable and manage offline access to ensure continuous workflow.

Integrate and operate Microsoft Office files within Google Drive.

Share files securely with appropriate permissions.

Manage Priority Drive and Shared Drives for optimal collaboration.

Edit Google Docs with built-in formatting tools and features.

Insert and customize images, tables, charts, and videos.

Use productivity and project management features built into Google Docs to streamline day-to-day workflow.

Use collaboration features to work efficiently with others.

Edit Google Slides with built-in formatting tools and features.

Create a presentation and present with Google Slides.

Use collaboration features to work efficiently with others.

Apply Google Calendar settings that increase day-to-day ease of use.

Use built-in Google Calendar event features to efficiently organize, collaborate, and communicate with others.

Use Google Calendar’s Appointment Schedule.

Requirements

A Google account to access the Google Workspace applications is beneficial to follow along.

This course is suitable for complete beginners, no prior knowledge is required.

Description

**This bundle includes practice exercises, downloadable files, and LIFETIME access**This amazing-value six-course bundle gets you full access to courses on Google Workspace services you need to improve your productivity, help you work efficiently, and get organized.Get started with Google Sheets, the popular online spreadsheet application. It's like using Excel, only better. Then explore Google Docs and Google Slides, Google's version of Microsoft Word and PowerPoint.Discover a variety of Gmail tips and tricks for all learners - beginners or pros, and let Google Drive’s built-in features help you declutter and organize your file storage. Finally, learn to manage your schedule and boost productivity with Google Calendar's essential tools and features.There are no prerequisites to these courses besides a Google account to access the applications taught in this bundle and an eagerness to learn.What's included?Google SheetsAccess Google Sheets through various methods and familiarize yourself with the interface.Manage cells, rows, and columns, employing group and merge functions.Master keyboard shortcuts for both PC and Mac users.Apply themes, formatting, and conditional formatting techniques.Insert links, images, checkboxes, notes, and comments.Utilize Google Drawings to embed drawings and videos effectively.Enhance sheets with data validations and dropdowns.Apply basic formulas and functions to perform calculations and explore the versatile Query function for advanced data analysisIncorporate charts and graphs, exploring various available types.Share and collaborate on sheets seamlessly with other users and download, print, and publish your Google Sheets files.GmailApply Gmail settings that increase day-to-day ease of use.Practice smart email habits that filter and label incoming and outgoing emails.Use archiving and tagging functions to organize stored messages.Personalize messages with signatures and templates.Use Gmail’s companion apps, Google’s Chat and Spaces.Use built-in Gmail features to increase productivity and ultimately reduce the number of messages in the inbox.Google DriveNavigate Google Drive's interface with ease for efficient file access.Adjust Google Drive display settings to suit personal preferences.Enable and manage offline access to ensure continuous workflow.Integrate and operate Microsoft Office files within Google Drive.Apply secret naming tricks to simplify file identification.Utilize organization tips to declutter and categorize files.Perform advanced searches to locate specific files quickly.Share files securely with appropriate permissions.Manage Priority Drive and Shared Drives for optimal collaboration.Google DocsNavigate the Google Docs interface.Edit Google Docs with built-in formatting tools and features.Insert and customize images, tables, charts, and videos.Use productivity and project management features built into Google Docs to streamline day-to-day workflow.Use collaboration features to work efficiently with others.Google SlidesEdit Google Slides with built-in formatting tools and features.Create a presentation and present with Google Slides.Use collaboration features to work efficiently with others.Google CalendarApply Google Calendar settings that increase day-to-day ease of use.Use built-in Google Calendar event features to efficiently organize, collaborate, and communicate with others.Use Google Calendar’s Appointment Schedule.This course bundle includes:8+ hours of video tutorials100+ individual video lecturesCourse and exercise files to follow alongCertificate of completion

Overview

Section 1: Google Sheets: Introduction

Lecture 1 Course Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Files

Lecture 4 DOWNLOAD ME: Exercise Files

Lecture 5 Accessing Google Sheets

Lecture 6 It's Just Google

Section 2: Google Sheets: Start It

Lecture 7 Orientation

Lecture 8 Cells

Lecture 9 Rows & Columns - Part 1

Lecture 10 Rows & Columns - Part 2

Lecture 11 Theme

Lecture 12 Formatting - Part 1

Lecture 13 Formatting - Part 2

Lecture 14 Exercise 01

Section 3: Google Sheets: Insert It

Lecture 15 Insert Links

Lecture 16 Insert Images

Lecture 17 Insert Drawings

Lecture 18 Insert Checkboxes

Lecture 19 Insert Notes & Comments

Lecture 20 Exercise 02

Section 4: Google Sheets: Organize It

Lecture 21 Data Cleanup

Lecture 22 Conditional Formatting: Part 1

Lecture 23 Conditional Formatting: Part 2

Lecture 24 Drop-down in Cells

Lecture 25 Data Validation

Lecture 26 Exercise 03

Section 5: Google Sheets: Work with It

Lecture 27 Sort & Filter

Lecture 28 Basic Formulas

Lecture 29 Basic Functions

Lecture 30 Query Function

Lecture 31 Multiple Sheets

Lecture 32 Exercise 04

Section 6: Google Sheets: Graph It

Lecture 33 Types of Charts & Graphs

Lecture 34 Edit & Customize Charts: Part 1

Lecture 35 Edit & Customize Charts: Part 2

Lecture 36 Exercise 05

Section 7: Google Sheets: Share It

Lecture 37 Share & Collaborate: Part 1

Lecture 38 Share & Collaborate: Part 2

Lecture 39 Download, Print or Publish

Lecture 40 Exercise 06

Section 8: Google Sheets: Closing

Lecture 41 Course Wrap Up

Section 9: Gmail: Introduction

Lecture 42 Introduction to Gmail

Section 10: Gmail: Gmail Settings

Lecture 43 Undo Send and Hover Actions

Lecture 44 Archive, Not Delete

Lecture 45 Nudges and Smart Features

Lecture 46 Stars and Indicators

Lecture 47 Signature and Vacation Responder

Lecture 48 Inbox Types

Lecture 49 Exercise 01

Section 11: Gmail: Getting Organized

Lecture 50 Labels

Lecture 51 Filters

Lecture 52 Templates

Lecture 53 Search

Lecture 54 Chat

Lecture 55 Spaces

Lecture 56 Side Panel

Lecture 57 Exercise 02

Section 12: Gmail: Closing

Lecture 58 Course Wrap Up

Section 13: Google Drive: Introduction

Lecture 59 Introduction to Google Drive

Section 14: Google Drive: Getting Started

Lecture 60 Getting There from Anywhere

Lecture 61 Navigation Menu

Lecture 62 Display and Details

Lecture 63 Drive View

Lecture 64 Settings and Offline Access

Lecture 65 New Button

Lecture 66 Microsoft Office Files

Lecture 67 Exercise 01

Section 15: Google Drive: Organize & Share

Lecture 68 Naming Tricks

Lecture 69 Organization Tips Part 1

Lecture 70 Organization Tips Part 2

Lecture 71 Search

Lecture 72 Share

Lecture 73 Exercise 02

Section 16: Google Drive: Workspace Users

Lecture 74 Priority Drive

Lecture 75 Shared Drives

Lecture 76 Exercise 03

Section 17: Google Drive: Closing

Lecture 77 Course Wrap Up

Section 18: Google Docs: Introduction

Lecture 78 Introduction to Google Docs

Section 19: Google Docs: Getting Started

Lecture 79 Navigating Docs

Lecture 80 Text Formatting with Styles

Lecture 81 Fan-Favorite Formatting Tools

Lecture 82 Advanced Formatting Tools

Lecture 83 Images

Lecture 84 Tables and Charts

Lecture 85 Drawings and Videos

Lecture 86 Productivity and Project Management Features

Lecture 87 Tools and Extensions

Lecture 88 Collaboration

Lecture 89 Exercise 1

Section 20: Google Docs: Closing

Lecture 90 Course Wrap Up

Section 21: Google Slides: Introduction

Lecture 91 Introduction to Google Slides

Section 22: Google Slides: Getting Started

Lecture 92 Getting Started

Lecture 93 View Options

Lecture 94 Editing Slides: Part 1

Lecture 95 Editing Slides: Part 2

Lecture 96 Theme Builder: Part 1

Lecture 97 Theme Builder: Part 2

Lecture 98 Collaboration

Lecture 99 Motions

Lecture 100 Present

Lecture 101 Exercise 1

Section 23: Google Slides: Closing

Lecture 102 Course Wrap Up

Section 24: Google Calendar: Introduction

Lecture 103 Introduction to Google Calendar

Section 25: Google Calendar: Getting Started

Lecture 104 Settings

Lecture 105 Creating Event: Part 1

Lecture 106 Creating Event: Part 2

Lecture 107 Appointment Schedules

Lecture 108 Exercise 01

Section 26: Google Calendar: Closing

Lecture 109 Course Wrap Up

Those who are brand new to Google Workspace and want to learn more.,Those who want to use a web-based spreadsheet, word processor, and presentation application as an alternative to Microsoft Excel, Word, and PowerPoint.,Anyone who uses Gmail, Google Calendar, or Google Drive and wants to maximize their productivity and manage their emails, schedule, and files better.,Those looking for a cloud storage solution.