Many Excel tools are optional extras, but these six are essentials I rely on in every workbook.

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 PivotTables do a great job of turning data into meaningful information, but they have one flaw: You can’t easily add grand total rows. Microsoft Excel PivotTables are a great way to ...

For many small business owners, Microsoft Excel is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare documents for distribution to partners or ...

Here are a few tips that will improve your efficiency and get you out of that massive data spreadsheet as soon as possible. About a month ago, I wrapped up a massive data reorganization project. The ...