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

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 ...

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.

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.

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 ...

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 ...

Learn about the weighted average cost of capital (WACC) formula in Excel and use it to estimate the average cost of raising funds through debt and equity.