Excel

Often you may want to insert a character into a specific position of a string in Excel. You can use the REPLACE…

You can use the COUNTA function to calculate the sample size of a dataset in Excel. This function uses the following basic…

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 y-intercept of a graph represents the point where a line crosses the y-axis when x is equal to zero. To find…

Often you may want to create a graph in Excel that allows you to visualize the correlation between two variables. This tutorial…

There are two common ways to create a graph with three variables in Excel: 1. Create a Line Graph with Three Lines…

Often you may want to convert minutes to hours and minutes in Excel. Fortunately this is easy to do and the following…

You can use the following basic syntax to use the MIN function in Excel to find the minimum value in a range…

The following step-by-step example shows how to calculate the median value by group in Excel. Related: How to Calculate the Average by…

Often you may want to connect the points in a scatter plot in Excel. Fortunately this is easy to do and the…