Posted on April 3rd, 2011 by Joseph Harris
The ISERROR function is a versatile one that is very useful in testing an outcome of a formula so that you can account for any errors, more on that later…First, lets learn the syntax: =iserror(A1) A1 is the cell you want to test for an error. If A1 contains #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME!, or #NULL!, [...]
Posted on April 2nd, 2011 by Joseph Harris
Starting with Excel 2007, a feature was added called “Color Scales”. Color scales can be used in many ways but by far my favorite is to use this functionality to create heatmaps. Heatmaps are 2 dimensional representations of 3 dimensional data. You can think of them as bar charts where you are looking down on [...]
Posted on June 5th, 2010 by Joseph Harris
Subsidium Business Analytics has released its Excel to PowerPoint converter. We though we would take it for a spin to see how it works and if it is worth the money. Purchase and Install The Excel to PowerPoint converter cost $4.99 so my expectation was low. I purchased the add-in and an automatic download began. [...]
Posted on April 1st, 2009 by Joseph Harris
Many applications that export to Excel, export the data with the apostrophe character at the front of the string. One way of removing this character is to use the clean() function: If in cell A1 you have: ‘output Then in cell B1 type =clean(A1). The result will be: output Joseph Harris Excel Help Bookmark It
Posted on March 23rd, 2009 by Joseph Harris
Use the Large and Small functions is Excel to find the Nth largest number in a list. For example: =Large(A2:E2,3) will return the 3rd largest value in the data set. =Small(A2:E2, 2) will return the 2nd smallest value in the data set. Joseph Harris Excel Help Bookmark It
Posted on March 23rd, 2009 by Joseph Harris
There are many ways to remove duplicate rows in Excel, in this articles I will give you a quick and simple method of deleting duplicates using the Advanced Filter. Assume you have data that contains multiple duplicate rows… Select all the data that you would like to test for duplicates Go to Data=>Filter=>Advanced Filter Select [...]
