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. Different methods in VBA can be used, including for a range.
      • 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

Your email address will not be published.