The smartest thing Excel does happens in places you can't see.

In Microsoft Excel, the well-known and widely used spreadsheet software, you can use letters to represent values. So, for instance, instead of subtracting 5 from 10, you can subtract x from y. This ...

Microsoft has released a new feature called value token in Excel for Windows. These help you add badges to your cells to help differentiate data types used. Microsoft has just released value tokens in ...

The TYPE function is an information function in Microsoft Excel, and its purpose is to return a number indicating the data type of a value. The user cannot use the TYPE function to determine if the ...

Although Excel 2013 offers many options for performing calculations in new cells using data from existing cells, sometimes you want to work on data in the original cells. As an example, you might have ...

Sparklines are small charts that fit into a single Microsoft Excel cell. But if you’re tracking non-numeric data, they can exhibit weird behavior. Learn how to avoid problems when using sparklines.

Add Yahoo as a preferred source to see more of our stories on Google. If you have three or more rows of data, chances are, you'll need to summarize those values in some way. Summarizing is one of the ...