This article is republished with permission from Wonder Tools, a newsletter that helps you discover the most useful sites and apps. Subscribe here. You don’t have to be in business to find Google ...

Pivot tables let you parse raw spreadsheet data to display specific information in a concise, easy-to-digest format. Here’s how to use them in Google Sheets. One of the best ways to master Google ...

When you’re parsing through large amounts of data in a Google Sheets spreadsheet, conditional formatting can help you find those bits of information that you want. Conditional formatting helps to ...

Spreadsheets are ubiquitous in the office, whether you’re a solo entrepreneur or an analyst at a large corporation. However, many folks don’t utilize the full potential of spreadsheets. In this post, ...

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to ...

Google Sheets, the spreadsheet tool that's part of the Google Apps productivity suite, lets users format cells based on certain conditions, including the date contained in a cell and how far away that ...

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...

Google Sheets has the power to calculate the number of days between two dates, regardless of the date format entered. The only requirement is consistency between manually typed dates and the ...

Although Google Sheets and Excel Online are two of the best free online spreadsheets editing apps, you may not like certain features of them. For example, the date format. In case you do not want to ...