How to slugify a string with Excel

How to slugify a string with Excel

“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...
How to flip data in Excel

How to flip data in Excel

In this guide, we’re going to show you how to flip data in Excel. Download Workbook Using helper column And Sort feature Our first approach is based on using a helper column and the Sort feature. This is a quick and dirty way to flip your data in Excel. The...

10 Excel tips to increase productivity in Excel

10 Excel tips to increase productivity In this guide, we’re going to show you 10 tips to increase your Excel productivity for when working with spreadsheets. Cell styles You can change the color, font type and borders around cells. Modifying these elements can help...
How to reverse a text string in Excel

How to reverse a text string in Excel

In this guide, we’re going to show you how to reverse a text string in Excel. Download Workbook Please note that as of we are writing this article, functions like TEXTJOIN and CONCAT are available for Excel 2019 and Microsoft 365 subscribers only. Syntax CONCAT...
How to calculate median by criteria in Excel

How to calculate median by criteria in Excel

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....
How to create recursive functions in Excel

How to create recursive functions in Excel

Recursive function is a term for describing behavior of a function that calls itself from within its own code. This is necessary for solving a problem where the solution relies on the results from multiple instances of the same problem. In this guide, we’re...
Function: LAMBDA

Function: LAMBDA

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...