Excel Functions

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

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo