Clustering non-numeric -- or categorial -- data is surprisingly difficult, but it's explained here by resident data scientist Dr. James McCaffrey of Microsoft Research, who provides all the code you ...

The simplest way to start documenting Excel formulas like a coder is by using the N () function. Although its primary job is to convert non-numeric values into numbers, it has a hidden quirk: because ...

How to highlight details for better insight with sparkline charts in Excel Your email has been sent The recent article, How sparklines deal with non-numeric values in Excel shows you how to avoid ...

Don't listen to anyone who tells you that the VALUE function in Microsoft Excel is obsolete. You'll probably seldom need to use it on its own, but when combined with other functions, it's still as ...

Clustering data is the process of grouping items so that items in a group (cluster) are similar and items in different groups are dissimilar. After data has been clustered, the results can be analyzed ...