Excel

You can use the following formula to remove the time from a date with a time in Excel: =TEXT(DATEVALUE(TEXT(A2,”mm/dd/yyyy”)),”mm/dd/yyyy”) This particular formula…

You can use the following basic syntax to add years to a date in Excel: =DATE(YEAR(A2)+3,MONTH(A2),DAY(A2)) This particular formula adds 3 years…

You can use the following basic syntax to perform a VLOOKUP with an array formula in Excel: =VLOOKUP(E2:E8,A2:C8,3,FALSE) This particular formula will…

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

You can use the following formulas to calculate the number of weeks between two dates in Excel: Formula 1: Calculate Full Weeks…

You can use the EDATE() function in Excel to quickly add a certain number of months to a date. This formula uses…

Often you may want to sum the values of some dataset in Excel based on quarter. For example, suppose we have the…

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…