When you have a lot of data in an Excel worksheet it often becomes necessary to summarize the information to get to the crux of what it is telling you. There are a number of ways to do this in Excel, ...

Have you ever stared at an Excel spreadsheet, overwhelmed by its complexity, and thought, “There must be a better way to do this”? You’re not alone. Despite being one of the most widely used tools for ...

Excel's subtotaling feature is a great tool for inserting subtotaling formulas in into your data. The down side is that the subtotal rows are often difficult to discern from the rest of the data.