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 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. The...
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...
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...
How to avoid formatting change in CSV files in Excel
Data formatting can get mixed up when you open a data file with CSV format. In this article, we are going to show you how to avoid formatting change in CSV files in Excel. [button link="https://spreadsheetweb.com/wp-content/uploads/2021/01/Data.csv" type="big"...