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

 Descriptive Statistics in ExcelExcelSoftware Tutorials
How to Find YIntercept of a Graph in Excel
by Tutor AspireThe yintercept of a graph represents the point where a line crosses the yaxis when x is equal to zero. To find…
 Descriptive Statistics in ExcelExcelSoftware Tutorials
Excel: How to Use MIN Function and Exclude Zero
by Tutor AspireYou can use the following basic syntax to use the MIN function in Excel to find the minimum value in a range…
 Descriptive Statistics in ExcelExcelSoftware Tutorials
How to Calculate the Median by Group in Excel
by Tutor AspireThe following stepbystep example shows how to calculate the median value by group in Excel. Related: How to Calculate the Average by…
 Descriptive Statistics in ExcelExcelSoftware Tutorials
Excel: How to Use XLOOKUP to Return All Matches
by Tutor AspireBy default, the XLOOKUP function in Excel looks up some value in a range and returns a corresponding value only for the…
 Descriptive Statistics in ExcelExcelSoftware Tutorials
Excel: How to Use XLOOKUP with Multiple Criteria
by Tutor AspireYou can use the following XLOOKUP formula in Excel to look up cells that meet multiple criteria: =XLOOKUP(F2&G2&H2,A2:A13&B2:B13&C2:C13,D2:D13) This particular formula will…
 Descriptive Statistics in ExcelExcelSoftware Tutorials
How to Calculate Tenure in Excel (With Example)
by Tutor AspireYou can use one of the following formulas to calculate employee tenure in Excel: Formula 1: Calculate Tenure in Years and Months…
 Descriptive Statistics in ExcelExcelSoftware Tutorials
How to Calculate Year Over Year Growth in Excel
by Tutor AspireYou can use the following formula to calculate year over year (YoY) growth for some company: YoY Growth = (Current Period Revenue…
 Descriptive Statistics in ExcelExcelSoftware Tutorials
How to Calculate Percent Complete in Excel
by Tutor AspireOften you may want to calculate the completion percentage of a project in Excel. This tutorial provides two examples of how to…
 Descriptive Statistics in ExcelExcelSoftware Tutorials
Excel: How to Use Wildcard in FILTER Function
by Tutor AspireYou can use the following syntax to use wildcard characters within a FILTER function in Excel: =FILTER(A2:B12, ISNUMBER(SEARCH(“some_string”, A2:A12)), “None”) This particular…