You can use one of the following formulas to convert a date to a month and year in Google Sheets: Formula 1:…
Google Sheets
-
- Google SheetsOperations in Google SheetsSoftware Tutorials
Google Sheets: Use an IF Function with Range of Values
by Tutor AspireYou can use the following formulas to create an IF function with a range of values in Google Sheets: Method 1: Create…
- Google SheetsOperations in Google SheetsSoftware Tutorials
Google Sheets: How to Remove Grand Total from Pivot Table
by Tutor AspireThe easiest way to remove a grand total from a pivot table in Google Sheets is to uncheck the box called Show…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
How to Find Intersection of Two Lines in Google Sheets
by Tutor AspireYou can use the following formulas to find the point of intersection of two straight lines in Google Sheets: Find the X-Value…
- Google SheetsOperations in Google SheetsSoftware Tutorials
How to Escape Quotes in Google Sheets (With Example)
by Tutor AspireThere are two ways to escape quotes in formulas in Google Sheets: Method 1: Wrap Quotes Around Quotes =CONCATENATE(“”””,A2,””””) Method 2: Use…
- Google SheetsQuery Functions in Google SheetsSoftware Tutorials
Google Sheets: How to Query From Multiple Ranges
by Tutor AspireYou 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…
- Google SheetsOperations in Google SheetsSoftware Tutorials
How to Count by Month in Google Sheets
by Tutor AspireYou 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…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
How to Create and Use Variables in Google Sheets
by Tutor AspireThe easiest way to create variables that you can reference in formulas in Google Sheets is to use the Name box to…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
How to Make a Burndown Chart in Google Sheets
by Tutor AspireA burndown chart is a chart that shows the ideal “burndown” (i.e. completion) of tasks vs. the actual burndown of tasks at…
- Google SheetsOperations in Google SheetsSoftware Tutorials
How to Highlight Lowest Value in Google Sheets
by Tutor AspireYou can use the custom formula function in Google Sheets to highlight the lowest value in a range. The following example shows…