Google Sheets MasterClass 2026 - All Features & Benefits

Explore the file overview in Google Sheets, covering file management, collaboration, data entry with formulas, visualization using filters and pivots, and import and export.

Explore the new file section in Google Sheets, creating a spreadsheet or using templates from the template gallery for personal and professional use, and sharing templates with your team.

Open the file section to access recent files, My Drive, shared with me, starred items, computer-synced files, and offline uploads for quick spreadsheet access.

Import data from Google Drive into Google Sheets via the file menu, choosing to create a new spreadsheet, insert new sheets, or replace the current sheet with the imported data.

Learn to use the make a copy option in Google Sheets to duplicate the current sheet from the file menu and create a new copy for your work.

Learn to share Google Sheets from the file menu, assign access levels (editor, commenter, viewer), invite by email or link, and publish or embed the sheet on the web.

Learn to download a Google Sheets file from the file section in multiple formats, including Excel, OpenDocument, PDF, web page, CSV, and tab separated values, for offline access and sharing.

Learn to rename a sheet in Google Sheets by using the rename option in the file section, changing the sheet's name to a new one.

Learn how to email a sheet directly from Google Sheets, including entering an email address, subject, and message, and selecting file formats such as pdf, open office, or excel.

Move sheets to folders in Google Drive using the move feature in the file section, choosing an existing folder or creating a new one to shift your sheet.

Create a shortcut to a Google Sheets file in Drive from the file section by choosing a destination folder, so you can quickly access the sheet in that location.

Move to trash in Google Sheets sends sheet to Google Drive trash, where it stays 30 days, and you can take it out of trash to recover it before deletion.

Learn how to use version history in Google Sheets to name current versions, view historical sessions with timestamps in the file section, and revert data to earlier states.

Enable the make available offline feature in the file section of Google Sheets to access sheets offline and continue work without internet, then resume online when connected.

Explore the details feature in Google Sheets' file section, revealing location on drive, owner, creation and last modified dates, and how to use this information.

Discover how the settings feature in Google Sheets' file menu controls location, time zone, display language, recalculation and iterative calculation, affecting functions, dates, currency, and revision history across your workbook.

Learn to use Google Sheets' print feature from the file menu, connect to your printer, and adjust settings to print a physical copy of your sheet.

Explore the edit section in Google Sheets to add and modify data, apply formulas, format currencies, validate data, insert charts, comment, delete, collaborate, and use undo and redo for accuracy.

Discover how to use the undo feature in Google Sheets to revert actions in the edit menu, including text, formulas, and typos.

Master the redo feature in Google Sheets by repeating prior actions in the edit section, enabling quick repetition of data entry.

Master the cut feature in Google Sheets by using the edit menu to cut data from one location and paste it into another.

Master the copy feature in Google Sheets by selecting data in the edit section, copying it from a specific location, and pasting to other locations to create duplicates.

Master the paste feature in Google Sheets by copying or cutting data and pasting it to new locations within the sheet, enabling quick data relocation.

Use the delete feature in Google Sheets to remove columns, rows, or specific data by selecting the target area in the Edit menu.

Learn to use the find and replace feature in Google Sheets to search a defined area and replace matches with new data, illustrated by substituting 'online' with 'digital'.

Explore the view section in Google Sheets to switch between normal and page layout views, apply filters, sorting, conditional formatting, data validation, comments, notes, charts, and custom views.

Master the show feature in google sheets' view section to toggle the formula bar, grid lines, and visible formulas, revealing inputs and results.

Master how to use the Google Sheets freeze feature to lock specific rows and columns by selecting or dragging via the view options.

Learn to use the group feature in the view section of Google Sheets to group and hide rows or columns, and ungroup with a right-click.

Discover how to use hidden sheets in Google Sheets by hiding a sheet, locating it in the hidden sheets section under view, and unhiding it when needed.

Explore how to use the full screen feature in Google Sheets from the view menu, expanding your sheet on a laptop or computer and reverting with the escape key.

Explore how to use the cells feature in the insert section to insert new cells and shift data right or down in Google Sheets.

Learn how to insert rows in Google Sheets using the insert menu, choosing above or below a selected row. See how selecting a row enables precise data placement.

Learn to insert columns in Google Sheets by selecting data and choosing insert column left or insert column right to add new columns beside the selected range.

Add a new sheet to a Google Sheets workbook using the insert sheet option or the plus button, then manage multiple sheets within the main sheet.

Explore Google Sheets image feature in the insert menu, choosing image in cell or image over cells, and upload from PC, webcam, Drive, Google Images, or paste links.

