Excel

  • Formulas and Functions:
    • Functions:
      • VLOOKUP(): Searches for Key in a table. After matching the Key, it returns the requested value in that record.
      • INDEX():Basically this function receives a range of cells, a row index and a column index as input. It returns the the value or reference of the cell at the specified row and column index.
      • COUNT(): Returns the number of cells in a range which have numeric values in them
      • &, Concatenating Text: Concatenating text can be achieved by using the & character.
      • FIND(): The function FIND() searches for a specific text expression inside another text and returns the first index which the text was found
      • MID(), LEFT(), RIGHT(): The main purpose of these functions is to return a certain number of characters (substring) from a text.
      • IF(): Receives 3 input parameters. The first input parameter is a logical test. The logical test will either equate to True or False. If the logical test equates to TRUE then the second parameter will be returned  If the logical test equates to False then the 3rd parameter will be returned
      • LEN(): Returns the number of characters in a text string.
      • TEXT(): Converts a number value to a text string, with the format specified.
      • INDIRECT():  Returns a reference specified by a text string
      • CHAR():  Receives an number as input and returns the character associated with it.
      • DATE(): Creates a date value by receiving the year, month and day.
      • DATEVALUE(): Creates a date value based on a date expression.
      • MATCH(): Searches a 1 dimensional range for a target value.
      • INDEX-MATCH: Explains how the two function INDEX and MATCH can be combined to create a functionality similar to VLOOKUP and HLOOKUP.
    • Change Formula Calculation to Manual: Explains how you can change the formula calculation to manual in an excel workbook






  • Formula Speed and Efficiency: Articles that compare the efficiency and the speed of the different formulas in excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s