Google Sheets Masterclass 2026 — From Beginner to Pro

Learn how to access Google Sheets by signing in with a Google account and navigating to the search page.

Navigate between Google Docs, Sheets, and Slides using the main menu, and switch your tool to Google Sheets to stay on track with this course.

Navigate the Google Sheets workspace and menu, start new spreadsheets from blank or the template gallery, and see how templates and recent spreadsheets organize your projects.

Choose the blank spreadsheet option to create your first Google Sheets project, establishing the workspace for this entire tutorial course.

Discover Google Sheets basics explained: explore the friendly workspace, understand cells, columns, and rows, and learn to scroll an endless table with unlimited rows and columns.

Learn how to add, rename, duplicate, and delete sheets in Google Sheets, starting from the default sheet, using right-click or the add sheet button, and navigate your growing workbook.

Master zooming in Google Sheets by using the zoom dropdown to set custom percentages, with a minimum 50 and the ability to reset back to 100.

Learn to enter data in Google Sheets masterclass by clicking cells, typing information such as months and expenses, and using the top bar to manage tasks.

Explore the top menu bar, the toolbar, and tabs in Google Sheets to access features not shown on the main bar.

Rename the spreadsheet by clicking the title to open the name field, type a new name, and press enter to save the change.

Learn how Google Sheets auto-saves every change to drive, removing manual saves. Explore web-based saving, automatic backups, and export options for seamless data handling.

Explore text formatting in Google Sheets, learn to select and apply changes to text within a cell, and double-click to highlight specific content for targeted edits.

select a cell and adjust font size in Google Sheets using the plus or minus buttons, or type a specific size in the dropdown and press enter, with default 10.

Change your font family in Google Sheets by selecting from the Google Fonts library in the font dropdown, choosing from available options rather than your computer's installed fonts.

Explore how to access a vast fonts library in Google Sheets, search for specific font families, and import them to your list to use in your sheets.

Learn to format text in Google Sheets by bolding selected content using the toolbar or ctrl-b shortcut, with practical steps for applying bold formatting.

Master applying italic text in Google Sheets by using the italic button or the Ctrl I shortcut, enabling quick text formatting.

Perform strike-through formatting in Google Sheets by selecting text and using the strike-through button or pressing Alt Shift five, and explore the available formatting options.

Select the text and apply color from the Google Docs editors color palette to change font colors, showing how to choose any desired hue quickly.

Apply fill colors to your selected cells to change their backgrounds in Google Sheets, choosing from various options to customize cell appearance.

Learn how to apply and customize cell borders in Google Sheets, including inner, outer, horizontal, vertical borders, and clear borders, then adjust color and style.

Learn to merge cells in Google Sheets by selecting cells and using merge options, including merge all, merge vertically, merge horizontally, and unmerge, while preserving the top-left value.

Explore horizontal alignment options in Google Sheets, choosing centralized, left, or right text alignment to control direction and layout.

Explore vertical alignment options in Google Sheets, adjusting text placement within cells from bottom to middle to top with a few clicks, and understand how alignment affects readability.

Learn how to rotate text in Google Sheets, choosing none, tilt up or down, stack vertically, or apply a custom angle like 45 degrees to enhance layouts.

Learn to insert and apply hyperlinks in Google Sheets using insert link or Ctrl K, attaching URLs to cells that stay clickable when exporting to PDF.

Explore selection basics and tips in Google Sheets, focusing on selecting a single cell and how clicking establishes the active selection in the interface.

Master selecting a range in Google Sheets by clicking and dragging to highlight cells for focused data analysis and editing.

Select a single column in Google Sheets by clicking the column letter to highlight the entire column. See how this quick method demonstrates column selection in Google Sheets.

learn how to select a single row in Google Sheets by clicking the row number, which highlights the entire row for efficient data manipulation.

Master the essential basic commands in Google Sheets, designed for beginners who want to learn the fundamentals and boost productivity with core sheet operations.

Undo and redo let you revert or reapply changes in Google Sheets, such as restoring a previous font family after a change, by tracking edits saved to the clipboard.

learn how undo works in Google Sheets by clicking the undo button or pressing Ctrl Z to step back through recent edits, restoring text and font changes as you go.

Master cut, copy, and paste to move cells in Google Sheets, using select and edit, and the cut shortcut (Ctrl+X) to relocate data precisely.

Discover how to paste in Google Sheets, explore paste and paste special options, and understand how control v moves content to another cell.

Learn how to copy in Google Sheets, create a copy or clone of selected cells, and paste to produce duplicates without moving the originals.

Master paste special in Google Sheets to copy values only, format only, or formula only, and apply conditional formatting and data validation, using keyboard shortcuts for common edits.