Over years of working with Excel, I have stumbled upon a collection of functions that have transformed my workflow. These ...

Excel's AGGREGATE function lets you perform ... If you were to use the AVERAGE function alone by typing: =AVERAGE(Player_Goals[Games per goal]) into cell C1, this would return an error, because ...