Latest Posts

How to Add Minutes to Time in Excel (5 Easy Ways)

We can put time values together to generate a cumulative time value. Since time values are only a decimal extension of the date serial numbering ...

Example of Excel Data Table (6 Criteria)

In Excel, we apply basic to complex formulas. Depending on the scenario the use of the formula’s changes. In case you have any formula dependent on ...

How to Convert Date from String Using VBA (7 Ways)

If you are looking for some of the easiest ways to convert date from string using VBA, then you are in the right place. By using a VBA code you can ...

How to Use the VBA DateAdd Function in Excel

The VBA DateAdd function is under the date and time category of Excel’s VBA functions. By using this function we can add or subtract years, months, ...

A Daily Compound Interest Calculator in Excel (Template Attached)

Compound interest generates your money to develop quickly. It makes a sum of money increase at a more rapid rate than simple interest because you ...

How to Sum Time in Excel (9 Suitable Methods)

In this article, we will demonstrate to you how to sum time in Excel. While working in Microsoft Excel, we may need to add time. To clarify the ...

How to Use Excel QUOTIENT Function (4 Suitable Examples)

Excel QUOTIENT function falls under the Math & Trig category. The function takes two arguments: numerator (i.e., dividend) and denominator (i.e., ...

Calculate Future Investment Value with Inflation, Tax and Interest Rates

If you want to calculate future investment with inflation and nominal interest rates, then there is an essential article on How to calculate future ...

How to Use PROB Function in Excel (3 Examples)

In many real-life situations in business or games, we need to predict the result or output. The PROB function in Excel is a quite useful tool to do ...

How to Use SKEW Function in Excel (2 Examples)

The SKEW function in Excel calculates the skewness of a range of data. The skewness is the deviation of the normal distribution which is a ...

Calculate Hours Between Two Times in Excel (6 Methods)

If you have two times in two different cells in Excel and want to calculate the difference in hours, then you are in the right place. We will show ...

How to Use Excel LOG Function (5 Easy Methods)

The LOG function is categorized as a Math & Trigonometry function in Excel. Besides that, it is also a worksheet function; which means it can be ...

How to Convert Date to Text YYYYMMDD (3 Quick Ways)

In Excel, the date and time are stored as numbers. This allows the user to perform calculations with these dates and times. However, you might want ...

How to Use CODE Function in Excel (5 Examples)

The CODE function, an Excel Text function returns a numeric code for the first character of a text string. The returned numeric code is based on the ...

How to Create a Data Table in Excel (7 Ways)

In this article, you will have an idea about how to create a data table in Excel easily. Creating a data table in Excel is an important feature of ...

ExcelDemy
Logo