Google has started rolling out Google Sheets Formula Suggestions which automatically suggests formulas based on the entered data, Here's how you can use them.

Array formulas allow you to perform calculations on multiple values at once, returning an array of results. Basic Array Formula: Use the ARRAYFORMULA function to apply a formula to an entire range.

Here's a quick and dirty formula you can use in Google Sheets to get a running count of cells that contain any value (numbers, dates, text, links, etc.).

The Sheets spreadsheet now calculates twice as fast: Google has been working for years on replacing the JavaScript engine and returning to Java.