by Ilker | Feb 15, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to fill blank cells simultaneously in Excel. Download Workbook How to locate blank cells Begin by selecting your data, including the blank cells Open the Go To Special dialog by following Home > Find & Select...
by Ilker | Feb 12, 2021 | Excel Tips & Tricks
Excel’s number formatting doesn’t support file sizes by default. However, it allows you to program your own formatting style. In this guide, we’re going to show you how to format numbers as file sizes in Excel. Download Workbook The number formatting is one the...
by Ilker | Feb 11, 2021 | Excel Tips & Tricks
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....
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...