'Google Sheets tips' category archive, page 3

Calculating time in Google Sheets: subtract, sum and extract date and time units

It's time to talk about the ways of calculating time in Google Sheets. We'll discuss the ways of finding time difference in detail, see how to sum dates and time together, and learn to display only date or time units and set them apart completely. Continue reading

Date and time in Google Sheets: enter, format and convert dates and time in your sheet

Today we dig into the ways of working with dates and time in Google spreadsheet. See the ways of inputting date and time values into your table, learn why you may need to convert them to decimal, and find out about custom number formats Google tables offer. Continue reading

How to add, edit and delete checkboxes and drop-down lists in Google Sheets

When you work with Google spreadsheet, sooner or later you may need to use some functionality that you've never used before. Checkboxes and drop-downs can quickly turn out to be such features. Let's see how useful they can be in Google Sheets. Continue reading

How to work with conditional formatting in Google Sheets

Highlighting certain data with color is a great way to draw attention to the records. Wouldn’t it be great if such format change happened automatically for specific cells? This is where conditional formatting comes in handy. Google Sheets can do this work for us, all we need is to explain what we want to get. Continue reading

Back to Basics: edit and comment on data, review the changes, print and download from Google Sheets. Even offline

We continue our "Back to Basics" journey by digging deeper into editing Google Sheets. Today, in addition to learning some simple features like formatting and deleting the data, we’ll discuss how to add comments and notes, work offline, and quickly review all the changes made to the file. Continue reading

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

Pages: 1 2 3