Lesson 1: Gmail
-
Introduction to Gmail (1:58)
-
Gmail: Personalize Your Settings — Set Languages, Display Preferences, Vacation Responders, and Desktop Notifications (2:22)
-
Email Contacts — Compose an Email and Share Files and Images (3:37)
-
Reply to Email and Email Forwarding — Use Reply and Forward Options and Add Users in CC and BCC (2:50)
-
Use Chat and Video to Talk to Contacts — Launch Text Chats and Video Calls (1:51)
-
Manage Your Inbox — Use Filters, Block Addresses, Archive and Mute Messages, and Enable Multiple Inboxes (3:39)
-
Locate Messages — See Drafted and Sent Messages Using Search and Sort (1:28)
-
Use Gmail Offline — Enable Offline Access (1:47)
-
Gmail Wrap Up (1:42)
Lesson 2: Google Drive
-
Introduction to Google Drive (2:38)
-
Manage Files — Copy, Delete, Upload and Download Files (2:41)
-
Create and Manage Folders — Move, Rename, Delete and Upload Folders (3:06)
-
Change Display and Settings — Adjust Item View, Access Items Offline, and See Activity Updates (2:10)
-
Share Files and Folders — Adjust Permissions, Share with Others, and Publish Items to the Web (3:40)
-
Locate Files — Use Recent, Shared With Me and Search to Find Files (1:20)
-
Drive Wrap-Up (1:52)
Lesson 3: Google Hangout
-
Introduction to Hangout (1:56)
-
Open a Hangout (1:49)
-
Schedule a Hangout from your Calendar (2:03)
-
Launch a Hangout (2:24)
-
Present Your Screen — Share the Entire Screen or a Single Window (1:35)
-
Manage Sound and Video Quality (1:55)
-
Manage Meetings — Use Dial Ins, Invite More Users, Use Chat, and Mute or Eject Other Users (3:16)
-
Hangouts Wrap-up (1:58)
Lesson 4: Google Docs - Part 1
-
Introduction to Google Docs - Part 1 (3:41)
-
Set Up Your Document — Choose Page Size, Orientation and Color (2:58)
-
Add Headers, Footers and Page Numbers (3:28)
-
Format Text Blocks — Align Text, Adjust Line and Paragraph Spacing, and Use a Numbered or Bulleted List (4:08)
-
Set Paragraph Styles — Use Headings to Create a Table of Contents (2:59)
-
Docs - Part 1 Wrap-Up (1:59)
Lesson 5: Google Docs - Part 2
-
Introduction to Google Docs - Part 2 (2:40)
-
Change Fonts and Styles — Choose a Font, Set It's Size, Color, and Highlight, and Add Bold, Italic or Underline Formats (3:41)
-
Docs: Insert Images and Links — Add Images, External links, In-Doc Links and Bookmarks (3:07)
-
Insert and Format Tables — Create and Delete Tables, Rows, and Columns, and Manage Table Properties (2:16)
-
Use Tools to Review and Edit Document Text — Check Spelling and Add Words to a Personal Dictionary (2:02)
-
Share and Collaborate in Your Document — Use Comment, Edit, and Suggesting Modes and View Revision History (3:06)
-
Download Your File in Different Formats (1:39)
-
Docs - Part 2 Wrap-Up (1:00)
Lesson 6: Google Sheets - Part 1
-
Introduction to Google Sheets - Part 1 (3:38)
-
Duplicate Your Sheet and Add New Data — Add, Delete and Insert Data (3:31)
-
Format and Organize Spreadsheet Data — Use Bold and Italics, Merge Cells, Set Alignment, and Format Dates (2:31)
-
Continue Formatting and Organizing — Freeze Cells, Columns, and Rows, Add Borders, Set Fill Color, Add Borders, and Change Fonts and Sizes (3:54)
-
Add Data Validation to Limit Options (3:07)
-
Sort Your Data — Name and Sort Sheets or Ranges (2:31)
-
Google Sheets - Part 1 Wrap-Up (1:37)
Lesson 7: Google Sheets - Part 2
-
Introduction to Google Sheets - Part 2 (3:44)
-
Create Filters and Use Filter Views (4:37)
-
Use Filters to Count, Add, and Summarize Data in a Table — Use Sheets and COUNT (4:05)
-
Use the SUM Function to Analyze Data (2:07)
-
Display Data in a Chart — Create, Insert, and Modify Charts, and Protect Sheets and Ranges (3:09)
-
Use COUNTIF to Generate Numeric Data with Text Values (4:39)
-
Share and Collaborate — Add Comments, View Revision History, and Download Spreadsheets as File Types (4:25)
-
Sheets - Part 2 Wrap-Up (1:29)
Lesson 8: Google Sheets - Part 3
-
Introduction to Google Sheets - Part 3 (3:07)
-
Copy Sheets Into Your Spreadsheet — Copy from .csv and .xls File Types (4:03)
-
Use Functions to Calculate Cost and Current Sales — Format Currency and View Function List (3:22)
-
Use Functions to Summarize Data and Calculate Profit (4:28)
-
Use the MIN, MAX, and AVERAGE Functions to Analyze Sales Data (4:20)
-
Add Conditional Formatting to Emphasize Data (2:57)
-
Insert Links, Images, Forms and Drawings (3:21)
-
Sheets - Part 3 Wrap-Up (1:39)
Lesson 9: Google Slides - Part 1
-
Introduction to Google Slides - Part 1 (2:09)
-
Build a Presentation — Add, Copy, Paste, and Delete Slides, Apply Themes and Layouts, Add Page Numbers, Use Presenter Notes, and Link Slides (3:07)
-
Copy, Paste, and Link Slides and Change to Destination Formatting (2:52)
-
Work with Text — Insert Text Blocks, Change Font and Font Color, Size, Style, and Format, Add Highlight Color, and Set Capitalization (4:21)
-
Add Transitions and Animations and Watch in Preview (2:51)
-
Slides - Part 1 Wrap-Up (0:57)
Lesson 10: Google Slides - Part 2
Lesson 11: Google Slides - Part 3
-
Introduction to Google Slides - Part 3 (2:20)
-
Insert and Edit Tables (3:12)
-
Create Diagrams — Insert, Edit, and Align Diagrams (3:49)
-
Work with Charts — Insert and Edit Charts from Spreadsheet Data (2:42)
-
Share Your Presentation — Enter Presenter View, Access Print Settings, and Publish to the Web (4:28)
-
Slides - Part 3 Wrap-Up (0:54)
