With Microsoft Excel's powerful sorting capabilities, you can enter unsorted data and let the software sort your data numerically, alphabetically or chronologically. You can sort all the rows in a ...

Microsoft Excel is spreadsheet data management software used by many small businesses for day-to-day operational tasks. Excel's convenient cell-based structure lets you input your business' inventory, ...

Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...

Who doesn’t love spreadsheets? Probably a lot of people, actually, but even if the thought of filling rows and columns with various data points doesn’t get your pulse rising, there are a number of ...

If you work with data much, you don’t need a statistical model to predict that the odds of consistently getting data in the format you need for analysis are pretty low. Those who do a great deal of ...