
Learn the basics of Google Sheets, including its internet dependence, how to access and create sheets, save to Google Drive, work offline, and explore the template gallery.
Master autofill and smart fill in Google Sheet to automatically extend patterns, dates, days, and months, and learn how to generate names and initials with suggested smart fills.
Explore how to build formulas in Google Sheets using operators, brackets, and the order of operations to calculate profits and perform addition, subtraction, multiplication, and division.
Learn to use Google Sheets math functions including sum, average, count, counta, countblank, max, min, large, and small, with text and blanks handled via nesting.
Explore advanced math functions such as sumif, sumifs, averageif, averageifs, countif, and countifs, using conditional ranges and criteria to analyze sales data.
Master wild cards in Excel with countif, using asterisks and question marks to build starting with and ending with patterns. Apply to names and email domains like Gmail and Yahoo.
Explore logical operators such as greater than, less than, equal to, and not equal to; apply the if function to produce true/false or pass/fail results based on a student score.
Learn to apply a nested if function in Google Sheets to classify scores into fail, compartment, or pass using thresholds less than 40, 40 to 60, and above 60.
Master the if function by calculating scholarship amounts for scores above 70 (score × 1000). Also identify topper and lowest scorer and apply pass/fail rules below 48 or above 40.
Learn to solve an if function task in google sheets for scholarships: check score over 70 and multiply by 1000; use max/min with absolute references to find toppers and lowest.
Explore and apply and/or logic functions in spreadsheets, using the if function to test multiple conditions and determine pass or fail based on true/false outcomes.
Explore text functions in a spreadsheet, including upper, lower, proper, and trim, and master nesting outputs, space handling, sentence case, and Google case.
Learn how to use left, right, and find text functions to extract characters from the left or right and locate positions within strings.
Master nesting methodology using left, find, and right text functions to extract a name and a mobile number from a sentence with dynamic character counts.
Master the mid function alongside left, right, and find to extract a mobile number from text. Set the start position and length for a dynamic 10-character result after a hyphen.
Demonstrate using the concatenate function to join text and prefix mobile numbers with 91, then format them with left, mid, and right to produce digits - digits - digits.
Master the replace function to standardize pin codes by using find, text, and right to locate digits and replace with 110011, with dynamic position and length.
Explore the substitute and replace functions to modify text in spreadsheets, including occurrence controls and case sensitivity, with practical examples like pin codes, plus using length to count occurrences.
Split text to column in Google Sheets splits a single column into multiple columns using separators like comma, space, hyphen, or custom options, and can extract phone numbers.
Apply filters in Google Sheets to organize data, options such as is empty, is not empty, text contains, starts with, and explore custom formulas, filter views, and filter by color.
Apply the slicer and sorting by selecting a column, filter data with the slicer options, and review column statistics to interpret qualification, course, and location data.
Learn how to apply conditional formatting in Google Sheets to highlight data with colors, using rules for text, values, custom formulas, and color scales.
Learn to create and manage named ranges in Google Sheets, including naming ranges without spaces or special characters, using them for navigation, and applying them in formulas like concatenate.
Learn to create and manage links in google sheets, linking named ranges, destination cells, other sheets, and external websites, while editing or removing links for marketing cost and sales data.
Explore data validation in Google Sheets, applying text rules, date constraints, list from range, valid email checks, checkboxes, and custom formulas to enforce accurate data entry.
Master pivot tables in Google Sheets to summarize data by rows, columns, values, and filters, using items, dates, clients, and numbers sold for clear, actionable reports.
Learn chart preparation in Google Sheets by selecting data, choosing chart types such as column and pie, and refining axes, legends, and titles.
Learn how to use the vlookup function to retrieve exact matches from master data, including vertical and horizontal lookups, range selection, and handling across multiple sheets with import range.
learn to handle vlookup errors with iferror, showing no data found instead of hash errors, and extend with nested vlookup across multiple sheets for missing matches.
Learn how to use the hlookup function for horizontal data in Google Sheets, including preparing data with transpose, selecting a master range, and specifying search key, index, and is_sorted.
Learn how to use match and index functions in tandem to lookup names and details from a master data sheet, with exact and approximate searches.
Learn to use the match and index functions to retrieve names and qualifications from master data by matching a phone number in a data sheet.
Learn to use vlookup with match and index to fetch course, contact, and location from a master data sheet by name, with absolute references for reliable drag-down results.
Demonstrate vlookup with approximate match to categorize scores into compartments, using exact (false or zero) and approximate (two or one) options across 0–39.99, 40–59.99, 60–89.99, and 90+ distinctions.
Learn how to perform a multi-column vlookup using the array function in Google Sheets, applying the lookup across multiple columns with a single array formula.
Master date and time handling in Google Sheets by entering correct formats, using date and time functions (year, month, day, today, now), and applying versatile formatting.
Learn to use the datedif function to calculate exact age in years, months, and days, and apply networkdays to count working days while excluding weekends and holidays.
Learn to calculate emi and analyze loan details using pmt, ppmt, ipmt and pv functions, including rate per month, total payable, and principal versus interest breakdown.
Learn how to record macros in Google Sheets to automate tasks, choosing absolute or relative references, save named macros with shortcuts, and apply formatting or IF-based scoring functions via buttons.
Learn how to share and protect Google Sheets by configuring link access, setting editor or viewer permissions, and applying sheet and range protections to safeguard data.
Explore Google Docs in Google Workspace, learn to open, upload, and create documents, access templates, save to Google Drive, and use editing, viewing, and suggesting modes with track changes.
Explore core Google Docs format options, including undo/redo, print, spelling and grammar checks, paint format, zoom, font, size, bold, italic, underline, text color and highlight, alignment, and line spacing.
Explore creating and customizing bullets and numbering, including multilevel lists and checklists, changing bullet styles, using sublists with tab, and applying clear formatting.
Explore styles in docs by applying a heading pattern to structure templates, create a document outline, and enable navigation, bookmarking, and hyperlinks.
Explore the Google Docs file tab, including creating new documents, opening existing files, uploading, making copies, emailing, downloading formats, offline access, renaming, moving, and publishing to the web.
Explore Google Docs print options, including file > page setup, orientation (portrait or landscape), paper size (A4 or A3), margins, color, and print previews.
Learn how to create bookmarks in Google Docs, insert and remove links to bookmarks or headings, and link to web pages or other documents for streamlined navigation.
Explore how to add and customize headers and footers in Google Docs, including margins and different first page settings. Learn to insert and format page numbers and manage odd/even headers.
Master the edit tab in Google Docs: use undo/redo, copy and paste (with or without formatting), cut and delete, select all, and find and replace with case sensitive options.
Learn to use Google Docs view options, including print layout, ruler, and document outline, and master inserting section and page breaks to organize content.
Learn to create and update a table of contents using heading styles (up to six levels) and the insert tab, with page numbers or blue links.
Insert footnotes in Google Docs by selecting a word and choosing insert footnote, which automatically numbers notes for reference. Delete footnotes by removing the reference; this keeps your document clean.
Insert a horizontal line to separate content in Google Docs, then use the date option to insert today, tomorrow, or yesterday with month and year, and explore special characters.
Insert and edit images in google docs by uploading from computer or web search, adjust text wrapping, size, rotation, recolor, and transparency, and manage image placement.
Learn to create and format tables in Google Docs, insert rows and columns, merge cells for titles, and adjust alignment, width, borders, and background colors.
Learn to insert charts in Google Docs, choose bar, column, line, or pie charts, link to a Google Sheets data source, and update charts to reflect changes.
Explore the Google Docs drawing tool by creating and editing a drawing, using word art, lines, shapes, and images, then save, download, and insert the final drawing into your document.
Explore text format options in Google Docs, including bold, italic, underline, strikethrough, superscript, subscript, and change case. Learn to create columns with line and spacing controls.
Learn to use word count, display word count while typing, explore web and drive results, use the dictionary, translate documents to Hindi, and enable voice typing in Google Workspace.
Learn to add comments and citations in Google Docs, set authors and sources, and manage shared documents with titles, publishers, years, and DOIs.
Discover how to search for and install add-ons in Google Docs, choose high-rated tools like Mail Merge that work with Google Sheets and Google Docs, and grant the required permissions.
Discover how to perform mail merge in Docs with a mail merge add-on, linking a spreadsheet to personalize names, course, and qualification in bulk emails.
Explore Google Slides by starting a blank presentation and applying templates and layouts with placeholders. Insert and format text and images, manage slides, and present with shortcuts.
Master Google Slides basics by renaming and moving slides, adding text boxes, images, and shapes, formatting text, and applying backgrounds, layouts, themes, and transitions.
Explore file tab options in Google Slides, including share, new or open, download, offline access, and importing or copying slides with selective or complete copies while keeping the original theme.
Explore the view tab to switch between grid view and default slide view, adjust zoom from 50% to 200%, and toggle rulers and guides.
Learn to insert and manage audio and video in Google Slides, customize playback on click or auto, adjust volume, size, rotation, and effects, and set start times and mute.
Discover how to create diagrams in Google Slides, customize layout and text, and insert slide numbers with options to skip the title slide.
Explore format and arrange options to style text and objects in Google Docs, including text formatting, borders, rotation, text fitting, indentation, bullets, shadows, reflections, and front/back layering.
Explore slide management techniques in Google Slides: add, delete, duplicate, skip, and move slides; change background, apply layouts, adjust transitions, and switch themes to control presentation flow.
Learn to create and customize Google Forms, connect responses to Google Sheets, and configure various question types, such as short answer, multiple choice, and file uploads.
Configure Google Form settings to collect email addresses, send responders a copy, and route responses to a spreadsheet, then make the form public with anyone with the link.
Create and manage a Gmail contact group, send to the group in one go, schedule messages, and use undo send with adjustable cancellation time.
Learn how to use the grant access feature for delegate management in Gmail, enabling another user to read and send mail while you retain control and revoke access.
Learn to use action buttons for archiving, deleting, and reporting spam, and organize with snooze, labels, color-coding, and move-to options.
Learn how to forward Gmail mails to another address, verify the forwarding, choose options to keep or delete copies, and selectively move senders to the primary inbox for future messages.
Activate the vacation responder in the settings general section, set start and end dates, use the subject 'out of the office', include an urgent contact, and save changes.
Learn how to use Gmail's preview pane and split screen features to view email content without opening messages, adjust panel size, and enable keyboard shortcuts for faster emailing.
Learn how to enable and customize the Gmail starred feature by going to settings, selecting stars, and choosing which star icons appear for your emails.
Learn how to enable and use Gmail templates to save and reuse email content, create templates with subject and body, insert them in replies, and manage or delete templates.
Learn how to use Gmail filter options to automatically organize emails, search with specific criteria, apply labels, forward, delete, or categorize messages, and manage filters in settings.
Create and manage multiple Gmail signatures by going to settings, creating new signatures, naming them, and assigning them for new emails or replies. You can create any number of signatures.
Master mail merge in Google Workspace by using a template, preparing a Google Sheet with recipient and email columns, and sending personalized bulk emails with placeholders.
Enable Gmail offline in settings, general, and set seven days of synchronization to download emails and attachments for offline use. Bookmark offline access and queue sends; works in Chrome.
Explore how to create or join Google Meet meetings, share invites and a meeting code, adjust audio and video, apply backgrounds, present a window, use whiteboard, and chat with participants.
Learn how Google Drive stores and syncs files across web, desktop, and mobile, and how to upload files or folders via drag-and-drop or the upload option, with 15 GB storage.
Explore Google drive action buttons for files and folders, including share links and access options. Learn to open with, move, star, rename, make a copy, download, and delete.
Install and set up the Google Drive desktop version, sign in, and manage syncing and backups of selected folders to keep files synchronized across devices.
Learn to use Google Drive search and filters to find files by type, date modified, owner, and shared status, and organize results with location, shortcuts, and trash.
Learn to create notes and reminders in Google Keep, add images and drawings, collaborate with others, and set location-based or date-based reminders.
Create a list in Google Keep using the new list button or a note shortcut; add items like groceries and mark them purchased, then remove the list.
Organize notes with labels, assign items to multiple levels, and manage them via archive and delete, including trash and empty trash workflows. See how reminders sync across accounts and devices.
Pin important notes, set reminders, and customize note colors while using advanced search and settings to organize notes and enable collaboration in Google Workspace notes.
Explore Google Calendar's desktop and mobile interfaces as a time management tool for scheduling events, tasks, reminders, and goals.
Learn how to create calendar events with title, date, time, time zone, and optional all-day, add location, reminders, guests, and Google Meet, and manage repeats.
Learn how to create tasks and reminders in Google Calendar, set times and repetition, add descriptions, color-code entries, and view combined reminders and tasks.
Create multiple calendars, including personal and north region calendars, set time zones, then manage sharing, invitations, and access levels; export calendars as zip, shareable links, and embed options.
Add calendars from url, subscribe to calendars, and import calendars in Google Calendar. Explore sharing permissions, browse holidays in India, religion and cricket calendars, and use public iCal addresses.
Explore Google sites basics, including templates for education and small business, building a portfolio site with no coding, publishing, domain acquisition, analytics, and auto saves to Google Drive.
Master configuring the Google Sites header by editing the page title, choosing header types, adding logos or images, and adjusting fonts and alignment, then preview changes.
Learn to add and format text boxes, insert and adjust images, and embed external content in Google Workspace pages, including fonts, alignment, links, and collapsible captions.
Learn to add and customize a footer in Google Sites, including links, copyright, and contact details; configure the info button and the last updated display, and use images for readability.
Add and organize pages in Google Sites using the insert menu, create contact us and about me pages, and add external links that open in a new tab.
Explore layouts in Google Sites by building pages with headers, sections, placeholders, and images and videos, adding calendars and maps, and using dividers and previews to refine page design.
Learn to insert a Google Form into a Google Sites page to collect visitor details, and embed a map showing your institute address for easy navigation.
Build an image gallery with classroom pictures and captions on Google Sites and embed a calendar to allow students to book workshops, crash courses, or online courses.
Discover how to use placeholders for images and text, add captions and links, and build collapsible groups with a table of contents to organize content.
Explore how to embed and preview docs, sheets, slides, and charts in a website, and compare YouTube hosting for videos with Google Drive storage to optimize display and interaction.
Activate the announcement banner in settings, set the button label and link to the contact page, and display the banner at the top of the site with visibility across pages.
Explore how to apply and customize themes in Google Sites, choosing color schemes, fonts, headers, backgrounds, and navigation styles, then preview and save changes.
Learn to publish your website, choose a web address, optionally use a custom domain, and share control with others by assigning editors, while managing public visibility and updates.
Learn to restore a Google site to a previous version by date, preview changes, publish, and make a copy of the site or specific pages.
Learn to give your site a custom domain by choosing a registrar, verifying ownership via DNS, and connecting the domain in Google Sites publish settings.
Learn how to add Google Analytics to your Google Sites, create a measurement ID, and track website traffic in real time to improve performance.
Master Google Workspace (G Suite) – Gmail, Docs, Drive, Sheets, Meet & More
Learn everything you need to work smarter with Google Workspace – from basics to advanced features. Boost productivity, improve collaboration, and manage your digital tasks with confidence.
This course is a complete step-by-step training program that helps you master all the essential Google apps used in both personal and professional environments. Whether you're a beginner or looking to sharpen your skills, this course is packed with practical lessons, real-world tips, downloadable resources, and hands-on practice.
Google Workspace (formerly G Suite) is the industry-leading suite of cloud tools used by businesses, schools, freelancers, and remote teams across the world. Learn how to use Gmail, Drive, Docs, Sheets, Slides, Forms, Calendar, Meet, Sites, Keep, Tasks, and more — all in one integrated platform.
What You Will Learn:
How to use Gmail for professional communication, labels, filters, and smart email management
Schedule and manage appointments with Google Calendar and integrate it with Gmail, Meet, and Drive
Store, organize, and securely share files using Google Drive
Create and collaborate on documents in real time with Google Docs
Use Google Sheets to manage data, apply formulas, and build dashboards
Design professional presentations using Google Slides
Host virtual meetings and webinars with Google Meet
Create internal or public websites using Google Sites without writing code
Build forms, surveys, and quizzes with Google Forms and analyze responses
Stay organized with Google Keep and manage tasks across devices with Google Tasks
Why Take This Course:
Suitable for beginners and experienced users
Covers both personal and business use of Google Workspace
Includes tips, shortcuts, and best practices to work faster and smarter
Hands-on training with downloadable resources and practice files
Learn how to integrate different Google apps to automate your workflow
Ideal for office workers, virtual assistants, freelancers, students, job seekers, and remote teams
Who This Course is For:
Anyone using a Google account (personal or business)
Professionals and employees who want to improve workplace efficiency
Students, job seekers, and freelancers looking to improve digital skills
Small business owners and teams managing remote collaboration
Administrative professionals, virtual assistants, and project managers
Tools Covered:
Gmail
Google Calendar
Google Drive
Google Docs
Google Sheets
Google Slides
Google Meet
Google Forms
Google Sites
Google Keep
Google Tasks
Whether you're transitioning from Microsoft Office or starting fresh with cloud tools, this course will help you make the most of what Google Workspace has to offer.
Enroll now and start working faster, smarter, and more confidently with Google Workspace.