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

How to Use NPV Function in Excel (3 Easy Examples)

Jan 11, 2022 Excel Functions

The NPV Function is an Excel Financial function that calculates the Net Present Value (NPV) for a series of cash flows and a given discount rate. The ...

How to Calculate Hours and Minutes for Payroll Excel (7 Easy Ways)

Jan 12, 2022 Excel Basics

Often, we need to calculate time differences in Excel. In this article, we demonstrate ways to calculate hours and minutes for payroll in Excel. ...

How to Use COUNTIF Between Two Numbers (4 Methods)

Jan 11, 2022 Excel Basics

Sometimes while working in Microsoft Excel we need to count cells between two numbers. We can do this with the COUNTIF function. The COUNTIF function ...

How to Calculate Interest on a Loan in Excel (5 Methods)

Jan 11, 2022 Excel Formulas

While working with borrowed loans, we have to calculate the amount of interest or capital that we have to pay for that loan. We can easily calculate ...

How to Calculate Moving Average in Excel (4 Examples)

Jan 10, 2022 Excel Basics

The Moving Average is also known as the Rolling Average or Running Average in Excel. In this article, we will show you how to calculate the moving ...

How to Use the Mid Function of VBA in Excel (3 Examples)

Jan 10, 2022 Macros & Excel VBA

One of the most important and widely used functions that we use while working with VBA in Excel is the Mid function of VBA. It takes a string as the ...

How to Change Time Format in Excel (4 Ways)

Jan 13, 2022 Excel Basics

Microsoft Excel offers a variety of time-saving tools, and understanding them can save you a lot of time. In order to specify precise information, ...

Scenario Analysis in Excel: A Guide with 2 Sample Cases + Template

Jan 11, 2022 Data Analysis with Excel

In Microsoft Excel, analyzing scenarios is one of the crucial tasks. We consider it as a part of data analysis. Scenario analysis means comparing ...

How to Use MODE Function in Excel (4 Examples)

Jan 13, 2022 Excel Functions

The MODE function, an Excel Statistical function returns the most frequently occurring number from an array or set of numbers. MODE.SNGL function ...

Formula for Monthly Compound Interest in Excel (With 3 Examples)

Jan 13, 2022 Excel Formulas

Calculating interest is a common task in banking, NGOs, and other financial organizations. We can do it very quickly and easily in Excel by using ...

How to Use Excel PMT Function (4 Quick Examples)

Jan 10, 2022 Excel Functions

The PMT function is a Financial function in excel. Interestingly, the name PMT stands for ‘payment’. We can use this function to get the periodic ...

How to Get the Day of Week Using VBA (4 Suitable Methods)

Jan 11, 2022 Macros & Excel VBA

The day of the week becomes worthwhile for planning, scheduling, and even financial analysis. In a previous article, I discussed how to use the ...

How to Copy Formula to Entire Column in Excel (7 Ways)

Jan 13, 2022 Excel Basics

To copy formulas in Excel is one of the easiest works. Microsoft Excel offers many ways to do the same work and in this article, we’ll get to learn ...

How to Use VAR Function in Excel (4 Examples)

Jan 10, 2022 Excel Functions

The Excel VAR function is categorized as a Statistical function of Microsoft Excel. It determines the risk of any investment, hence, is important for ...

Simple Interest Formula in Excel (With 3 Practical Examples)

Jan 10, 2022 Excel Formulas

Whether you run your own business or manage your personal finance, or do corporate jobs, Simple Interest (SI) is an important topic for you. You can ...

Latest Posts