Google Cloud Productivity: Docs, Forms, Sheets And Slides

Boost productivity with Google Cloud: Master Docs, Forms, Sheets, and Slides in this all-in-one essential course.

What you'll learn

Introduction Of Google Docs, Forms, Sheets and Slides

Find, Replace and Replace All

Font Change, Font Size Change, Clear Formatting, Bold, Italic, Underline, Strikethrough

Change font colour, highlight color and Text Effect and Typography

Margin, Column, Page size and Ruler

Bullets and Numbering

Text Box, Drop Cap, Equation and Symbols

Smart Art in Google Docs

Watermark Design

Adding & Editing Questions

Themes, Backgrounds & Fonts

How to View Responses

Get Email Notifications

Quiz Setup

Creating a New Presentation

Add, Duplicate, Move, Hide and Delete Slides

Image Circle In Google Slides

Adding Video to a Presentation

Customizing Chart Presentation

Adding Animations

Adding Slide Transitions

Conditional Formatting

Freezing Rows and Columns

Math and Logical Functions

Line, Area, Bar & Pie Charts in Google Sheets

VLOOKUP, HLOOKUP & XLOOKUP

Data Import (Web and HTML Table)

Requirements

No Prior Google Cloud Productivity Knowledge is Needed.

Description

Transform the way you work with Google Cloud's suite of powerful productivity tools! In this course, you’ll master Google Docs, Forms, Sheets, and Slides, empowering you to create, collaborate, and manage projects with ease. Whether you’re a student, professional, or business owner, this course will help you unlock the full potential of Google Workspace tools to enhance productivity and collaboration.What You’ll Learn:Google Docs: Create, edit, and format documents with professional-level features. Learn collaborative editing, comments, and version control to streamline teamwork.Google Sheets: Master data entry, formulas, and functions for effective data analysis. Explore advanced features like conditional formatting, pivot tables, and charts to visualize and interpret data.Google Forms: Build dynamic forms for surveys, quizzes, and feedback. Analyze responses and integrate with other Google tools for seamless data collection.Google Slides: Create visually stunning presentations. Learn how to design slides with transitions, animations, and multimedia elements to deliver impactful presentations.Includes This Course:Google Docs:Introduction Of Google DocsCopy, Cut and PasteFind, Replace and Replace AllFont Change, Font Size Change, Clear Formatting, Bold, Italic, Underline, StrikethroughChange font color, highlight color and Text Effect and TypographyMargin, Column, Page size and RulerBullets and NumberingTable Design & layout tabPage Layout Design - Google DocsHeader & Footer DesignIndent and BordersAlignments, Line SpacingSorting, ShadingText Box, Drop Cap, Equation and SymbolsSmart Art in Google DocsWatermark DesignPage Setup and PrintGoogle Forms:Introduction Of Google FormForm SetupTitle & DescriptionAdding & Editing Questionsadd rating questionsDifferent Question TypesImages & VideosMore Question Types and Response ValidationImporting QuestionsAdding Sections and TitlesThemes, Backgrounds & FontsCustom HeadersSettingsSend & Link Sharing FormsHow to View ResponsesConnect Google Forms to Google SheetsGet Email Notificationsstop receiving responsesQuiz SetupParagraph Quiz QuestionMultiple Choice Quiz QuestionShort Answer Quiz FormCheckbox Quiz QuestionGoogle Sheets:Introduction Of Google SheetUser Interface OverviewFormatting BasicFreezing Rows and ColumnsConditional FormattingSort and Filter DataFind and ReplaceMath Functions (SUM, AVERAGE, MAX, MIN, COUNT )Logical Functions (AND, OR IF)Text Functions (LOWER, UPPER, CONCATENATE, PROPER)Left and Right (LEFT, RIGHT)Line, Area, Bar & Pie Charts in Google SheetsVLOOKUP & HLOOKUPXLOOKUPData Import (Web and HTML Table)MacrosGoogle Slides:Introduction Of Google SlideCreating a New PresentationAdding Text & Text box in SlidesWorking with Bulleted or Numbered ListsImport New Theme & Changing ThemeAdd, Duplicate, Move, Hide and Delete SlidesInserting ImagesResizing and Cropping ImagesImage Circle In Google SlidesUsing Word ArtAdding Video to a PresentationTransparent Background imageAdd and Customizing the Table DesignCustomizing Chart PresentationAdding AnimationsAdding Slide TransitionsAction Buttons SlidesWhy Take This Course?Comprehensive Training: From basics to advanced features, this course offers step-by-step guidance for each tool.Hands-On Projects: Apply what you learn with real-world projects that improve your understanding of the tools.Boost Productivity: Learn shortcuts, tips, and best practices to enhance your productivity and streamline workflows.By the end of this course, you’ll be able to confidently use Google Docs, Forms, Sheets, and Slides to improve your work efficiency, collaborate more effectively, and boost productivity. Join today and take your Google Cloud productivity skills to the next level!

