Microsoft Excel tables are a way to organize complex data into rows and columns, making your information easy to understand. Table styles let users add color and change the font of their tables. If ...

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

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

In Microsoft Excel, you can convert your data into many types of charts. However, frustratingly, there's no option for a ...

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

When you paste something in Microsoft Excel, it displays a button called Paste Options. However, if you want to hide the Paste Options button after pasting data in Excel, you can do so using in-built ...

Whether you are giving a presentation or have employees or coworkers who are visually impaired, the ability to use text-to-speech functionality is often invaluable. Microsoft's Excel 2013 spreadsheet ...

Wondering where your favorite Excel 2003 commands went? Worry no more. Just use these quick reference charts, which list the most commonly used Excel 2003 commands and tell you where they are in Excel ...

Are all or some menu options greyed out in Excel for you? Some Office users have reported that certain or many menus are grayed out in their Excel sheets. Whenever they try to click on such menus, the ...

Despite the many spreadsheet editing apps you can use, Microsoft Excel often ends up being many people's default pick. Perhaps this is thanks to Excel's deep integration with other apps in the Office ...

There are pros and cons to simple pastes, pasting a worksheet image, embedding the worksheet, or linking to it in your Word doc. Dennis O'Reilly began writing about workplace technology as an editor ...

Editor’s note: This article uses a simplified example to illustrate how a lattice model works. In the exhibits, the option term is only four years—much shorter than the 10-year life of a typical ...