An Excel table showing ten players, the number of games they've played, the number of goals they've scored, and the games-per-goal ratio. The AGGREGATE function in Excel returning an array result.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Lookup_array = The range in the table containing the value you’re seeking. Match_type = The number, -1, 0 or 1, that specifies how Excel matches the lookup_value with values in the lookup_array . If ...

The SUM function is probably the most basic function you need in Excel. Walter Hickey BI You type in =SUM( and then select an array of values.

Fortunately, thanks to Excel’s FILTER() dynamic array function, creating a list of duplicate values is easier than it once was. In this article, I’ll show you how to use FILTER() to create a ...

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.