Excel
How to Filter a Chart in Excel (With Example)
Often you may want to filter a chart in Excel to only display a subset of the original data.
Fortunately this is easy to do...
Excel
Excel: How to Calculate Years Between Two Dates
You can use the following formulas to calculate the number of years between two dates in Excel:
Formula 1: Calculate Full Years Between Two Dates
=INT(YEARFRAC(A2,B2))
Formula...
Excel
How to Get First Day of Month in Excel (With Examples)
You can use one of the following formulas to get the first day of the month for a date in Excel:
Formula 1: Use DAY()...
Excel
Excel: How to Insert a Character into a String
Often you may want to insert a character into a specific position of a string in Excel.
You can use the REPLACE function with the...
Excel
How to Calculate Sample Size in Excel (With Example)
You can use the COUNTA function to calculate the sample size of a dataset in Excel.
This function uses the following basic syntax:
=COUNTA(A2:A16)
This particular formula...
Excel
Excel: Convert Decimal Time to Hours & Minutes
You can use the following formula to convert a decimal time to hours and minutes in Excel:
=TEXT(B2/24, "h:mm")
This will convert the decimal time in...
Descriptive Statistics in Excel
How to Find Y-Intercept of a Graph in Excel
The y-intercept of a graph represents the point where a line crosses the y-axis when x is equal to zero.
To find the y-intercept of...
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