Serving schools, colleges & students across India Sign inRegister freeFAQsHelpcontact@ghosla.io
GHOSLAGrowth Hub for Opportunities, Skills, Learning & AchievementGrow•Learn•Achieve Login Get Started

Solutions (For Institutions)

School ERPComplete school management College ERPComplete college management University ERPUniversity-wide management Coaching Classes ERPCoaching institute management

For Students

Ghosla AIAI-powered education & career assistant AI Career TestFind the careers that fit you Education LoansPlan, apply & track your loan Skills & CertificationsFree courses, Skill Score, certificates All 103 CoursesJob-ready courses, free right now Find Better SchoolsDiscover the right school for you Find Better CollegesDiscover the right college for you

Discover

Browse by City66 cities across India

Google Workspace Mastery: Docs, Sheets, Forms, Drive

Work smarter in the cloud: collaborate in Docs, analyse in Sheets, collect data with Forms and organise Drive

Ghosla Academy · Office Skills Team

Google Workspace tools are free with a Google account and are used by many schools, startups, NGOs and small businesses across India. Most people use them only at a basic level and miss features like Suggesting mode, data validation, pivot tables, QUERY and self-grading quizzes. This course shows you practical workflows: organising Drive, collaborating on documents, building forms that feed live sheets, and running a team project hub. Lessons use Indian examples such as event registrations, attendance, fee tracking and college projects.

What you will be able to do

  • Organise and search files in Google Drive with clear folder structures
  • Share files safely with the right permission levels
  • Collaborate in Docs using comments, Suggesting mode and version history
  • Use Sheets formulas, validation, pivots, charts and QUERY
  • Build Google Forms and self-grading quizzes linked to Sheets
  • Plan work with Gmail, Calendar and Slides and keep accounts secure

What you build

  • Registration form connected to a live tracker sheet
  • Team project hub on Google Drive with shared Docs, Sheets and Calendar

What you need to start

  • A free Google account (Gmail) and internet access
  • A laptop or desktop with Chrome or any modern browser (phone apps work for some lessons)

Curriculum · 6 sections, 22 lectures

Google account and Drive4 lectures
  1. Google Workspace overview and account setupFree preview8 min
  2. Drive: upload, organise and searchFree preview10 min
  3. Sharing permissions done right11 min
  4. Quiz: Drive and sharing5 min
Google Docs4 lectures
  1. Docs essentials: formatting, headings and outline11 min
  2. Comments, Suggesting mode and version history11 min
  3. Voice typing, templates and smart features9 min
  4. Quiz: Google Docs5 min
Google Sheets4 lectures
  1. Sheets basics and everyday formulas12 min
  2. Sorting, filters, data validation and conditional formatting12 min
  3. Pivot tables, charts and the QUERY function14 min
  4. Quiz: Google Sheets5 min
Google Forms4 lectures
  1. Building forms and self-grading quizzes12 min
  2. Responses, linked Sheets and summaries10 min
  3. Project: registration form to live tracker18 min
  4. Quiz: Google Forms5 min
Slides, Gmail and Calendar3 lectures
  1. Google Slides for team presentations10 min
  2. Gmail and Calendar productivity11 min
  3. Quiz: Slides, Gmail and Calendar5 min
Workflows and safety3 lectures
  1. Account security and privacy basics8 min
  2. Project: team project hub on Drive20 min
  3. Quiz: final review6 min

Who this is for

  • School and college students working on group projects
  • Teachers, coordinators and admins who collect data with forms
  • Freshers and small teams that use free cloud tools for office work