Google Sheets Blog

Functions

The Google Sheets program contains several functions which you can master to become more productive at work. Learning the different functions in Google Sheets can help you understand all the ways you can manipulate and analyze data. Read the topics below to learn more about all the different things Google Sheets can do.

• COUNTIF The COUNTIF function counts the number of cells in a range which match a specified criterion.

• DETECTLANGUAGE This function lets you detect the language of text in Google Sheets.

• GOOGLEFINANCE This function lets you analyze historical and real time financial information firectly in Google Sheets.

• GOOGLETRANSLATE This function translates text in Google Sheets between more than 100 different languages.

• IF The IF function evaluates a logical statement and returns one value if the logical statement is true, and returns another value if the logical statement is false.

• SUM The SUM function calculates the sum of numerical values in Google Sheets.

• UNIQUE The UNIQUE function filters a range of cells or rows and returns all of the unique values while omitting duplicates.

Shortcuts

Keyboard shortcuts in Google Sheets help you become faster and work more efficiently. While they may feel strange and forced at first, they will eventually become second nature. Start practicing these shortcuts to build muscle memory and become more productive at work.

• Bold, Italics, and Underline Shortcuts These shortcuts enable you to quickly perform basic text formatting.