Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.

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 ...

Sparklines in Microsoft Excel are charts—tiny little charts that display inline with the data because they fit into a cell, usually adjacent to the data they’re evaluating. With a quick glance, not ...

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 ...