Google Sheets Masterclass 2026

Learn how to merge and unmerge cells in Google Sheets to manage large data sets, understand how merged ranges affect formulas, and apply the merge cells feature with simple steps.

Learn to protect a specific range in Google Sheets to prevent edits, set per range permissions, and use edit warnings, ensuring price data remains secure while others collaborate.

Protect an entire Google Sheets sheet while permitting edits only in specific cells, using protected ranges and warnings, with a data-entry sheet where only part ID is editable.

Learn to manage Google Sheets by adding, renaming, duplicating, deleting, and moving sheet tabs; copy to new spreadsheets, color-code tabs, and set permissions to protect or unprotect sheets.

Master formula basics in Google Sheets by creating tax calculations, applying addition, subtraction, and multiplication, and summing columns with autofill and range references.

Generate random data in Google Sheets using the randbetween function within a mock sheet. Convert formulas to fixed values to prevent refresh changes, and drag to fill across cells.

Remove formulas in Google Sheets and keep values by pasting special values, using an example of random numbers between 35 and 95, and verify by checking the formula bar.

Explore how to perform sum, division, and multiplication in Google Sheets, create a multiplicative table, calculate percentages from marks, and format results with controlled decimal places.

Master nested formulas in Google Sheets to compute price after discount in a single column, by combining sales, text rate, and discount with absolute and relative references.

Master absolute and relative references in Google Sheets, fixing cells to build nested calculations with text rate and discount percent. Use F4 to fix references and cell names for readability.

learn to perform quick calculations in google sheets using quick functions to see sums, averages, minima, maxima, and counts by selecting ranges for instant results.

Learn how to use if conditions and logical expressions in Google Sheets with a simple pass/fail example, including generating random scores with randbetween and converting formulas to values only.

Learn to perform basic calculations in Google Sheets using simple formulas for sum, count, counta, average, max, and min, including full column references and handling text data.

Apply conditional functions in Google Sheets to sum, count, and average with sumif, countif, and averageif, using criteria like pass or fail to analyze student marks and percentages.

Explore rounding down, rounding up, and rounding to the nearest decimal places in sheets, using floor and ceiling functions to format prices after discount.

Master the basics of vlookup in google sheets to search by employee id or name, extract exact salaries from a table using range, index, and exact match.

Master data validation in Google Sheets to create dynamic drop-down lists from a range, use named ranges, and drive VLOOKUP results with auto-suggest and error prevention.

Remove duplicates in Google Sheets to keep only unique values using data cleanup, and apply this to create a unique department list while clarifying VLOOKUP's first-match behavior.

Learn how to use vlookup with approximate match to pull salary-based grades from another sheet, including naming ranges for cross-sheet referencing and auto-fill.

Explore comprehensive formatting techniques in Google Sheets masterclass 2026, including number, date, currency, and time formats, region settings, and custom currencies, plus converting to tables, dropdowns, and using format painter.

Master conditional formatting in Google Sheets by applying rules for pass and fail with green and red highlights, and use text, number, and date conditions.

Learn to insert images in Google Sheets, paste images directly, resize from corners, and place images in cells while adding links, checkboxes, and cell insertions.

Import an Excel file into Google Sheets by uploading from your computer, then import and replace the current spreadsheet, adjust formatting, and rename the file for easy sharing.

Learn how to share a Google Sheet via a link for anyone to view or edit, and download it as Excel to practice pivot tables in the next video.

Master pivot tables in Google Sheets to summarize sales data by month, year, and region, using drag-and-drop fields like date, region, and sales amount, with grouping and drill-down capabilities.

Learn to create and customize pivot table reports in Google Sheets, including month-wise and quarter-wise sales, year-based grouping, and region-wise contributions.

Learn how to create and customize charts in Google Sheets from real sales data, including line, pie, bar, and stacked charts, with pivot date group, axis adjustments, and chart management.

Create interactive dashboards in Google Sheets to visualize and summarize sales data. Analyze by region and item with charts, scorecards, line charts, and slicers.

Master filtering data in Google Sheets with slicers, creating interactive region and salesperson buttons, and customizing colors to filter by Great Lakes or specific staff.

Learn to apply filters and sorts in Google Sheets, including creating filters from headings, managing slicers, using conditions and date filters, and ensuring all data moves with sorting.

Explore the Google Sheets toolbar and menu bar, templates, sharing, exporting formats, and version history. Learn formatting and data tools such as undo/redo, borders, currency, and validation.

Learn how to share Google Sheets with collaborators, set editors, viewers, or commenters, and manage access via link sharing and on sheet comments.