Google Office Suite Training - Sheets, Docs, Slides and Form

Google office suites for Maximum Productivity - Enhance Your Office Efficiency with Docs, Sheets, Slides and Forms.

4.75 (38 reviews)
Udemy
platform
English
language
Google
category
instructor
187
students
9 hours
content
Aug 2021
last update
$54.99
regular price

What you will learn

Mastering Google Sheets at MIS level

Expertise in Text, Logical, Math, Financial, Lookup and Reference Functions

Understanding Date and Time Format and Functions

Mastery in Pivot Table and Chart Preparation

Learning Data Validation, Filter, Conditional Formatting, Named Ranges, Link and Record Macro

Sharing and Protection of data

Have a solid understanding of Google Docs functionality and how to use the program effectively

Learn to create professional looking presentations, as well as share and present them

Create Google Forms and surveys, as well as collect and analyze data from them

Understand how to use Google Drive to increase efficiency and productivity

Description

Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk or from your smartphone or tablet on the go Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.

In this course you will learn the fundamentals as advance topics of Google Sheets (much of which can be used in MS Excel as well). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like TEXT Function, LOGICAL Function, TEXT Function, LOOKUP Function and many more. You may expect to learn following topics in detail.

Google Docs is Google's browser-based word processor. You can create, edit, and share documents online and access them from any computer with an internet connection. There's even a mobile app for Android and iOS. Moreover, Google Docs add-ons let you expand the functionality and add missing features.

Google Slides is a presentation program included as part of the free, web-based Google Docs Editors suite offered by Google. Google Slides makes your ideas shine with a variety of presentation themes, hundreds of fonts, embedded video, animations, and more. All for free.

Google Forms is a survey administration software included as part of the free, web-based Google Docs Editors suite offered by Google. Create a new survey and edit it with others at the same time. Choose from a variety of pre-made themes or create your own. Free with a Google account.

Content

Google Sheets

Understanding Google Sheets
Autofill and Smartfill option
Operators Based Equation
Math Functions in Google sheet
Advance Math Function
Using of Wild Card in Math Function
Logical Function - IF()
Nested IF Function
IF Function related Task
IF Function Task Solution
AND and OR Function
Upper, Lower, Proper and Trim Function
Left, Right and Find Function
Left, Right and Find Nesting Methodology
Mid Function
Concatenate Function
Replace Function
Substitute and Len Function
Split Text to Column
Filter in Google Sheets
Slicer, Sort and Column Stat
Conditional Formatting in Google Sheets
Named Ranges in Google Sheets
Creating Link in Google Sheets
Data Validation in Google Sheets
Pivot Table in Google Sheet
Chart Preparation in Google Sheets
Vlookup Function
Iferror with Vloookup Function
Hlookup Function
Match and Index Function
Match and Index Function Nested
Vlookup With Match - Advance
Vlookup TRUE - Amazing Technique
Array Function - Vlookup
Managing Date and Time in Google Sheets
Datedif and Networkdays Function
Financial Function - PMT, PPMT, IPMT and PV
Record Macro in Google Sheets
Sharing and Protection in Google Sheets

Google Docs

Getting Started with Google Docs
Format Options in Google Docs
Bullets and Numbering
Styles in Docs- Heading Pattern
Understanding File Tab in Docs
Print Option in Docs
Bookmark and Link in Docs
Header, Footer and Page no in Docs
Understanding Edit Tab in Docs
View Tab and Page Break in Docs
Table of Content
Footnote in Docs
Line and Date in Docs
Image Format in Docs
Creating Table in Docs
Charts in Docs
Drawing Option in Docs
Text Format and Column option
Word Count, Translate and Voice Typing
Comment and Citation in Docs
Addons on Docs
Mail Merge in Docs

Google Slides

Getting started in Google Slides
Quick Guide to Presentation
Options in File Tab
Options in View Tab
Audio and Video Management in Slides
Creating Diagram and slide number
Format and Arrange option
Slides Management

Google Forms

Creating Google Forms

Screenshots

Google Office Suite Training - Sheets, Docs, Slides and Form - Screenshot_01Google Office Suite Training - Sheets, Docs, Slides and Form - Screenshot_02Google Office Suite Training - Sheets, Docs, Slides and Form - Screenshot_03Google Office Suite Training - Sheets, Docs, Slides and Form - Screenshot_04

Reviews

Bonisile
September 29, 2022
The training was great and informative. I just wish there were ways we could get practicals so we can try it on our end as well instead of just watching it.
Dhruba
March 12, 2022
It looks amazing. However, it could have been improved by adding some extension on Google Docs which looks short one compared to google sheets.

Charts

Price

Google Office Suite Training - Sheets, Docs, Slides and Form - Price chart

Rating

Google Office Suite Training - Sheets, Docs, Slides and Form - Ratings chart

Enrollment distribution

Google Office Suite Training - Sheets, Docs, Slides and Form - Distribution chart
4265910
udemy ID
8/27/2021
course created date
8/30/2021
course indexed date
Bot
course submited by