by Ilker | Feb 4, 2021 | Excel Tips & Tricks
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...
by Ilker | Feb 2, 2021 | Excel Tips & Tricks
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...
by Ilker | Jan 28, 2021 | Excel Tips & Tricks
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...
by Ilker | Jan 21, 2021 | Excel Tips & Tricks
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...
by Ilker | Jan 20, 2021 | Excel Tips & Tricks
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...
by Ilker | Jan 19, 2021 | Excel Tips & Tricks
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...
by Ilker | Jan 19, 2021 | Excel Tips & Tricks
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...
by Ilker | Jan 18, 2021 | Excel Tips & Tricks
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...
by Ilker | Jan 12, 2021 | Excel Tips & Tricks
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,...
