It may be a surprise to learn that you can define names of cells in Microsoft Excel instead of using the letter and number ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

Looking to become an Excel power user? Excel has a number of features that will make it easier for you and your colleagues to enter data into your spreadsheets. If you’re developing a spreadsheet that ...

To help readers follow the instructions in this article, we use two different typefaces. Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type indicates commands and ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Apple Numbers isn't as popular as Excel, but it’s a powerful spreadsheet application that offers all the essential features you’d expect. If you're thinking about making the switch, here are some ...

Excel spreadsheets are one of the most useful tools to create documents with calculations and data and organize the accounting or VAT tax, among other tasks. Luckily, while working on Excel you can ...

Spreadsheet applications helped to kick off the personal computer boom in the 1980s and are effective tools in most businesses today. Sometimes a spreadsheet gets complicated, with many formulas and ...

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

They're calling it the "Excel Error Heard Round the World": Kenneth Rogoff and Carmen Reinhart's widely cited paper about the relationship between public debt and ...