There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

How to Create a BOM Using MS Excel. Tree diagrams use graphics to indicate the materials comprising a project or product and the relationships between those materials. A bill of materials, or BOM ...

Segmentation Using Excel 2007. When you're tracking a large amount of data for your business, it can become very easy to get lost when you try to make sense of the sheer amount of information you ...