Resources
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. Introduction...
How to remove all rows containing specific value in Excel
In this guide, we're going to show you how to remove all rows containing specific value in Excel. We are going to be taking a look at two methods: Find and Replace Filter These methods are good for removing all rows containing a specific value, such as repeating...
How to calculate Option Pricing using Monte Carlo Simulations in Excel
In finance, option pricing is a term used for estimating the value of an option contract using all known inputs. Monte Carlo Simulation is a popular algorithm that can generate a series of random variables with similar properties to simulate realistic inputs. In this...
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 going to...
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 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. [button...
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. ...
How to change the pressing Enter behavior in Excel
By default, pressing the Enter key in Excel on an active cell submits anything you've typed into cell and selects the cell below it. However, you can also choose to stay on the active cell or go to the next cell instead. In this guide, we're going to show you how to...
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. [button...