Google Sheets

If you’re here, you probably want to know how you can get the current time on google sheets, and that’s exactly what we’ll explain in this article. As a programmer, I always say “as long as we have to manage dates, we won’t lose our jobs”. Dates and times are a fundamental aspect of our […]

I love the clean and straightforward interface of Google Sheets, and I use it for everything from applying filters to adding heatmaps using conditional formatting. In addition, Google Sheets integrates well with other Google products and is a real timesaver. As handy as Google Sheets is, I ran into a problem when importing data from

I’m a programmer, and I always say that as long as we’ll have to work with time, timezones, and time conversions, we’ll never be unemployed! Oftentimes there is a need to turn times into their equivalent decimals or vice versa, and this is certainly possible within Google Sheets, and I’ll help you do so in

Here’s a list of our tips and tricks about google sheets with links to detailed articles with complete step-by-step guides and examples.

Google Sheets is a great tool for data analysis, but it can also be used to create beautiful charts and graphs. In this article, I’ll show you how to format numbers in Google Sheets using leading zeros. Normally zeros in front of a number are meaningless. However, there are some use cases where you need

Google Sheets is a great tool to save, organize and share data. It can be used for creating spreadsheets or documents that include tables, charts, formulas, etc. The most important thing about this great tool is the ability to easily add text formatting such as bold, italic, underline, strikethrough. Sometimes you want to remove some

Google Sheets has become a very useful tool for data analysis and reporting. The problem is that rows don’t always look as you expect. Although the default behavior of the software is to change the row height to adapt to a larger font or text wrapped on two or more lines, there are some situations

Have you ever needed to convert a Google Sheets table organized by rows to organized by columns? I had, and I found a really helpful feature to transform columns into rows.

That’s what transposing is all about, let’s see how to use it on google sheets!

One of the great advantages of using Google Sheets is the ability to work in a team/group editing the same shared file. However sometimes giving everyone the ability to edit the full document can be a problem, someone can accidentally edit the wrong cell and damage the document. Fortunately, Google gives us some simple and useful solutions!

When you work on a big spreadsheet, it’s a great resource to be able to navigate it quickly without always using the mouse.
But how do you quickly move in a google sheet? there’s a go-to cell in Google Sheets?I had the same question, and couldn’t find the answer on the google sheet menu. But finally, I found the solution, so here it is for you!

Many of us (if not all), use Google Sheets as a database, and we use it to store data for our projects. But sometimes you need more than just simple data storage. You want to get the value from one cell or range, based on another cell or range. This is where the Lookup function comes into play.
In this tutorial, I will show you how to do that using Google Sheet’s built-in function LOOKUP.

OK, this is a pretty common task! Having a “name” and a “surname” column, and wanting both merged into a single “full name” column. And even if we’re making this specific example, you can use this guide to merge the content of two or more cells regardless of their content being names or something else. I think every google sheets user will need this sooner or later. I needed it so many times!