by Ilker | Feb 17, 2021 | Excel Tips & Tricks
With Application.OnTime method, you can set Excel to run some VBA at a specific time, or repeatedly at set intervals. In this guide, we're going to show you how to run macro at a specified time in Excel. Download Workbook Application.OnTime VBA’s Application.OnTime...
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 22, 2021 | Excel Formulas
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...
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 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 circumference to its...
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 | Dec 21, 2020 | Excel Tips & Tricks
Dropdown lists are a common example of data validation used in organizing data input. In this article, we are going to show you how to use pick from drop-down list feature in Excel. Download Workbook The “Pick from drop-down list” feature generates a...
by Ilker | Nov 20, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to change case in Excel using different methods. Download Workbook Unlike in Word, Excel doesn’t have any built-in features that can help modify the text case. However, some of the methods we will be looking at in...