Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear ...

The PIVOTBY Syntax . The PIVOTBY function lets you input a total of 11 arguments. Although this sounds daunting, the benefit ...

There is nothing more frustrating than when someone pastes a value on top of a formula in your spreadsheet. This can ruin a beautiful excel model. And it can take awhile to fix because you have to ...

Every Excel expert knows how to navigate without a mouse and how to format data using keyboard shortcuts. But do you know how to insert a sum without typing the formula? Have you struggled to ...