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

Learn how to quickly summarize Excel data on-the-fly using these easy-to-implement features. Summarizing data is one of Microsoft Excel’s main functions. The good news is that a lot of number ...

Word and Excel are both part of the larger Microsoft package, so it's no surprise they play well together. Exce*l* is a great tool for gathering information in a database format, such as names, ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

A CSV (comma-separated values) file is a text file in which information is separated by commas. CSV files are most commonly encountered in spreadsheets and databases. You can use a CSV file to move ...