How to use DCOUNTA Function in Excel

DCOUNTA function is an important built-in-function of MS Excel. The DCOUNTA function is used to quickly counts non-blank cells within given database. DCOUNTA is a standard built-in-function which is located in Database category in Microsoft Excel. Read More

How to link data between two or more workbook in Excel

Copying data from one workbook and paste to another workbook is an easy task. But copy and paste method doesn’t create a relationship between the source and target file data. You must have to know how could you link data between two or more workbook in Excel. You can easily establish, refresh, remove the link either between two or more workbook or worksheets as per your need. Read More

How to use the Excel AVERAGEIF function

In this guide we have to discuss how could you easily calculate the arithmetic mean of different data types with the help of Excel AVERAGEIF function. The AVERAGEIF function in Excel is used to returns the average (arithmetic mean) of all the cells with in the range which meet the given criteria. Read More

How to use the Match function in Excel

he MATCH function in Excel allows you to quickly locate for a specified item in range of cells, and then returns the relative position of that item in the range. Match Excel Function is used to returns the relative position of an item in the given array or range of cells that match a specific value in specific order. You can easily use match function to get the result either in vertical or horizontal lookup array. Read More

How to use IFNA with VLookup function

If any lookup values does not found in the list of array an error message #NA display in the resulted cells. If you want to remove an error value during lookup the value then you must know how to use IFNA with VLookup function. Sometimes when the data your are looking for is not found in the list, you will receive #N/A error message. Read More

VLookup with Two Lookup Values using IFError function

Sometime you need to apply VLookup with multiple criteria to get the result. If you want to use VLookup with two lookup values and also remove error results then you have to use IFError function along with VLookup function. This tutorial shows you how could you easily VLookup multiple values in Excel which is based on one or more conditions. Microsoft Excel is an important application software which is used for data analysis. Read More