With Excel, you can create simple calculators that speed up calculations you perform frequently. Among the many calculators that you can create with Excel is one that handles the pricing of options, ...

Using Excel's number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how you want it to. In this article, I'll explain what each number format is, ...

How to display the top n records in an Excel PivotTable using built-in options Your email has been sent In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet ...

The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder. MyOnlineTrainingHub takes you through how to enable ...

Excel has several advanced sorting options, but most of us never venture beyond the ordinary alphabetic and numeric sorts. If you need more than a simple sort, check out Excel’s advanced sorting ...

XLS files are Excel workbook files created in Excel 97 or Excel 2003. The 2007, 2010 and 2013 versions of the program use the XLSX format by default to save workbooks, but can also use the XLS format.

I have a password protected xlsx file that somehow became corrupt. <BR><BR>I've tried the automatic repair feature in office 2010 with no luck. I've also tried various excel recovery programs that ...