The Query function in Google Sheets is one of the most powerful functions in Google Sheets. It's easy to learn if you follow the rules laid out in this tutorial. You'll be able to solve any data analysis problem that comes your way.
Learn how to use IMPORTRANGE in Google Sheets. This function is great when you'd like to import data from other spreadsheets. You can also use it together with QUERY to import and append data from multiple sheets.
There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It's simple trick that doesn't involve Apps Script. Check out the full article.
Learn how to create dependent drop-down lists in Google Sheets. Dependent drop-downs can be tricky in Google Sheets because you can't add a formula to the drop-down version of the data validation. But there is another way.
Cleanup Suggestions and Column Statistics in Google Sheets In late 2020, Google released a new feature to Sheets called Smart Clean-up. Smart Clean-up has two main purposes: Cleanup Suggestions – Examine the dataset for potential problems, like duplicate rows in a table,
With SmartFill in Google Sheets you get to auto fill a column based on a pattern. For example if you'd like to grab the first name of a person, you don't have to write the formula. Just write the end result and Sheets will fill down with the correct formula.
With Version Recovery and Version History in Google Sheets you get to easily revert back to any previous version of your Google Spreadsheet. You can even create Named versions and use cell Edit History to track changes to values inside cells.
Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It's a mix of Google sheets basic to advanced functions and hidden features.