2013 New Functions

• BAHTTEXT

  Converts a number, plus the suffix "Baht" into Thai text

• Common Excel Keyboard Shortcuts

  Most people know some Excel keyboard shortcuts, and therefore recognise that they can be a great time-saver and can help you to work much more smoothly and efficiently.
  
  This page lists of the most popular Excel shortcuts. The shortcuts have been organised into categories, to help you to find those that are of particular interest to you. It is recommended that you try to remember a few at a time, and make use of these in your day-to-day work, until they become second nature to you.

• Excel Advanced Filter

  The Excel Advanced Filter can be used to perform more complex filtering than the basic Excel Autofilter.

• Excel Autofill

  The Excel Autofill feature can be used to populate a range of cells with either a repeat value,

• Excel Data Input

  The basic Excel task of populating a spreadsheet can be done in several different ways. These methods, which are described in the linked pages below, will help you to work more efficiently in Excel.

• IFERROR

  Tests if an initial supplied value (or expression) returns an error, and if so, returns a supplied value; Otherwise the function returns the initial value.

• IFNA

  Tests if an expression returns the #N/A error and if so, returns an alternative specified value; Otherwise the function returns the value of the supplied expression

• Insert a New Line in an Excel Cell

  <ALT> Enter

• ISODD

  Tests if a supplied number (or expression) is an odd number, and if so, returns TRUE; Otherwise, returns FALSE.

• NUMBERVALUE

  Converts text to a number, in a locale-independent way

• UNICHAR

  Returns the Unicode character that is referenced by the given numeric value

• UNICODE

  Returns the number (code point) corresponding to the first character of a supplied text string

• weft

  wtrwet

• XOR

  Returns a logical Exclusive Or of all arguments