Excel Functions

How to Use WEEKDAY Function in Excel (with 8 Examples)

Excel WEEKDAY Function: Syntax & Arguments Syntax =WEEKDAY(serial_number, ) Return Values 0 to 7 (in numbers) ...

How to Use Excel NETWORKDAYS.INTL Function (4 Examples)

In this guided session, we will show how you can calculate the total number of workdays between two dates using NETWORKDAYS.INTL function of Excel. ...

How to Use TODAY Function in Excel (6 Easy Examples)

  Overview of the TODAY Function Summary The TODAY function returns the current date formatted as a date. Syntax =TODAY() ...

How to Use MINUTE Function in Excel (6 Suitable Examples)

The MINUTE in Excel is a built-in function that is classified as a Date/Time function. It can be found on the Formulas tab of the Ribbon. In this ...

How to Use DATE Function in Excel (10 Ideal Examples)

The DATE function of Excel has a lot of use. We can use the function in many operations related to date. In this article, I will show the use of the ...

How to Use HOUR Function in Excel (7 Easy Examples)

Excel’s HOUR function is classified under two Excel functions which are DATE and TIME. It is one of the most popular functions in Excel in terms of ...

How to Use NETWORKDAYS Function in Excel (6 Examples)

The image below illustrates the functionality of the Excel NETWORKDAYS function. Introduction to the NETWORKDAYS Function Function ...

How to Use DATEVALUE Function in Excel (6 Suitable Examples)

DATEVALUE function in Microsoft Excel is generally used to convert a text date into the date-time number codes. In this article, you’ll get to learn ...

Most Useful and Advanced Excel Functions List

Excel has a wide variety of functions that you can utilize to accomplish a myriad of tasks. We have put a list of tutorials together on the functions ...

How to Use EDATE Function in Excel (5 Simple Examples)

While working in Microsoft Excel we often need to calculate dates. But without proper function, you won’t be able to do it. Using the EDATE function ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo