Excel Functions

Practice Excel Indirect Function with 3 Case Studies

Today I want to talk about one of the most important Excel functions - INDIRECT function. Before doing that, I need to give you a brief ...

How to Use INDEX Function in Excel (6 Handy Examples)

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

How to Use VBA Input Function in Excel (2 Examples)

This article highlights how to use the VBA Input function in excel. We will use some relevant examples to illustrate the uses of this function. You ...

How to Use LARGE Function in Excel (2 Examples)

In Excel, the LARGE function is categorized as a statistical function. It can be applied to the earlier versions of Excel upto Excel 2000. Generally, ...

AND Function in MS Excel

AND Function: Overview The Microsoft Excel AND function returns TRUE if all logic is TRUE. It returns FALSE if any of the logic is FALSE. AND ...

SUMPRODUCT() function in Excel

SUMPRODUCT function: Syntax  SUMPRODUCT (array1, , , ...) SUMPRODUCT function: Example Example: =SUMPRODUCT(A2:B4, C2:D4). This example says ...

Examples of OFFSET Function in Excel (Formula+VBA ) 

  This is the If you are looking for special tricks to know about the OFFSET function with examples in Excel, you've come to the right place. ...

7 Practical Examples of VLOOKUP Function in Excel

While working with Excel, users have to deal with various Excel functions for their working purpose. These functions are mainly used for analysis or ...

How to Use COUNTIF Formula to Find Duplicates (5 Easy Ways)

Say you have a column with duplicate values. Now, you just want to find out which values are duplicate and how many times they are duplicated. In ...

ExcelDemy
Logo