Google Sheets

Google Sheets Tutorials

• How to Make a Budget in Google Sheets

  To make a budget in Google Sheets, list your income and expenses, total each with SUM, subtract to find your balance, and group spending by category with SUMIF. Here is how to build a simple, free budget from scratch.

• How to Use Conditional Formatting in Google Sheets

  Conditional formatting colors a cell automatically based on its value — to highlight, rank, or flag data. Select your cells, open Format > Conditional formatting, and set a rule. Here is how to use single-color rules, color scales, and custom formulas.

• How to Use COUNTIF in Google Sheets

  COUNTIF counts only the cells that meet a condition. The syntax is =COUNTIF(range, criterion) — like counting how many orders came from one region. Here is exactly how it works, with wildcards, counting duplicates, and COUNTIFS.

• How to Make a Drop-Down List in Google Sheets

  To make a drop-down list in Google Sheets, select the cells, open Data > Data validation, add a rule with the Dropdown criteria, and enter your options. Here is how to build, edit, and troubleshoot one.

• How to Freeze Rows and Columns in Google Sheets

  To freeze rows in Google Sheets, open the View menu, choose Freeze, and pick how many rows or columns to lock. They then stay visible as you scroll. Here is how to freeze, adjust, and unfreeze them.

• How to Use the IF Function in Google Sheets

  The IF function in Google Sheets returns one value when a condition is true and another when it is false. The syntax is =IF(condition, value_if_true, value_if_false). Here is exactly how each part works, with examples.

• How to Make a Graph in Google Sheets

  To make a graph in Google Sheets, select your data, click Insert > Chart, and pick a chart type in the Chart editor. Here is how to build it, choose the right type, and customize it — step by step.

• 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 Use the QUERY Function in Google Sheets

  QUERY pulls, filters, and sorts data with one formula using a small SQL-like language. The syntax is =QUERY(data, "SELECT A, B WHERE C > 100", 1). Here is exactly how it works, with real examples of SELECT, WHERE, and ORDER BY.

• 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 Sort and Filter Data in Google Sheets

  To sort in Google Sheets, use Data > Sort range; to filter, use Data > Create a filter and pick which rows to show. Sorting reorders your data, filtering hides rows without deleting them. Here is how to do both, step by step.

• How to Use SUMIF in Google Sheets

  SUMIF adds up numbers that meet a condition. The syntax is =SUMIF(range, criterion, sum_range) — for example, total sales for one region. Here is exactly how each part works, with examples.

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