Editorial Note: Forbes Advisor may earn a commission on sales made from partner links on this page, but that doesn't affect our editors' opinions or evaluations. A Microsoft Excel spreadsheet is one ...

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, performs the same function but with ...

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive ...

Automate repetitive data entry and fix broken sorting hierarchies using Excel's powerful, hidden Custom Lists tool.