Excel INDIRECT Function

INDIRECT Function

The indirect function in excel returns a reference to a range. We can use this function to create a reference that won't change if row or columns are inserted in the worksheet. Or, cause it to create a reference from letters and numbers in other cells.
The INDIRECT function has two arguments:

indirect formula in excel

1. ref_text: A cell reference or text string (or both), that create the range reference. The referenced range can be a cell, a range of cells, or a named range.

1. a1: TRUE or FALSE. Does the reference use A1 reference style? If this argument is TRUE, or omitted, the ref_text is A1 style. If the argument is FALSE, the ref_text is R1C1 style.

Indirect Function Excel

Excel Function-Match

 Excel Function:Match

This DataWitzz tutorial will explain you about MATCH function of excel.Let us first start with the functionality MATCH,it searches for a value in an array and returns the relative position of that value.
It is built-in function of excel and will come under lookup/reference category.

Syntax:=Match(lookup value,array in which we want to find the position,[Match_Type])

Match_Type is optional and three values can be used as mentioned below:

  

Different COUNT function in Excel

difference between absolute and relative reference in excel

COUNT is very important function in excel and it is being used very frequently.There are five COUNT(count,counta,countblank,countif,countifs) functions which is being used in excel.I will explain every function one by one and have also shared a video with full explanation.

 

Count: This function counts the number of numeric entries in a list. It will ignore blanks, text and errors.

Syntax: =COUNT(Range1,Range2,Range3...................,RangeN)

History of MS Excel

                                      A Brief History of Microsoft Excel
Journey of Excel started in 1987 with Excel 2.0 as the first version for Windows. There never was an Excel 1.0 for DOS or Windows.Microsoft released the first version of Excel for the Macintosh on September 30, 1985, and the first Windows version was 2.0 (to synchronize with the Macintosh version 2.2) in November 1987.
Excel 3.0 launched in 1990's and it included tool-bars, drawing capabilities, outlining, add-in support, 3D charts among the other features.
Excel 4.0 launched in 1992 and it introduced auto fill options in Excel.
Excel 5.0 launched in 1993 includes VBA and it had the ability to automate the tasks in excel and has the capacity to create user defined function(UDF) for use in worksheet.
Excel 95 (v7.0) launched in 1995 and it was more faster and stable than the previous versions.There is no Excel 6.0
Excel 97 (v8.0) was launched in 1997.It introduces the paper clip office assistant,validation and a new interface for VBA developers.
Excel 2000 (v9.0) was launched in 1999.It was introduced with the self repairing function of excel and improvement in clipboard function to hold multiple objects at a time.
Excel 2002 (v10.0) it was a part of office XP.It added multiple feature but most of them are minor one.The most significant was saving the file while it crashed and recover corrupt workbook file and also capability of background formula auditing which identifies potential errors in the formula.
Excel 2003 (v11.0) it was a part of office 2003.Most significant was improved support for XML i.e import and export of XML files and mapping the data in specific cells of worksheet.Also a new "list range" feature was introduced.
Excel 2007 (v12.0) it was released in 2007.It introduces major changes(upgrade) from the previous version.The following features were introduced: