From students to businessmen – Microsoft Excel can be a very useful tool for all who want to create reports, charts, tables and so on. When someone needs to create a chart using a free tool, Microsoft ...

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

Excel formulas are the backbone of any powerful spreadsheet. But let’s be real. They can also be a source of frustration when ...

Microsoft Excel has been the industry standard spreadsheet software for decades, since outdoing the once venerable Lotus 1-2-3, the first killer app for PCs in the 1980s. And Excel's dominance has yet ...

There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions. Image: ...

Power users love to talk about how powerful and awesome Excel is, what with its Pivot Tables, nested formulas, and Boolean logic. But many of us barely know how to find the Autosum feature, let alone ...

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

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...

Are you getting all you can out of Excel? Excel has plenty of features, shortcuts, and tools that can save you time, improve the integrity of your workbooks, and simplify data analysis. Here are some ...