Overview

Section 1: Get Started Google Cloud Productivity

Lecture 1 Introduction Of Google Docs

Lecture 2 Introduction Of Google Form

Lecture 3 Introduction Of Google Sheet

Lecture 4 Introduction Of Google Slide

Section 2: Google Docs

Lecture 5 Copy, Cut and Paste

Lecture 6 Find, Replace and Replace All

Lecture 7 Font Change, Font Size Change, Clear Formatting, Bold, Italic, Underline, Strike

Lecture 8 Change font colour, highlight color and Text Effect and Typography

Lecture 9 Margin, Column, Page size and Ruler

Lecture 10 Bullets and Numbering

Lecture 11 Table Design & layout tab

Lecture 12 Page Layout Design

Lecture 13 Header & Footer Design

Lecture 14 Indent and Borders

Lecture 15 Alignments, Line Spacing

Lecture 16 Sorting, Shading

Lecture 17 Text Box, Drop Cap, Equation and Symbols

Lecture 18 Smart Art in Google Docs

Lecture 19 Watermark Design

Lecture 20 Page Setup and Print

Section 3: Google Form

Lecture 21 Form Setup

Lecture 22 Title & Description

Lecture 23 Adding & Editing Questions

Lecture 24 add rating questions

Lecture 25 Different Question Types

Lecture 26 Images & Videos

Lecture 27 More Question Types and Response Validation

Lecture 28 Importing Questions

Lecture 29 Adding Sections and Titles

Lecture 30 Themes, Backgrounds & Fonts

Lecture 31 Custom Headers

Lecture 32 Settings

Lecture 33 Send & Link Sharing Forms

Lecture 34 How to View Responses

Lecture 35 Connect Google Forms to Google Sheets

Lecture 36 Get Email Notifications

Lecture 37 stop receiving responses

Lecture 38 Quiz Setup

Lecture 39 Paragraph Quiz Question

Lecture 40 Multiple Choice Quiz Question

Lecture 41 Short Answer Quiz Form

Lecture 42 Checkbox Quiz Question

Section 4: Google Sheets

Lecture 43 User Interface Overview

Lecture 44 Formatting Basic

Lecture 45 Freezing Rows and Columns

Lecture 46 Conditional Formatting

Lecture 47 Sort and Filter Data

Lecture 48 Find and Replace

Lecture 49 Math Functions (SUM, AVERAGE, MAX, MIN, COUNT )

Lecture 50 Logical Functions (AND, OR IF)

Lecture 51 Text Functions (LOWER, UPPER, CONCATENATE, PROPER)

Lecture 52 Left and Right (LEFT, RIGHT)

Lecture 53 Line, Area, Bar & Pie Charts in Google Sheets

Lecture 54 XLOOKUP

Lecture 55 Data Import (Web and HTML Table)

Lecture 56 Macros

Section 5: Google Slide

Lecture 57 Creating a New Presentation

Lecture 58 Adding Text & Text box in Slides

Lecture 59 Working with Bulleted or Numbered Lists

Lecture 60 Import New Theme & Changing Theme

Lecture 61 Add, Duplicate, Move, Hide and Delete Slides

Lecture 62 Inserting Images

Lecture 63 Transparent Background image

Lecture 64 Add and Customizing the Table Design

Lecture 65 Adding Animations

Lecture 66 Adding Slide Transitions

Lecture 67 Action Buttons Slides

Beginners: Perfect for those new to Google Workspace looking to become proficient with Google Docs, Sheets, Forms, and Slides.,Educators and Students: Enhance teaching, learning, and project management with Google’s free and easy-to-use productivity tools.