by Ilker | Sep 7, 2018 | Excel Tips & Tricks
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...
by Ilker | Sep 7, 2018 | Excel Tips & Tricks
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...
by Ilker | Sep 7, 2018 | Excel Tips & Tricks
Excel changes some numbers or strings to dates to be “user-friendly” and ease the date entering process. However, Excel does so without actually asking you, and ironically, there is no option to turn this off. In this article, we’re going to show you...
by Ilker | Sep 6, 2018 | Excel Tips & Tricks
As the number of formulas and data in your workbook increase, so will calculation times. If you’re at a point where you need to wait a while after every action, you should probably consider switching to manual calculations. In this article, we’re going to...
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...