The Pareto Principle, also known as the 80-20 rule, is a powerful concept that can transform your approach to data analysis. This principle states that roughly 80% of effects come from 20% of causes.

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

You can use Microsoft Excel to set up a simple row-and-column matrix of information, listing income data, itemizing expenses and documenting events. These tasks barely scratch the surface of Excel's ...

Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.

Often, in the course of putting together a lengthy set of data in Microsoft Excel, users will want to rearrange their cells or add a new one to an established row (in addition to making graphs, which ...