Google Workspace Course – Sheets, Docs, Slide and Forms

Learn how Google Sheets differs from Excel, create and save blank sheets, organize them in Google Drive folders, and enable offline access while importing Excel files.

Master writing formulas in Google Sheets using operators like brackets, division, multiplication, addition, and subtraction, start with =, and apply BODMAS to calculate profit from sales and cost.

Learn how to use Google Sheets math functions like sum, average, count, max, min, large, and small, including nested formulas and handling of text and blanks.

Explore advanced math functions in Google Sheets, including sumif, averageif, countif and multi-criteria variants, with examples using sales above 100 across regions, cities, and employment.

Learn how wildcards work in Google Sheets, using the asterisk and question mark to shape countif criteria; count Gmail versus Yahoo emails and starting-name patterns.

Learn how to use logical operators and the IF function in Sheets, apply tests like greater than, less than, and equals, and return true/false or pass/fail outcomes.

Master nesting if functions in Google Sheets by building multiple logical tests to classify scores: below 40 yields fail, 40 to 60 yields compartment, and above 60 yields bus.

Apply the if function to determine scholarship eligibility from scores, compute scholarship amounts by multiplying scores above 70 by 1000, and flag highest and lowest scorers with pass/fail criteria.

Learn the if function in Google Sheets: if score is over 70, (score-70)*1000; else not eligible, and use max and min with absolute references to identify topper and lowest.

Learn how to use the and and or functions in Google Sheets to evaluate multiple conditions and produce true or false results, including a pass or fail example.

Master the upper, lower, proper case, sentence case, doggle case, and trim text functions in Google Sheets to format cell text, including nesting outputs and removing extra spaces.

Master left, right, and find functions in Google Sheets to extract characters from the left or right and locate starting positions of substrings, including case sensitivity and offset tricks.

Explore left, right, and find nesting techniques in Google Sheets to dynamically extract names and mobile numbers from sentences using text functions.

discover how to extract a mobile number from text in Google Sheets using the mid function with find to locate the hyphen anchor and a 10-character length.

Learn how to use the concatenate function to join text and format phone numbers by combining left, mid, and right substrings with hyphens in the desired 3-3-3 pattern.

Learn how to use the replace function in Google Sheets, with find and right, to convert six-character pin codes into a common pin code and replace with a new value.

Learn how to use substitute to replace text in Google Sheets, compare it with the replace function, and count occurrences using length and the occurrence option.

Learn to split a single column into multiple columns in Google Sheets using the split text to column tool, with automatic detection and separators like comma, space, and hyphen.

Learn to apply and customize filters in Google Sheets to isolate data by qualification and location, using text and number conditions, custom formulas, and filter views.

Learn how to use slicers to filter data by a specific column, apply sorting with proper header handling, and view column statistics to summarize data in Google Sheets.

Master conditional formatting in Google Sheets to color data by conditions, including not empty, text contains or starts with, value thresholds, and color scales.

Learn how to create, name, and manage named ranges in Google Sheets, use underscores, navigate quickly, and reference ranges in formulas and hyperlinks.

Learn to create links in Google Sheets using insert link or right-click, covering four to five link types: named ranges, cells, other sheets, external sites, and another Google sheet.

Learn how to apply data validation in Google Sheets to enforce correct entries, using rules for text, dates, lists, emails, checkboxes, and custom formulas with examples.

Learn to create pivot tables in Google Sheets, arranging data with rows, columns, values, and filters to produce quick, insightful reports.

Learn to use the vlookup function to find a name's contact number in a master sheet, handling vertical and horizontal lookups, and exact matches with false.

Learn to use iferror with vlookup in sheets to handle missing matches across multiple sheets, defaulting to no data found and retrieving data from master data.

Learn to apply hlookup for horizontal data by selecting a search key and master range, using an index, false sort order, transpose steps, and dragging results to the right.

Use the match function to locate names in a master data set and find their positions. Combine index with match to retrieve the corresponding name by contact number.

Learn how to nest match and index functions in Google Sheets to retrieve names and qualification from a dataset based on a phone number, and compare with vlookup.

Discover how to use vlookup with match to pull contacts and locations from a master data sheet, using absolute references to fix columns.

Master vlookup with true for approximate matches by using the is_sorted argument. Map score ranges like 0–39.99, 40–59.99, 60–89.99, and 90+ to grades such as pass and distinction.

Master vlookup in array form to fetch multiple columns at once by selecting the output range, using exact match, and entering with ctrl-shift-enter to create an array formula.

Apply date and time concepts in Google Sheets, mastering date formats, safe typing, and core functions such as year, month, day, date, today, now, and time.

Learn to calculate exact age and date components with datedif in Google Sheets, including years, months, and days, and master workday calculations with networkdays and networkdays.intl, including weekends and holidays.

Learn to calculate emi and analyze loan details in sheets using pmt, ppmt, ipmt, and pv, including monthly rate, periods, present value, total payable, and principal vs interest breakdown.

Learn how to record macros in Google Sheets to automate formatting tasks, choose relative references, save with a name and shortcut, and run via a button or the tools menu.

Explore how to share and protect Google Sheets, setting access by editors or viewers, and applying sheet and range protections to control who can edit or view.