by Ilker | May 21, 2019 | Excel Formulas

The FLOOR MATH (FLOOR.MATH) function is a Math formula that rounds a given number down to the nearest multiple of significance. This function was released in Excel 2013 as a replacement for the FLOOR function. In this guide, we’re going to show you how to use the...
by Ilker | May 16, 2019 | Excel Formulas

The Excel INT function is a Math formula that rounds a given number down to the nearest integer. Although, it is similar to the TRUNC function, they work differently when working with negative numbers. In this guide, we’re going to show you how to use the INT function...
by Ilker | May 16, 2019 | Excel Formulas

The Excel TRUNC function is a Math formula that truncates a given number by removing a number of digits. Although, it is similar to the INT function, the TRUNC function works differently when truncating negative numbers. In this guide, we’re going to show you how to...
by Ilker | May 15, 2019 | Excel Formulas

The Excel COUNTBLANK function is a Statistical formula that counts the empty cells in a given range. It can be especially useful in data analysis and organization tasks, where you need to find out any errors or fields that require attention. In this guide, we’re going...
by Ilker | May 15, 2019 | Excel Formulas

REPT is a Text function that repeats a string a given number of times. It is useful for filling a cell or fixed length of strings, as well as creating simple histograms. In this guide, we’re going to show you how to use REPT function and also go over some tips and...
by Ilker | May 14, 2019 | Excel Formulas, Excel Tips & Tricks

Sorting data can substantially help organizing data and generating reports. In Excel, you can sort data with a single click using the Sort icons under the DATA tab. However, this is a permanent solution, meaning that the sorted data will remain that way, and you will...
by Ilker | May 9, 2019 | Excel Formulas

The MEDIAN Excel function is a Math formula that calculates and returns the median of the selected values. The median in statistics represents the middle value in a dataset. In this guide, we’re going to show you how to use the Excel MEDIAN function and also go over...
by Ilker | May 9, 2019 | Excel Formulas

The TRANSPOSE Excel function is a Lookup & Reference formula that rotates a given range or array. Since the output of this formula is an array, you need to press the Ctrl + Shift + Enter (CSE) key instead of just pressing the Enter key when entering this function....
by Ilker | May 7, 2019 | Excel Formulas

The CONCATENATE Excel function is a Text formula that joins multiple strings together. You can enter static strings and individual cell references. In this guide, we’re going to show you how to use the CONCATENATE Excel function and also throw in some tips and error...