Worksheets

5 lessons in order

Learn how to join two Google Sheets based on a column using VLOOKUP, IMPORTRANGE, QUERY, INDEX-MATCH, add-ons, and Google Apps Script.

Learn how to delete multiple sheets in Google Sheets manually, with Apps Script, or using add-ons to remove unwanted tabs efficiently.

Create a master sheet in Google Sheets using FILTER, QUERY, or IMPORTRANGE functions to combine and manage data from multiple sheets easily.

Learn how to split screen in Google Sheets by using multiple browser windows, extensions, or freezing rows and columns for easier navigation.

Learn 4 easy ways to save Google Sheets as CSV: download, publish, export with Apps Script, or copy into a text editor.