How to use a wildcard in Excel formula
Excel supports wildcard characters in formulas to find values that share a simple pattern. For example, if you are looking for a string with known ending or beginning, and unknown characters in the middle, you can use wildcard characters to tell Excel to...
How to calculate standard deviation in Excel
One of the fundamental operations of statistical analysis is calculating the standard deviation of a data set. In this article, we're going to show you how to calculate standard deviation in Excel using the STDEV.S and STDEV.P functions. Syntax =STDEV.S(...
How to calculate mean in Excel
Calculating the mean of numbers is one of staples of statistical analysis processes. In this article, we're going to show you how to calculate mean in Excel using the AVERAGE formula. Syntax =AVERAGE( array of numbers ) Steps Begin by creating the formula...
How to create a multi-level Excel lookup
VLOOKUP, HLOOKUP or their predecessor LOOKUP are Excel's most famous lookup functions. However, these functions can search a value only in a single dimension, meaning that you can't search horizontally and vertically. Unfortunately, there are no formulas...
How to merge cells in excel without losing data
Excel will give you a warning message telling that you will lose the data, when you try to merge cells using the Merge & Center feature. In this article, we're going to show you how to merge cells in Excel without losing your data. Steps Begin by adding...
How to create a year-by-year average calculator
Although the AVERAGEIF and AVERAGEIFS function can sum values by a given condition, they won't work if you want to use the output in other functions. In this article, we're going to show you how to create a year-by-year average calculator with help of the...
How to count cells in Excel by year
Although the COUNTIF and COUNTIFS functions can count values by a given condition, they won't work if you want to use the output in other functions. In this article, we're going to show you how to count cells in Excel by year. Syntax =SUMPRODUCT( N( YEAR(...
What week of the year is it and how to get its end date
Although Excel has a function to get week number of a date, WEEKNUM; there isn't any to make reverse calculation. This method will help you answer the question - what week of the year is it, and give you the end date of each week. Syntax =MIN(DATE(current...
What week of the year is it and how to get its start date
Although Excel has a function to get week number of a date, WEEKNUM; there isn't any to make reverse calculation. This method will help you answer the question - what week of the year is it, and give you the start date of each week. Syntax...