Convert an XML file into an Excel spreadsheet with this technique Your email has been sent This article is also available as a TechRepublic download, which includes ...

If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true. Macros are small programs that execute commands you specify. Write ...

Microsoft has begun rolling out “Money in Excel,” a one-stop dashboard within Microsoft Excel for viewing your day-to-day finances, including bank and credit card transactions. Microsoft recommends ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

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