Google Sheets and Excel have a lot in common, date sorting isn't among them. Here's how to use Google Sheet's somewhat confusing sort by date feature.

With new support for named functions, LAMBDA and helper functions, spreadsheet calculations — especially with arrays — may be more efficient and elegant.

After years of waiting, Google Sheets finally supports the powerful XLOOKUP function, and has added other powerful new functions too.

For those who do use Google Sheets regularly to splice their data, these new features may prove game-changers.

New features are now rolling out to Google Sheets, making it easier for users to analyze data and share information with other documents and users. One of ...

You can use SUMIF in Google Sheets to add numbers together that are associated with a date range, specific text, or meet a numeric criterion.

The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types ...

Google has announced that Google Sheets is getting the ability to intelligently suggest formulas and functions for your spreadsheet, based on the data you’re trying to analyze. For example ...

Learn how to use IF & nested IF statement in Google Sheets. & highlight a row using conditional formatting, set up multiple conditional formatting rules.