The Google Workspace Productivity Bundle

Manage your emails with Gmail, organize your files with Google Drive, and get started with Google Sheets today!

What you'll learn

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

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

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

Undo send, hover actions, nudges, and smart features.

Navigate 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.

Perform advanced searches to locate specific files quickly.

Share files securely with appropriate permissions.

Manage Priority Drive and Shared Drives for optimal collaboration.

Different ways of accessing Google Sheets and getting familiar with the Google Sheets interface.

Working with cells, rows, and columns, including group and merge.

PC and Mac keyboard shortcuts.

How to apply themes, formatting, and conditional formatting.

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

Adding data validations and dropdown selections.

How to sort and filter data in Google Sheets and working with multiple sheets.

An overview of basic formulas and functions and how to use the Query function.

Creating charts and graphs, learning different chart types, editing, and customizing charts.

Sharing your sheet and collaborating with other users.

Requirements

A Google account to access Gmail, Google Drive, and Google Sheets is beneficial to follow along.

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

Description

**This bundle includes downloadable course instructor files and exercise files to work with and follow along with, plus LIFETIME access!This great-value three-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.Discover a variety of Gmail tips and tricks for all learners, beginners or pros. Let Google Drive’s built-in features help you declutter and organize your file storage. Finally, get started with Google Sheets, the popular online spreadsheet application. Think of it as using Excel, only better.There are no prerequisites to the courses besides a Google account to access the applications taught in this bundle and an eagerness to learn.What's included?Gmail Productivity Masterclass for Beginners and Pros:Apply Gmail settings that increase day-to-day ease of use.Practice smart email habits that filter and label incoming and outgoing emails.Use built-in Gmail features to increase productivity and ultimately reduce the number of emails in the inbox.An Introduction to Google Drive for Beginners:Navigate 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 Sheets Basics: An Introduction to Google Sheets:Different ways of accessing Google SheetsGetting familiar with the Google Sheets interfaceWorking with cells, rows, and columns, including group and mergePC and Mac keyboard shortcutsHow to apply themes, formatting, and conditional formattingInserting images, links, checkboxes, comments, and notesMaking use of Google Drawing to insert videos and drawingsAdding data validations and dropdown selectionsHow to sort and filter data in Google SheetsAn overview of basic formulas and functionsHow to use the Query functionWorking with multiple sheetsCreating charts and graphs and learning different chart typesEditing and customizing chartsSharing your sheet and collaborating with other usersPublishing, downloading, and printing Google Sheets filesThis course bundle includes:6+ hours of video tutorials70+ individual video lecturesCourse and exercise files to follow alongCertificate of completion

Overview

Section 1: Gmail: Introduction

Lecture 1 Introduction to Gmail

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

Lecture 3 Downloadable Course Transcript

Section 2: Gmail: Settings

Lecture 4 Undo Send and Hover Actions

Lecture 5 Archive, Not Delete

Lecture 6 Nudges and Smart Features

Lecture 7 Stars and Indicators

Lecture 8 Signature and Vacation Responder

Lecture 9 Inbox Types

Lecture 10 Exercise 01

Section 3: Gmail: Getting Organized

Lecture 11 Labels

Lecture 12 Filters

Lecture 13 Templates

Lecture 14 Search

Lecture 15 Chat

Lecture 16 Spaces

Lecture 17 Side Panel

Lecture 18 Exercise 02

Section 4: Gmail: Closing

Lecture 19 Course Wrap Up

Section 5: Google Drive: Introduction

Lecture 20 Introduction to Google Drive

Lecture 21 READ ME: Essential Information for a Successful Training Experience

Lecture 22 Downloadable Course Transcript

Section 6: Google Drive: Getting Started

Lecture 23 Getting There from Anywhere

Lecture 24 Navigation Menu

Lecture 25 Display and Details

Lecture 26 Drive View

Lecture 27 Settings and Offline Access

Lecture 28 New Button

Lecture 29 Microsoft Office Files

Lecture 30 Exercise 01

Section 7: Google Drive: Organize & Share

Lecture 31 Naming Tricks

Lecture 32 Organization Tips Part 1

Lecture 33 Organization Tips Part 2

Lecture 34 Search

Lecture 35 Share

Lecture 36 Exercise 02

Section 8: Google Drive: Workspace Users

Lecture 37 Priority Drive

Lecture 38 Shared Drives

Lecture 39 Exercise 03

Section 9: Google Drive: Closing

Lecture 40 Course Wrap Up

Section 10: Google Sheets: Introduction

Lecture 41 Course Introduction

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

Lecture 43 DOWNLOAD ME: Exercise Files

Lecture 44 DOWLOAD ME: Instructor Files

Lecture 45 Accessing Google Sheets

Lecture 46 It's Just Google

Section 11: Google Sheets: Start It

Lecture 47 Orientation

Lecture 48 Cells

Lecture 49 Rows & Columns - Part 1

Lecture 50 Rows & Columns - Part 2

Lecture 51 Theme

Lecture 52 Formatting - Part 1

Lecture 53 Formatting - Part 2

Lecture 54 Exercise 01

Section 12: Google Sheets: Insert It

Lecture 55 Insert Links

Lecture 56 Insert Images

Lecture 57 Insert Drawings

Lecture 58 Insert Checkboxes

Lecture 59 Insert Notes & Comments

Lecture 60 Exercise 02

Section 13: Google Sheets: Organize It

Lecture 61 Data Cleanup

Lecture 62 Conditional Formatting: Part 1

Lecture 63 Conditional Formatting: Part 2

Lecture 64 Drop-down in Cells

Lecture 65 Data Validation

Lecture 66 Exercise 03

Section 14: Google Sheets: Work with It

Lecture 67 Sort & Filter

Lecture 68 Basic Formulas

Lecture 69 Basic Functions

Lecture 70 Query Function

Lecture 71 Multiple Sheets

Lecture 72 Exercise 04

Section 15: Google Sheets: Graph It

Lecture 73 Types of Charts & Graphs

Lecture 74 Edit & Customize Charts: Part 1

Lecture 75 Edit & Customize Charts: Part 2

Lecture 76 Exercise 05

Section 16: Google Sheets: Share It

Lecture 77 Share & Collaborate: Part 1

Lecture 78 Share & Collaborate: Part 2

Lecture 79 Download, Print or Publish

Lecture 80 Exercise 06

Section 17: Google Sheets: Closing

Lecture 81 Course Wrap Up

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