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

Google Office Suite Training – Sheets, Docs, Slides and Form, available at $54.99, has an average rating of 4.65, with 71 lectures, based on 41 reviews, and has 212 subscribers.

You will learn about 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 This course is ideal for individuals who are Business professionals with a desire to increase efficiency and accessibility or High School and College Students It is particularly useful for Business professionals with a desire to increase efficiency and accessibility or High School and College Students.

Enroll now: Google Office Suite Training – Sheets, Docs, Slides and Form

Summary

Title: Google Office Suite Training – Sheets, Docs, Slides and Form

Price: $54.99

Average Rating: 4.65

Number of Lectures: 71

Number of Published Lectures: 71

Number of Curriculum Items: 71

Number of Published Curriculum Objects: 71

Original Price: ₹5,900

Quality Status: approved

Status: Live

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

Who Should Attend

Business professionals with a desire to increase efficiency and accessibility
High School and College Students

Target Audiences

Business professionals with a desire to increase efficiency and accessibility
High School and College Students

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.

Course Curriculum

Chapter 1: Google Sheets

Lecture 1: Understanding Google Sheets

Lecture 2: Autofill and Smartfill option

Lecture 3: Operators Based Equation

Lecture 4: Math Functions in Google sheet

Lecture 5: Advance Math Function

Lecture 6: Using of Wild Card in Math Function

Lecture 7: Logical Function – IF()

Lecture 8: Nested IF Function

Lecture 9: IF Function related Task

Lecture 10: IF Function Task Solution

Lecture 11: AND and OR Function

Lecture 12: Upper, Lower, Proper and Trim Function

Lecture 13: Left, Right and Find Function

Lecture 14: Left, Right and Find Nesting Methodology

Lecture 15: Mid Function

Lecture 16: Concatenate Function

Lecture 17: Replace Function

Lecture 18: Substitute and Len Function

Lecture 19: Split Text to Column

Lecture 20: Filter in Google Sheets

Lecture 21: Slicer, Sort and Column Stat

Lecture 22: Conditional Formatting in Google Sheets

Lecture 23: Named Ranges in Google Sheets

Lecture 24: Creating Link in Google Sheets

Lecture 25: Data Validation in Google Sheets

Lecture 26: Pivot Table in Google Sheet

Lecture 27: Chart Preparation in Google Sheets

Lecture 28: Vlookup Function

Lecture 29: Iferror with Vloookup Function

Lecture 30: Hlookup Function

Lecture 31: Match and Index Function

Lecture 32: Match and Index Function Nested

Lecture 33: Vlookup With Match – Advance

Lecture 34: Vlookup TRUE – Amazing Technique

Lecture 35: Array Function – Vlookup

Lecture 36: Managing Date and Time in Google Sheets

Lecture 37: Datedif and Networkdays Function

Lecture 38: Financial Function – PMT, PPMT, IPMT and PV

Lecture 39: Record Macro in Google Sheets

Lecture 40: Sharing and Protection in Google Sheets

Chapter 2: Google Docs

Lecture 1: Getting Started with Google Docs

Lecture 2: Format Options in Google Docs

Lecture 3: Bullets and Numbering

Lecture 4: Styles in Docs- Heading Pattern

Lecture 5: Understanding File Tab in Docs

Lecture 6: Print Option in Docs

Lecture 7: Bookmark and Link in Docs

Lecture 8: Header, Footer and Page no in Docs

Lecture 9: Understanding Edit Tab in Docs

Lecture 10: View Tab and Page Break in Docs

Lecture 11: Table of Content

Lecture 12: Footnote in Docs

Lecture 13: Line and Date in Docs

Lecture 14: Image Format in Docs

Lecture 15: Creating Table in Docs

Lecture 16: Charts in Docs

Lecture 17: Drawing Option in Docs

Lecture 18: Text Format and Column option

Lecture 19: Word Count, Translate and Voice Typing

Lecture 20: Comment and Citation in Docs

Lecture 21: Addons on Docs

Lecture 22: Mail Merge in Docs

Chapter 3: Google Slides

Lecture 1: Getting started in Google Slides

Lecture 2: Quick Guide to Presentation

Lecture 3: Options in File Tab

Lecture 4: Options in View Tab

Lecture 5: Audio and Video Management in Slides

Lecture 6: Creating Diagram and slide number

Lecture 7: Format and Arrange option

Lecture 8: Slides Management

Chapter 4: Google Forms

Lecture 1: Creating Google Forms

Instructors

Himanshu Dhar
MIS Trainer

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 5 votes
4 stars: 10 votes
5 stars: 25 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu