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
Google workspace(Gsuit),Google Office,Office Productivity
Lectures -114
Resources -10
Duration -14.5 hours
30-days Money-Back Guarantee
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
- 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
- Learn better time management with Google Calendar
- Learn to create Events, Task and Reminders in Google Calendar
- Learn to Create New Calendar, Integrate Calendar, Import and Export Calendar
- Learn Google Keep - one of the best note taking service
- How to use Google Drive for File storage and synchronization service to increase efficiency and productivity
- 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 Google Workspace (G Suite) Training - Beginners to Advance Level](https://d3mxt5v3yxgcsr.cloudfront.net/courses/19362/course_19362_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Google Sheets
40 Lectures
-
Understanding Google Sheets 09:29 09:29
-
Autofill and Smartfill Option 08:27 08:27
-
Operators Based Equation 05:03 05:03
-
Math Functions in Google Sheet 13:31 13:31
-
Advance Math Function 12:43 12:43
-
Using of Wild Card in Math Function 07:37 07:37
-
Logical Function - IF() 07:05 07:05
-
Nested IF Function 05:11 05:11
-
IF Function related Task 02:05 02:05
-
IF Function Task Solution 09:08 09:08
-
AND and OR Function 04:57 04:57
-
Upper, Lower, Proper and Trim Function 05:48 05:48
-
Left, Right and Find Function 10:33 10:33
-
Left, Right and Find Nesting Methodology 07:15 07:15
-
Mid Function 03:15 03:15
-
Concatenate Function 03:57 03:57
-
Replace Function 04:36 04:36
-
Substitute and Len Function 09:34 09:34
-
Split Text to Column 04:39 04:39
-
Filter in Google Sheets 17:00 17:00
-
Slicer, Sort and Column Stat 05:41 05:41
-
Conditional Formatting in Google Sheets 10:37 10:37
-
Named Ranges in Google Sheets 04:26 04:26
-
Creating Link in Google Sheets 05:33 05:33
-
Data Validation in Google Sheets 16:48 16:48
-
Pivot Table in Google Sheet 13:20 13:20
-
Chart Preparation in Google Sheets 24:45 24:45
-
Vlookup Function 10:46 10:46
-
Iferror with Vloookup Function 07:03 07:03
-
Hlookup Function 05:21 05:21
-
Match and Index Function 05:31 05:31
-
Match and Index Function Nested 05:35 05:35
-
Vlookup With Match - Advance 08:47 08:47
-
Vlookup TRUE 03:23 03:23
-
Array Function - Vlookup 04:40 04:40
-
Managing Date and Time in Google Sheets 11:33 11:33
-
Datedif and Networkdays Function 09:36 09:36
-
Financial Function - PMT, PPMT, IPMT and PV 10:01 10:01
-
Record Macro in Google Sheets 08:18 08:18
-
Sharing and Protection in Google Sheets 10:16 10:16
Google Docs
22 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Google Slides
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Google Forms
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Gmail - Google Email Service
12 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Google Meet
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Google Drive
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Google Keep - Note-taking service
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Google Calendar - Time Management and Scheduling Calendar Service
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Google Sites - Web Page creation tool
16 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Himanshu Kumar Dhar](https://www.tutorialspoint.com/assets/profiles/519212/profile/200_296504-1692624874.jpg)
Himanshu Kumar Dhar
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual 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 Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)