How to create recursive functions in Excel with LAMBDA

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...
How to calculate the Ackermann function in Excel

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...
How to unpivot data in Excel with Power Query

How to unpivot data in Excel with Power Query

How to unpivot data in Excel with Power Query Power Query is a data management tool that helps change the layout or other properties of data easily. In this guide, we’re going to show you how to unpivot data in Excel with Power Query. Download Workbook...
PI Function in Excel and Everything You Need to Know About It

PI Function in Excel and Everything You Need to Know About It

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...
How to calculate the volume of a sphere in Excel

How to calculate the volume of a sphere in Excel

In this guide, we're going to show you how to calculate the volume of a sphere in Excel. Download Workbook The formula for finding the volume of a sphere is the following: The number π is a mathematical constant defined as the ratio of a circle's circumference to its...
How to do an image lookup in Excel

How to do an image lookup in Excel

Excel’s lookup functions recently welcomed the addition of XLOOKUP and XMATCH. However, neither these new functions or the existing ones don’t support image lookup. In this guide, we’re going to show you how to make image lookup in Excel. Download Workbook...
Function: WORKDAY.INTL

Function: WORKDAY.INTL

The WORKDAY.INTL is a Date & Time function that can add or subtract the number of workdays from a given date. As the name suggests, the function is a modified version of the WORKDAY function which you can incorporate weekends and holidays in your calculations. In...
Function: UNICODE

Function: UNICODE

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...
What is the difference between XLOOKUP and VLOOKUP?

What is the difference between XLOOKUP and VLOOKUP?

In this article, we are going to show you the differences between XLOOKUP and VLOOKUP functions. Download Workbook Please note that the XLOOKUP function is currently only accessible for Microsoft 365 subscribers. XLOOKUP(lookup_value, lookup_array, return_array,...