Tutorialspoint

4th Of July Sale Flat 10% off, Use Code: FREEDOM10

Google Workspace (G Suite) Training - Beginners to Advance Level

person icon Himanshu Kumar Dhar

4.1

Google Workspace (G Suite) Training - Beginners to Advance Level

G Suite practical Training - Google Docs, Google Sheets, Google Slides, Google Calendar, Google Drive, Gmail and Google Forms

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Himanshu Kumar Dhar

category icon Google workspace(Gsuit),Google Office,Office Productivity

Lectures -114

Resources -10

Duration -14.5 hours

4.1

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

G Suite is into a more integrated experience across communication and collaboration tools, it’s rebranded to Google Workspace to more accurately represent the product vision. Similar to G Suite, all Google Workspace include collaboration tools like Gmail, Calendar, Meet, Chat, Drive, Docs, Sheets, Slides, Forms and many more. This course going to cover all the topics from the very basic to the most advance level.

Loaded with tips and tricks, resources and helpful information ready to help you learn Google Workspace. Work faster and smarter, do more with G Suite. Explore how to get more productive - make use of all the amazing features that G Suite has to offer. It is perfect for workplace collaboration, communications and productivity. You can also use your own personal Gmail account for free!

Course covers everything you need to know about using Google in your Workplace with Google Workspace (G Suite Apps or the Google Suite).

Google Calendar – Spend less time planning and more time doing with shareable calendars that integrate seamlessly with Gmail, Drive, Contacts, Sites and Meet so you always know what's next. Calendar lets you keep track of important events, share your schedule, and create multiple calendars.

Discover Google Gmail - The latest Gmail makes it easier to stay on top of the work that matters. With secure, ad-free email as a foundation, you can also chat, make voice or video calls, and stay on top of project work with shared files and tasks.

Get to know Google Drive - Store, access and share your files in one secure place. Store any and every file. Access files anytime, anywhere from your desktop and mobile devices. Control how files are shared. With centralized administration, data loss prevention, and Vault for Drive, you can easily manage users and file sharing to help meet data compliance needs.

Get inspired with Google Docs - Word processing for teams. Create and edit text documents directly in your browser – no dedicated software required. Several people can work at the same time, and every change is saved automatically. Create documents, add images, updates styling, edit and use the doc tools to get things done. Fast simple and easy to use with this guide to master Google Docs along with top hacks, tips and tricks.

Take charge of your data with Google Sheets in a sheet - Sheets was designed with the needs of agile organizations in mind. AI features mean you can tap into the right insights to make meaningful business decisions. A cloud-based architecture enables you to collaborate with anyone, anytime, anywhere. Compatibility with external systems, including Microsoft Office, removes the friction of working with multiple data sources. And built on top of Google’s infrastructure, Sheets gives you the freedom to create, while helping to keep your information secure.

Create, edit and collaborate with Google Slides - Present your ideas with ease to everyone. The cloud allows you to present anywhere, professional stunning presentations you can create with an easy to use interface. Create and edit polished presentations in your browser – no software required. Work on a single presentation online with your business partner, your whole team or external contacts. You control who gets permission to edit, view or just add comments.

Connect with others using Google Meet - Secure video meetings for your business. Hold video meetings with people inside or outside of your organization. Video conference with international teams, hold remote interviews, conduct webinars, and more. Collaborate in video meetings, record meetings, learn productivity tips for Meet.

Discover Google Forms and see what you can do with Google Forms - Create custom forms for surveys and questionnaires at no extra cost. Gather everything in a spreadsheet and analyze data directly in Google Sheets. Forms lets you manage event registrations, create quizzes, analyze responses, and more. It's easy to create your own quizzes, surveys, and gather user responses.

Google Keep and Tasks Keep organized. Capture inspiration and to-dos effortlessly. Collaborate on notes with teammates and set reminders to stay on track. Everything syncs across your devices, so what's important is always within reach.

Goals

  1. Mastering Google Sheets at MIS level
  2. Expertise in Text, Logical, Math, Financial, Lookup and Reference Functions
  3. Understanding Date and Time Format and Functions
  4. Mastery in Pivot Table and Chart Preparation
  5. Learning Data Validation, Filter, Conditional Formatting, Named Ranges, Link and Record Macro
  6. Sharing and Protection of data
  7. Have a solid understanding of Google Docs functionality and how to use the program effectively
  8. Learn to create professional looking presentations, as well as share and present them
  9. Create Google Forms and surveys, as well as collect and analyze data from them
  10. Learn better time management with Google Calendar
  11. Learn to create Events, Task and Reminders in Google Calendar
  12. Learn to Create New Calendar, Integrate Calendar, Import and Export Calendar
  13. Learn Google Keep - one of the best note taking service
  14. How to use Google Drive for File storage and synchronization service to increase efficiency and productivity
  15. learn to use the Gmail more effectively and save plenty of hours with Labels, Archive, Filter, Snoozed Button, Mail Merge and many more options


Prerequisites

Basic Computer Knowledge

Google Workspace (G Suite) Training - Beginners to Advance Level

Curriculum

Check out the detailed breakdown of what’s inside the course

Google Sheets
40 Lectures
  • play icon Understanding Google Sheets 09:29 09:29
  • play icon Autofill and Smartfill Option 08:27 08:27
  • play icon Operators Based Equation 05:03 05:03
  • play icon Math Functions in Google Sheet 13:31 13:31
  • play icon Advance Math Function 12:43 12:43
  • play icon Using of Wild Card in Math Function 07:37 07:37
  • play icon Logical Function - IF() 07:05 07:05
  • play icon Nested IF Function 05:11 05:11
  • play icon IF Function related Task 02:05 02:05
  • play icon IF Function Task Solution 09:08 09:08
  • play icon AND and OR Function 04:57 04:57
  • play icon Upper, Lower, Proper and Trim Function 05:48 05:48
  • play icon Left, Right and Find Function 10:33 10:33
  • play icon Left, Right and Find Nesting Methodology 07:15 07:15
  • play icon Mid Function 03:15 03:15
  • play icon Concatenate Function 03:57 03:57
  • play icon Replace Function 04:36 04:36
  • play icon Substitute and Len Function 09:34 09:34
  • play icon Split Text to Column 04:39 04:39
  • play icon Filter in Google Sheets 17:00 17:00
  • play icon Slicer, Sort and Column Stat 05:41 05:41
  • play icon Conditional Formatting in Google Sheets 10:37 10:37
  • play icon Named Ranges in Google Sheets 04:26 04:26
  • play icon Creating Link in Google Sheets 05:33 05:33
  • play icon Data Validation in Google Sheets 16:48 16:48
  • play icon Pivot Table in Google Sheet 13:20 13:20
  • play icon Chart Preparation in Google Sheets 24:45 24:45
  • play icon Vlookup Function 10:46 10:46
  • play icon Iferror with Vloookup Function 07:03 07:03
  • play icon Hlookup Function 05:21 05:21
  • play icon Match and Index Function 05:31 05:31
  • play icon Match and Index Function Nested 05:35 05:35
  • play icon Vlookup With Match - Advance 08:47 08:47
  • play icon Vlookup TRUE 03:23 03:23
  • play icon Array Function - Vlookup 04:40 04:40
  • play icon Managing Date and Time in Google Sheets 11:33 11:33
  • play icon Datedif and Networkdays Function 09:36 09:36
  • play icon Financial Function - PMT, PPMT, IPMT and PV 10:01 10:01
  • play icon Record Macro in Google Sheets 08:18 08:18
  • play icon Sharing and Protection in Google Sheets 10:16 10:16
Google Docs
22 Lectures
Tutorialspoint
Google Slides
8 Lectures
Tutorialspoint
Google Forms
2 Lectures
Tutorialspoint
Gmail - Google Email Service
12 Lectures
Tutorialspoint
Google Meet
1 Lectures
Tutorialspoint
Google Drive
4 Lectures
Tutorialspoint
Google Keep - Note-taking service
4 Lectures
Tutorialspoint
Google Calendar - Time Management and Scheduling Calendar Service
5 Lectures
Tutorialspoint
Google Sites - Web Page creation tool
16 Lectures
Tutorialspoint

Instructor Details

Himanshu Kumar Dhar

Himanshu Kumar Dhar


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515