Excel Functions

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

MS Excel provides a most useful function namely the SUM function for summation purposes. Formula with this function automatically updates with the ...

How to Use HLOOKUP Function in Excel?

In Microsoft Excel, HLOOKUP or Horizontal Lookup function is generally used to extract data from a table or an array based on searching for a ...

How to Use INT Function in Excel (8 Suitable Examples)

When you have a decimal number in your dataset, you can use the INT function in Excel to get the nearest integer. Basically, we will discuss in this ...

How to Use VLOOKUP Function in Excel (8 Suitable Examples)

  VLOOKUP Function of Excel (Quick View) The following image is a quick view of Excel VLOOKUP: Introduction to Excel VLOOKUP ...

How to Use FILTER Function in Excel?

Introduction to the FILTER Function in Excel Function Objective: Filter some particular cells or values according to our requirements. Syntax: ...

How to Use INDIRECT Function in Excel?

In this article, you will learn everything about the INDIRECT function in Excel. You will see the uses of the INDIRECT function and how you can use ...

How to Use IFERROR Function in Excel (4 Practical Examples)

In this tutorial, I am going to show you 4 practical examples of how to use the IFERROR function in Excel. You can use these methods even in large ...

How to Use ROW Function in Excel?

When you have a tiny dataset, it’s easy to find the row number, but in the case of a larger dataset, you may have to use the ROW function. In this ...

How to Use OFFSET Function in Excel?

Microsoft Excel provides various functions to maximize and speed up your productivity. Today, I will be showing how you can extract a particular ...

How to Use ROWS Function in Excel?

The ROWS function is a popular Excel built-in function that can be categorized under the LOOKUP and REFERENCE Functions. This function returns the ...

How to Use IF Function in Excel (8 Suitable Examples)

Here's an overview of how the IF function can be used to put values into the Status column depending on the data in other cells. ...

How to Use NOT Function in Excel (8 Useful Examples)

The NOT function in Excel returns a logically opposite value. In this article, you’ll learn to use this function and also discuss its application ...

How to Use IFS Function in Excel (3 Examples)

While working in Microsoft Excel, there are various formulas to make our work easier. The IFS formula is one of them. It has a wide range of ...

How to Use AND Function in Excel (7 Suitable Examples)

In Microsoft Excel, AND is one of the most frequently used functions and the AND function is applied to check for logical tests under different ...

How to Use OR Function in Excel (4 Ideal Examples)

Fortunately, there are a number of functions in Excel to perform various logical operations easily and swiftly. Today we are going to show you how to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo