In Microsoft Excel you can use a formula to compare two similar documents in different workbooks. For example, if a small business has two people compile financial statements in Excel using the same ...

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

Stop using fragile direct links—Power Query creates faster, automated, and more robust workbook connections.

Please note: This item is from our archives and was published in 2002. It is provided for historical reference. The content may be out of date and links may no longer function. Q. The Find and Replace ...

Over the course of business, you may find yourself with copious Excel files that you want to combine into a single workbook to make life a little easier. Excel 2010 allows you to copy or move ...

Excel workbooks are the next step after you’ve mastered the single Excel spreadsheet. Going back to the ledger idea we used in our Excel spreadsheets guide, think of the workbook as the ledger (or ...