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.

Life is hectic, and juggling dozens of apps for the "must-do" chores adds to the noise. Since I already work in Excel daily, I've expanded its use to automate three of my most boring tasks. These ...