Essential Excel Concepts »
Essential Excel: Excel Time arithmetic.
March 11, 2013 at 5:34 pmThe key point to remember when dealing with Time in Excel is that it is a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented...

Essential Excel: Using the INDIRECT Function.
The Indirect Function The INDIRECT worksheet function is a great function to generate cell...
May 24, 2012 at 7:34 pm 
Essential Excel: The OFFSET Function.
This article will focus on the use of the OFFSET function and we promise ...
May 24, 2012 at 6:24 pm 
Essential Excel: The Powerful INDEX & MATCH Functions in Excel.
The Index & Match Function: The INDEX Function can return an item from a specific position in a table. The...
May 17, 2012 at 8:28 pm 
Excel Essentials: Using Dates in Excel.
Dates in Excel can be displayed in a variety of daymonthyear formats or in a serial format. A serial...
May 10, 2012 at 6:48 pm 
Excel Essentials: Understanding custom number formats in Excel
Excel custom number formats have four Sections. These are, from left to right Positive numbers ...
May 9, 2012 at 6:37 pm 
Excel Essentials:How can I test for two or more conditions in Excel?
How can I test for two or more conditions in Excel. We have the following situation The...
May 7, 2012 at 3:52 pm 
How can I name a cell or range of cells in Excel?
How can I name a cell or cells in Excel and why should I give Names to my cell ranges in Excel. There are two main...
May 6, 2012 at 10:37 pm