Google Sheets MasterClass 2026 - All Features & Benefits

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.

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 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.

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.

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

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

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

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 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 to use the text feature in the format section of Google Sheets to format data. Apply bold, italics, underline, and strikethrough to highlighted text.

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.

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.

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 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.

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