Excel doesn't have a direct way of inputting time duration. In this article, I will show you how to input time in Excel quickly.
Read More
Categories
Recent Posts
Tags
.
activate
activate excel sheet
advanced excel skills
binomial option pricing model
binomial tree
button
change number format
Check
conditional formatting
count cells without errors
Date
define name
Excel
excel tips
expand collapse pivot table shortcuts
finance
find and replace
Find date
font size
generate random dates
increase decrease font size
Insert VBA code
jump to cell
left
left mid right
mid
name range
Navigation
number formatting
option
option price
pivot table
pivot table details
pivot table expand rows
pivot table shortcuts
pivot table tricks
productivity
quantitative finance
RANDBETWEEN
right
Sheet exist
sort and filter
sumproduct
Text function array
VBA 101
What's new
How to Remove Bullets/Numberings in Excel
In this article, I will show you how to remove bullet points or numberings in Excel.
Read More
How to Generate Random Numbers with Decimals
In this article, I will show you how to get random numbers with decimals in Excel. There are 3 formulae of your choice to cope with different situation.
Read More
How to Stack Multiple Columns into One Column
I will show you how to stack multiple columns into one single vertical column, from up to down and from left to right.
Read More
How to Delete Row if cell in certain column is Blank? Excel
In this article, I will show you how to delete rows if cell in certain column is blank. It doesn't matter if your workbook contains hundreds of worksheets.
Read More
How to Mass Delete hidden rows/ columns in Excel
In this article, I will show you how to delete hidden rows in Excel at a few clicks. It doesn't matter if your workbook contains hundreds of worksheets.
Read More
How to Input Time Duration in Excel
Gladys from Dollar Excel
August 17, 2022
Excel doesn’t have a direct way of inputting time duration. In this article, I will show you how to input time in Excel quickly.
How to Generate Random Numbers with Decimals
Gladys from Dollar Excel
July 22, 2022
In this article, I will show you how to get random numbers with decimals in Excel. There are 3 formulae of your choice to cope with different situation.
How to Stack Multiple Columns into One Column
Gladys from Dollar Excel
July 12, 2022
I will show you how to stack multiple columns into one single vertical column, from up to down and from left to right.
How to Delete Row if cell in certain column is Blank? Excel
Gladys from Dollar Excel
July 4, 2022
In this article, I will show you how to delete rows if cell in certain column is blank. It doesn’t matter if your workbook contains hundreds of worksheets.
How to Mass Delete hidden rows/ columns in Excel
Gladys from Dollar Excel
June 24, 2022
In this article, I will show you how to delete hidden rows in Excel at a few clicks. It doesn’t matter if your workbook contains hundreds of worksheets.
Excel Split Long Text into Short Cell Without Splitting Word
Gladys from Dollar Excel
May 10, 2022
I will show you how to split long text into shorter cells without splitting word. This allows you to select the length of the end result.
How to Insert Every Other Row or Every Nth Row
Gladys from Dollar Excel
May 3, 2022
I will show you how to insert every other row or every nth row in Excel. I assure you this tutorial will save you lots of effort.
7 uses of SHIFT key in Excel blows your mind
Gladys from Dollar Excel
June 28, 2021
In this article, I will show you 7 uses of SHIFT key. I assure that your productivity won’t be the same after you finish reading this.
How to Delete Every Other Row or Every Nth Row
Gladys from Dollar Excel
June 20, 2021
In this article, I will show you how to delete every other row or every nth row in Excel. I assure you this tutorial will save you lots of effort.
7 uses of Ctrl E – Best Excel shortcut Ever
Gladys from Dollar Excel
June 19, 2021
In this article, I am going to show you 7 ways of using Ctrl E in Excel. I am sure you will be the most productive employee in the office after watching this.
How to Fill Sequential Data Quickly in Excel
Gladys from Dollar Excel
June 2, 2021
In this article, I will show you how to fill linear and growth sequence by fill command and fill handle. This will save you a lot of time.
How to copy data from multiple sheets at once
Gladys from Dollar Excel
April 15, 2021
In this article, I will show you how to copy data from different sheets and paste them at once by using the clipboard.
How to Input Time Duration in Excel
Gladys from Dollar Excel
August 17, 2022
Excel doesn’t have a direct way of inputting time duration. In this article, I will show you how to input time in Excel quickly.
How to Remove Bullets/Numberings in Excel
Gladys from Dollar Excel
July 28, 2022
In this article, I will show you how to remove bullet points or numberings in Excel.
How to Stack Multiple Columns into One Column
Gladys from Dollar Excel
July 12, 2022
I will show you how to stack multiple columns into one single vertical column, from up to down and from left to right.
How to Delete Row if cell in certain column is Blank? Excel
Gladys from Dollar Excel
July 4, 2022
In this article, I will show you how to delete rows if cell in certain column is blank. It doesn’t matter if your workbook contains hundreds of worksheets.
How to Mass Delete hidden rows/ columns in Excel
Gladys from Dollar Excel
June 24, 2022
In this article, I will show you how to delete hidden rows in Excel at a few clicks. It doesn’t matter if your workbook contains hundreds of worksheets.
How to Display Blank when Referencing Blank Cell
Gladys from Dollar Excel
March 30, 2022
In this article, I will show you how to display blank when referencing blank cell in Excel. I will provide you with 4 ways to achieve the result.
How to highlight current row and column in Excel?
Gladys from Dollar Excel
July 8, 2021
In this article, I will show you how to highlight current row and column in Excel by changing the number format of cell.
How to Fill Sequential Data Quickly in Excel
Gladys from Dollar Excel
June 2, 2021
In this article, I will show you how to fill linear and growth sequence by fill command and fill handle. This will save you a lot of time.
How to Apply Serial Number After Filter in Excel?
Gladys from Dollar Excel
May 24, 2021
In this article, I will show you two ways to apply serial number after filter. The first way is to add a new column of serial number and the second way is to make the serial number renumber automatically.
How to prevent duplicate entries in Excel?
Gladys from Dollar Excel
April 23, 2021
Duplicates sometimes can be a bad thing which lead to mistakes and wrong calculation. In this article, I will show you how to set a no duplicates rule to cells.
How to get distinct values in Excel? (6 ways)
Gladys from Dollar Excel
April 19, 2021
I will show you 6 different ways to get distinct values in Excel. “Remove duplicates”, “Advanced filter”, “Function”, “Formula”, “Pivot table” and “VBA”.
How to copy data from multiple sheets at once
Gladys from Dollar Excel
April 15, 2021
In this article, I will show you how to copy data from different sheets and paste them at once by using the clipboard.
Value-at-Risk (VaR)| Risk Management in Excel
Gladys from Dollar Excel
February 17, 2021
Value-at-Risk (VaR) is an important heavy-tail metric for financial portfolio. Let’s learn about historical/parametric approach of VaR calculations, and 4 different ways to present VaR.
Binomial Option Pricing (Excel formula)
Gladys from Dollar Excel
January 6, 2021
Option pricing is a heated topic in quantitative finance, and let’s explore how we can use the binomial option pricing model in Excel to compute option price!
How to Compute IRR in Excel (Basic to Advanced)
Gladys from Dollar Excel
December 22, 2020
Excel comes with great tools to compute the IRR on an investment. We are going to show you 3 methods in computing IRR and their limitations.
Black-Scholes Option Pricing (Excel formula)
Gladys from Dollar Excel
December 22, 2020
Black-Scholes option pricing is one of the landmarks for quantitative finance. Let’s learn about the intuition and apply it to price options in Excel!
Binomial Option Pricing (Excel VBA)
Gladys from Dollar Excel
December 17, 2020
Using the Excel VBA code presented, we can easily create a multi-period binomial tree to price European options with great flexibility and tweaking parameters.
…
