by Ilker | Apr 24, 2019 | Excel Formulas
The Excel SMALL function is a Statistical formula that returns the smallest value in an array or a range. In this guide, we’re going to show you how to use the Excel SMALL function and also go over some tips and error handling methods. Supported versionsAll Excel...
by Ilker | Apr 19, 2019 | Excel Formulas, Excel Tips & Tricks
Filtering data helps focusing on certain aspects of a data set. Excel has built-in features for this, an Excel formula for filtering data was not in the software’s scope until the introduction of dynamic array functions. In this guide, we’re going to show you...
by Ilker | Apr 18, 2019 | Excel Tips & Tricks
The Excel CLEAN function is a Text formula that removes “non-printable” characters from a text string. The function is especially useful for eliminating unsupported characters from a text that was imported from an external source. In this guide, we’re...
by Ilker | Apr 17, 2019 | Excel Formulas
The Excel TRIM function is a Text formula which can remove the leading and trailing sections of a text string, and replace extra spaces between words with one. As the name suggests, the formula essentially “trims” the extra spaces in the target string, and...
by Ilker | Apr 17, 2019 | Excel Formulas
The Excel LEN function is a Text formula that returns the number of characters in a given string. In this guide, we’re going to show you how to use the Excel LEN function and also go over some tips and error handling methods. Supported versionsAll Excel versionsExcel...
by Ilker | Apr 15, 2019 | Excel Formulas, Excel Tips & Tricks
How to generate random numbers in ExcelYou can generate decimals between 0 and 1, and integers between certain limits using the RAND and RANDBETWEEN functions. RANDARRAY function is a new addition to randomization formulas, which is currently only available to a...
by Ilker | Apr 11, 2019 | Excel Tips & Tricks
The AutoCorrect is an essential feature which is designed to correct typos automatically. This feature is also helpful for changing abbreviations to full versions, adding symbols, or correcting grammar errors, but it can also sometimes do things in a way that...
by Ilker | Apr 10, 2019 | Excel Formulas
The Excel CODE function is a Text formula that converts a specified character into the corresponding code based on the character set used by your computer. This can be useful for when you want to find out the code for a specific character, or using this value in other...
by Ilker | Apr 9, 2019 | Excel Formulas
The Excel CHAR formula is a Text function that returns a character, based on the character set used by your computer. In this guide, we’re going to show you how to use the Excel CHAR function and also go over some tips and error handling methods. Supported versionsAll...
