Select Page

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

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

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 populate alphabet letters in Excel in 3 ways

You can populate numbers, names of months or weekdays easily by dragging your mouse. However, you can’t populate letters in the same fashion. In this guide, we’re going to show you how to populate Alphabet letters in Excel using three different methods....

Building a Pricing Application with Ability to Select Multiple Products through Dynamic Dropdowns

Dropdown-style user interface controls are fairly common in online forms. This type of controls help with data organization and help users enter data faster by limiting the users to a set of predetermined options. Dynamic dropdowns take the user experience one step...

How to create recursive functions in Excel with LAMBDA

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

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

How to calculate the Ackermann function in Excel

The Ackermann function, named after Wilhelm Ackermann, is a multi-variable function from natural numbers to natural numbers with a very fast rate of growth. The function relies on solving with recursive calculations. In this guide, we’re going to show you how to...