by Ilker | Mar 19, 2021 | Excel Tips & Tricks
“Slugify” is a term for converting strings into URL slug format. A URL slug, or just slug in this article’s context, is the part of the URL that comes after the domain extension. In this guide, we’re going to show you how to slugify a string with Excel. Download...
by Ilker | Feb 17, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to run calculate median by criteria in Excel. Download Workbook To calculate median based on a criteria, you need to supply a range of values to be compared against the specific criteria defined in the MEDIAN function....
by Ilker | Feb 2, 2021 | Excel Formulas
NORMSINV Excel formula is a Statistical function that calculates the inverse of the standard normal cumulative distribution of a specific probability. The standard normal distribution is a type of normal distribution with a mean of zero (0) and a standard deviation of...
by Ilker | Jan 22, 2021 | Excel Formulas
LAMBDA is a special function that can create custom functions in the scope of a named range. You can essentially create a user defined function without any VBA, macro, or JavaScript knowledge. In this guide, we’re going to show you how to use the LAMBDA function and...
by Ilker | Jan 19, 2021 | Excel Formulas, Uncategorized
The PI function is a Math and Trigonometry formula that returns the equivalent value for the mathematical constant pi (π), which is commonly used in finding the diameter or volume of circles and spherical objects. In this guide, we’re going to show you how to use the...
by Ilker | Jan 15, 2021 | Excel Formulas
WORKDAY is a Date & Time function that can add or subtract the number of workdays from a given date. In this guide, we’re going to show you how to use the WORKDAY function and also go over some tips and error handling methods. Supported versions Excel 2007 and...
by Ilker | Jan 15, 2021 | Excel Formulas
UNICODE is a Text function that returns a corresponding numeric code of a Unicode character. Unicode is a character set, like ASCII. However, it contains characters from different languages, scripts and symbols, including ASCII characters. Each character has its own...
by Ilker | Jan 8, 2021 | Excel Formulas
The XMATCH function is a Lookup & Reference function that returns the relative position of a lookup value from a specified array or range. In this guide, we’re going to show you how to use the XMATCH function and also go over some tips and error handling methods....
by Ilker | Jan 7, 2021 | Excel Formulas
The XLOOKUP function is a Lookup & Reference function that can find values in a table or a range by row. Similar to the better-known VLOOKUP function, you can use this function to do things like looking up the name or price of a product by its code number. In this...