by Ilker | Sep 6, 2018 | Excel Tips & Tricks
One of the essential tasks when cleaning up a data set is getting rid of duplicate values. In this article, we’re going to show you how to remove duplicates in Excel using the Remove Duplicates feature. To find duplicate values using a formula please see: How...
by Ilker | Sep 6, 2018 | Excel Tips & Tricks
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...
by Ilker | Sep 5, 2018 | Excel Tips & Tricks
You can sort data easily from A to Z, or 0 to 9, in ascending or descending order. But what if you want to sort data in a different way, say starting with “Low”, then “Medium”, and “High”? In this article, we’re going to show...
by Ilker | Sep 3, 2018 | Excel Tips & Tricks
You may have noticed that Excel generates links between workbooks, when you copy and paste a formula from one to the other. These links between worksheets call the original workbook for the formula you need in the present workbook. To get rid of them, you need to...
by Ilker | Sep 3, 2018 | Excel Tips & Tricks
You may have noticed that Excel generates links between workbooks, when you copy and paste a formula from one to the other. These links between worksheets call the original workbook for the formula you need in the present workbook. To get rid of them, you need to...
by Ilker | Aug 30, 2018 | Excel Tips & Tricks
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...
by Ilker | Aug 30, 2018 | Excel Tips & Tricks
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(...
by Ilker | Jul 27, 2018 | Excel Tips & Tricks
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...
by Ilker | Jul 27, 2018 | Excel Tips & Tricks
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...
