http://www.xlninja.com/2012/08/07/how-to-apply-vlookup-across-worksheets/Using different worksheets for a VLOOKUP function is a good way to create...
http://www.xlninja.com/2012/08/06/how-to-create-a-chart-with-data-not-next-to-each-other/In an ideal world, you would have data in an spreadsheet...
http://www.xlninja.com/2012/07/31/the-iferror-function-to-manage-error-messages-in-excel/You can use the IFERROR function to manage error messages...
http://www.xlninja.com/2012/07/30/convert-to-lower-case-in-excel/Often we receive a spreadsheet in Excel that has some data all in UPPER CASE...
The CHOOSE function in Excel allows you to ‘Choose’ a “value’ depending on a specific input.
A little known function in Excel allows you to calculate someone’s age in years, months and days.You can use this function more in general to...