If you think Excel is only for number crunchers, you're missing out.Here are ways the average person can use the spreadsheet ...

As well as using SUM and AVERAGE in the GROUPBY function argument, you can use the PERENTOF function, which turns the data into percentages to show the proportion a subset makes up of a whole dataset.

Conditional formatting can help you get the information you need from data. For example, suppose you would like to know how many students in your class received an above-average score on a recent ...

To calculate this weighted average, first input the two values for the number of shares outstanding into adjacent cells. In our example, during January, there were 150,000 shares, so this value is ...

Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get Excel to average values, conditionally. Simply insert the following form as an array: =AVERAGE(IF ...

Functions perform a mathematical calculation on a range of cells in Excel. The most common Functions are SUM, AVERAGE, COUNT, MIN, and MAX.. If an individual wants to find the average, minimum, or ...

You need to use this formula to calculate the average GPA in Excel: =<cell with sum of grade values>/<total number of subjects>. Then, you can use VLOOKUP to enter the grades.