Your most important Excel functions exist in Sheets, too. Here’s a few of the things you can do.
AVERAGE
Statistical Returns the numerical average value in a dataset, ignoring text.
AVERAGEIFS
Statistical Returns the average of a range that depends upon multiple criteria.
CHOOSE
Lookup Returns an element from a list of choices based on index.
COUNT
Statistical Returns the count of the number of numeric values in a dataset.
COUNTIF
Statistical Returns a conditional count across a range.
DATE
Date Converts a provided year, month, and day into a date.
FIND
Text Returns the position at which a string is first found within text.
GETPIVOTDATA
Text Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.
IF
Logical Returns one value if a logical expression is true and another if it is false.
INDEX
Lookup Returns the content of a cell, specified by row and column offset.
INT
Math Rounds a number down to the nearest integer that’s less than or equal to it.
LOOKUP
Lookup Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.
MATCH
Lookup Returns the relative position of an item in a range that matches a specified value.
MAX
Statistical Returns the maximum value in a numeric dataset.
MIN
Statistical Returns the minimum value in a numeric dataset.
NOW
Date Returns the current date and time as a date value.
ROUND
Math Rounds a number to a certain number of decimal places according to standard rules.
SUM
Math Returns the sum of a series of numbers and/or cells.
SUMIF
Math Returns a conditional sum across a range.
TODAY
Date Returns the current date as a date value.
VLOOKUP
Lookup Searches down the first column of a range for a key and returns the value of a specified cell in the row found.