Sheets - Part 3 Wrap-Up | MWKA

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Google Workspace Training

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

Introduction to Google Slides - Part 2 (1:55)
Insert and Edit Images — Add Images, Align Using Snap-to Guides, and Resize (4:51)
Insert and Edit Videos (2:28)
Work with Lines and Shapes — Insert, Edit, Group, and Arrange Lines and Shapes (3:18)
Slides - Part 2 Wrap-Up (1:01)

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)

Teach online with

Sheets - Part 3 Wrap-Up

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock