Google Sheets
How to Create and Use Variables in Google Sheets
The easiest way to create variables that you can reference in formulas in Google Sheets is to use the Name box to give custom...
Google Sheets
How to Make a Burndown Chart in Google Sheets
A burndown chart is a chart that shows the ideal “burndown” (i.e. completion) of tasks vs. the actual burndown of tasks at some company.
This...
Google Sheets
How to Highlight Lowest Value in Google Sheets
You can use the custom formula function in Google Sheets to highlight the lowest value in a range.
The following example shows how to use...
Google Sheets
How to Highlight Highest Value in Google Sheets
You can use the custom formula function in Google Sheets to highlight the highest value in a range.
The following example shows how to use...
Google Sheets
How to Find the Slope of a Trendline in Google Sheets
The slope of a trendline represents the average increase in the y-value for a one unit increase in the x-value.
To find the slope of...
Google Sheets
Google Sheets: Generate Number of Days in a Month
You can use the following basic formula to generate the number of days in a month in Google Sheets:
=DAY(EOMONTH(A2,0))
This particular formula calculates the number...
Google Sheets
How to Calculate Average by Group in Google Sheets
The following step-by-step example shows how to calculate the average value by group in Google Sheets.
Example: Calculate Average by Group in Google Sheets
First, let’s...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read