GridDojo

Google Sheets

Clear Google Sheets tutorials for everyday tasks, formulas, and collaboration — written and tested on the current version.

Google Sheets Tutorials

  • How to Make a Pivot Table in Google Sheets

    In Google Sheets, select your data, choose Insert > Pivot table, then use the editor on the right to add Rows, Columns, Values, and Filters. It summarizes thousands of rows into a clear report without a single formula. Here is the full walkthrough.

  • How to Remove Duplicates in Google Sheets

    To remove duplicates in Google Sheets, select your data and go to Data > Data cleanup > Remove duplicates. To keep your original list untouched, use the UNIQUE function instead. Here is how to do both.

  • How to Use VLOOKUP in Google Sheets

    In Google Sheets, VLOOKUP searches down the first column of a range and returns a value from another column in the same row. The syntax is =VLOOKUP(search_key, range, index, FALSE). Here is how each part works, with examples.