Excel Functions

Comparison Among MAX vs MAXA vs LARGE and MIN vs MINA vs SMALL Functions in Excel

In our day-to-day life, we feel the necessity of finding the highest value as well as the lowest value. We even need to find out a specifically ...

How to Use CEILING.MATH and FLOOR.MATH Functions in Excel

The CEILING.MATH function is a new function that we can see in Microsoft Excel 2013 and later versions. The CEILING.MATH function rounds a specified ...

NOW vs TODAY Functions in Excel (3 Practical Examples)

While working in an Excel spreadsheet, you may have a good thought about the Excel NOW vs TODAY Function. The TODAY Function is used to determine the ...

How to Use INDEX MATCH with Excel VBA

You can utilize the built-in Excel Worksheet functions such as the VLOOKUP Function, the CHOOSE Function and the PMT Function in your VBA code and ...

How to Use MIRR Function in Excel (3 Quick Examples)

In Microsoft Excel, the MIRR function estimates the likely profitability of an investment or project. In this article, you’ll learn how to use MIRR ...

How to Use RRI Function in Excel (5 Suitable Examples)

This article is all about the RRI function of Excel. We will look at how to calculate the equivalent interest rate for the growth of an investment. ...

How to Use the CONVERT Function to Calculate BMI in Excel

BMI is a common word for health-conscious people. Now, people are becoming more careful about their health. BMI is one of the commonly known ...

How to Use Excel Database Functions DGET, DAVERAGE, & DMAX

The Excel database functions are designed to help one retrieve relevant information from large sets of data stored in Excel. There are twelve ...

DGET vs VLOOKUP in Excel (7 Differences)

Microsoft Excel provides efficient functions that allow one to search for and look up data. We will compare Excel DGET vs. VLOOKUP functions of the ...

How to Use IF Function with Multiple Conditions in Excel

We have already seen, how to use the IF function in basic Excel formulas. Using the IF with other functions together, in a complex formula, allows ...

How to Use the Format Function in Excel (With Suitable Examples)

Note: All the operations of this article are accomplished by using the Microsoft Office 365 application. Example 1 – Formatting ...

5 Examples of Using Array Formula in Excel

If you are a regular user of Excel, you most likely know about the array formula in Excel. Also, you could be aware of this, array formulas lessen ...

How to Use INDEX Function in Excel?

The INDEX function is one of the top used 10 Excel functions. In this tutorial, you will get a complete idea of how the INDEX function works in Excel ...

102 Useful Excel Formulas Cheat Sheet PDF (Free Download Sheet)

If you want to be a power user of MS Excel, you must master the most useful Excel formulas of Excel. To be frank, it is not an easy task for all as ...

How to Use VBA Asc Function (5 Practical Examples)

In this article, we will discuss Excel VBA Asc Function. It is a convenient tool. I hope you will find the article interesting and can increase your ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo