ExcelDemy - Page 5 of 109 - Free Excel Tutorial & Online Courses

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

Jan 10, 2022 Excel Basics

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)

Jan 13, 2022 Data Analysis with Excel

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)

Jan 10, 2022 Macros & Excel VBA

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

Jan 10, 2022 Macros & Excel VBA

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)

Jan 10, 2022 Excel Formulas

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)

Jan 13, 2022 Excel Basics

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)

Jan 10, 2022 Excel Functions

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

Jan 9, 2022 Excel for Finance 2

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)

Jan 9, 2022 Excel Functions

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)

Jan 9, 2022 Excel Functions

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)

Jan 9, 2022 Excel Basics

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)

Jan 9, 2022 Excel Functions

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)

Jan 10, 2022 Excel Basics

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)

Jan 10, 2022 Excel Functions

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)

Jan 9, 2022 Data Analysis with Excel

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

Latest Posts