Learn how to use the drawing feature in Google Sheets, create shapes, arrows, and equations, color them, and insert the drawings into your spreadsheet for work.

Explore how the function feature in Google Sheets' insert menu enables you to apply formulas, perform sums, averages, and max calculations on your data.

Attach links to a sheet using the insert link feature in Google Sheets. Share the sheet so collaborators can click through to resource materials and website URLs.

Learn to insert and use checkboxes in Google Sheets to mark completed tasks and visualize data, such as daily expenses, by applying checkboxes beside items.

Create a dropdown in Google Sheets from the insert section to track task status and department information, using color-coded options like work in progress, not completed, and completed.

Discover how to insert emojis in Google Sheets using the insert section, and use the emoji options to convey impactful information and denote specific data in your work.

Explore how to use smart chips in Google Sheets to insert links, emails, files, calendar events, map places, and finance information directly into your spreadsheets.

Learn how to use the comment section in the insert section of Google Sheets to add comments on cells and share contextual ideas about shared data.

Learn to use the node feature in Google Sheets insert section to add descriptive nodes, select data, and provide extra information that appears when users hover over data.

Master the format overview in Google Sheets to apply cell and text formatting, alignments, borders. Explore conditional formatting, data bars, color scales, and the format painter to enhance spreadsheets.

Explore how to apply the theme feature in the format section to style charts in Google Sheets, customizing fonts, text colors, backgrounds, and series colors.

Learn to use the text feature in the format section of Google Sheets to format data. Apply bold, italics, underline, and strikethrough to highlighted text.

Learn to use the alignment feature in Google Sheets, available in the format section and bar menu, to align data left, center, or right and vertically top, middle, or bottom.

Master the wrapping feature in the format section of Google Sheets, choosing among overflow, wrap, and clip to control how text appears in cells.

Learn to rotate text in cells using the rotation option in the format section of Google Sheets, including tilt up, tilt down, and a custom angle.

Learn to use the font size feature in Google Sheets by selecting text in the format section, then increase or decrease font size to improve readability and presentation.

Learn to merge cells in Google Sheets using the format menu, turning multiple cells into one with text, and unmerge when needed, horizontally or vertically.

Apply the alternating colors feature in the Google Sheets format section. Choose default patterns or customize your style, and define header and data legend colors.

Learn to remove all formatting with the clear formatting feature in Google Sheets, restoring data to a raw state free of colors (including alternating colors) and formulas.

Explore the data section in sheets to perform data entry, manipulation, import/export, visualization, sorting, and filtering. Learn about data validation, collaboration, add-ons, cleaning, formatting, protection, and auditing.

Use the sort sheet feature in the data section of Google Sheets to sort data in ascending or descending order (a to z or z to a).

Enable the create a filter option in the data section of Google Sheets to isolate data from a range. Apply conditions to filter and view only the information you need.

Explore filter views in google sheets to create multiple views of the same data, sorting columns ascending or descending, enabling collaborative filtering for different users.

Master how to use the data slicer in Google Sheets to filter data, create multiple slicers, and apply condition-based views such as data one with values under 6000.

Protect sheets and ranges in the data section to lock a sheet, show an edit warning, or restrict editors by adding collaborators' emails for controlled access.

Use the named ranges feature in Sheets to name a data range and apply formulas quickly, such as sum and average, using the defined range.

Master the randomized range feature in Google Sheets by selecting a data range and shuffling its contents to view data in a new random order.

Explore the column stats feature in Google Sheets to quickly analyze a selected data column, revealing count, distribution, empties, and fast calculations like sum, average, and median.

Use data validation in Google Sheets to create dropdowns (completed, not started, work in progress) with color coding, warnings for invalid data, and display options like chip, arrow, or text.

Use the split text to columns feature in Google Sheets to divide a cell's content into two columns by a chosen separator such as slash or at symbol.

Explore the tools section in Google Sheets, covering data analysis, Google Forms notifications, script editor, macros, solver, importing files, pivot tables, sheet protection, accessibility, and add-ons.

Learn to use the create a new form feature in Google Sheets' tools to build a Google form for quizzes, knowledge tests, and surveys, with responses collected in a sheet.

Explore how to use the spelling feature in Google Sheets tools to spell check content, apply corrections, and improve accuracy by testing errors and accepting changes.

Explore the Google Sheets explore feature in the tools section to gain data insights, visualize with charts, and review pivots and color options.

Explore how to configure notification settings in Google Sheets, choosing alerts for changes, form submissions, daily digests or immediate emails, and manage comment notifications for a specific email.

Enable accessibility in Google Sheets under tools to use screen reader and braille support, collaborator announcements, and a screen magnifier for enhanced sheet work.