Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome.

In this episode of Business Reporter’s Best of British Business, we explore the power – and pitfalls – of data-driven decision-making with David Harding from MagicOrange.

Pivot tables are the unsung heroes of Excel. They transform raw data into actionable insights with just a few clicks. But are ...