'Google Sheets tips' category archive, page 3
Back to Basics: sharing, moving and protecting the data in Google Sheets
Moving on to another stop of our "Back to Basics" journey, today I will tell you more about managing your sheets. Learn how to share, move and protect your data in Google Sheets. Continue reading
Google Spreadsheet COUNTIF function with formula examples
We continue exploring the possibilities of Google Spreadsheets with COUNTIF function. Learn why you may need it and how it can be applied to your daily work with the tables. Continue reading
Google Sheets IF function - usage and formula examples
Get to know Google Sheets IF function better with this tutorial: when is it used, how does it work and how it contributes to a much simpler data processing. Formula examples are included! Continue reading
How to combine duplicate rows, merge values, and add subtotals in Google Sheets
Whether or not you're new to Google Sheets add-ons, you’ll love the news: now it takes three simple steps to combine duplicate rows and keep all unique information safe. Continue reading
Google Sheets pivot table tutorial - make your job easier
Pivot table Google Sheets can help you to represent your data in a more convenient and presentable form. Continue reading
Video: How to merge cells and preserve original values in Google Sheets
See how you can quickly combine the cells with all their data in Google Sheets. Join text in columns, rows, or ranges with simple and flexible settings that our free add-on offers. Continue reading
Advanced search and quick replacements in Google Sheets
Learn about our recent addition to Power Tools that lets you perform advanced search in the entire spreadsheet, export rows with all found values, and replace any records you need. Continue reading
Video: How to remove duplicates in Google Sheets
Learn how to work with Remove Duplicates add-on for Google Sheets: quickly find unique entries, compare two columns or even tables for duplicate rows. Continue reading
How to get more Google Docs templates
When creating typical documents like an invoice or resume, you can get a much bigger choice of templates than the standard few files. Let's look at the add-ons that provide nice Google Docs templates and well-organized Google Sheets templates, learn how you can quickly replace custom fields and work with your docs more efficiently. Continue reading
Excel online or Google Sheets: choosing online solution for your tables
Work online is a commodity that is slowly turning into a necessity. If you want to take your tables to the cloud, consider the most popular spreadsheet solutions: Google Sheets and Excel online. In this blog post I will try to list the main differences in the features they provide. Continue reading
How to count cells by color in Google Sheets
If you color-code your data in Google Sheets, you've probably noticed the lack of standard formulas that summarize this kind of information. In this article you will learn how to use our add-on to count and sum cells by color. Continue reading
