Google Sheets

The easiest way to remove a grand total from a pivot table in Google Sheets is to uncheck the box called Show…

You can use the following formulas to find the point of intersection of two straight lines in Google Sheets: Find the X-Value…

There are two ways to calculate an average while excluding outliers in Google Sheets: 1. Use TRIMMEAN to Exclude Outliers 2. Use…

You can use the following formula in Google Sheets to check if a cell contains text from a list: =ArrayFormula(IF(LEN(A2:A13), REGEXMATCH(A2:A13,”.*(?i)(“&TEXTJOIN(“|”, TRUE,$E$2:$E$4)&”).*”)…

You can use the following formula to count the number of occurrences by month in Google Sheets: =SUMPRODUCT(1*(MONTH(A1:A10)=11)) This particular formula counts…

There are two ways to escape quotes in formulas in Google Sheets: Method 1: Wrap Quotes Around Quotes =CONCATENATE(“”””,A2,””””) Method 2: Use…

You can use the following basic syntax to query from multiple ranges in Google Sheets: =QUERY({Sheet1!A1:B10; Sheet2!A2:B5}) This particular example will return…

The easiest way to create variables that you can reference in formulas in Google Sheets is to use the Name box to…

A burndown chart is a chart that shows the ideal “burndown” (i.e. completion) of tasks vs. the actual burndown of tasks at…

You can use the custom formula function in Google Sheets to highlight the lowest value in a range. The following example shows…