Excel's GROUPBY function lets you group and aggregate data ... select the data and click the "Accounting" icon in the Number group of the Home tab on the ribbon. Now, you want to find out the ...

Excel's PERCENTOF function returns the percentage that a subset ... select all the affected cells, and click the "%" icon in the Number group of the Home tab on the ribbon. While you're there ...

The key to mastering Excel is to start slowly, making sure you fully understand each function before moving ... Read next BI Tech Memo An icon in the shape of an angle pointing down.

1. The SUM function is probably the most basic function you need in Excel. You type in =SUM( and then select an array of values. This will result in the sum of the values in the array you've selected.

To calculate letter grades based on a percentage score, you can use multiple nested IF statements in Excel, which can get rather complicated quickly. However, there is an easier way. Added by ...