Excel Functions

How to Use COLUMN Function in Excel?

Sometimes we may need to figure out or determine the column number of any specific cell. For this purpose, Excel provides a function named COLUMN. ...

How to Use the AND Function in Excel – 7 Examples

This is an overview.   Introduction to the AND Function Function Objective: Checks all arguments and returns TRUE if all ...

How to Use the OR Function in Excel – 4 Examples

Thr Excel OR Function The OR function tests conditions and returns a boolean value. Objective Checks whether the arguments are TRUE, and ...

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

The TRUE function has a special type of compatibility in returning results based on logical conditions. TRUE Function in Excel (Quick View) ...

How to Use DATEDIF Function in Excel (2 Ideal Examples)

DATEDIF is one of the most used Excel functions. In this article, you’ll learn how you can use this DATEDIF function efficiently with different ...

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

The FALSE function in Excel is one of the logical functions in Excel which gives FALSE as output. Using this function, we can declare the cell value ...

How to Use WORKDAY Function in Excel: 7 Suitable Methods

Method 1 - Generate a Sequence of Workdays Generate a sequence of workdays using the WORKDAY function. The following are the steps to do that. ...

How to Use WORKDAY.INTL Function in Excel (3 Suitable Examples)

In Microsoft Excel, WORKDAY.INTL function is used to find the next working day while taking into consideration all weekends and holidays. In this ...

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 the NOW Function in Excel (8 Suitable Examples)

In Microsoft Excel, the NOW function is used to show timestamps. By enclosing the NOW function inside other related functions, different useful ...

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

Here's an overview of the NETWORKDAYS.INTL function with different settings. Excel NETWORKDAYS.INTL Function: Syntax & Arguments ...

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 SECOND Function in Excel (3 Suitable Examples)

Excel provides various functions to maximize and speed up your productivity. Today we are going to show you how to use the Excel SECOND function by ...

How to Use the MINUTE Function in Excel – 6 Examples

The Excel MINUTE Function Summary The MINUTE function returns the number of minutes in a given time value. For example, if the time value ...

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

  Introduction to the DATE Function Function Objective: The DATE function creates a date from numeric values in the arguments. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo