 ## How to run macro at a specified time in Excel

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... ## 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... ## 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 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

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... ## How to use the "Pick from drop-down list" feature in Excel

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...