With any software, the more you use it, the more hacks and shortcuts you discover, and never a truer word has been said when ...

Q. Is it possible to sort a column in Excel using formulas rather than the Data tab’s Sort tool, so the sort process is performed automatically as I update my data? A. Excel has announced a new ...

Using just one formula, you can create an entire table, generate a filtered view, calculate a running total, or build a ...

Example: I have a 5 x 5 array of data with names of animals in it. I have another cell with "monkey" written in it. Is there a way I can write a formula to test whether or not "monkey" exists in the ...

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range. Not all sorts are so easy. Fortunately, Excel ...

Column graphs offer a visual representation of data that allows easy comparison between multiple values. Typically, these columns are uniformly spaced, but there are times you will need to group ...