Blog

How to Remove Duplicates in Google Sheets

Disclosure: Some of the links in this post are affiliate links, meaning I’ll get a small commission (at no extra cost to you) if you signup.

In this post, you’ll see how to remove duplicates in Google Sheets using Add-Ons, Formulas, Pivot Tables, Conditional Formatting or Apps Script.

Firstly though, what are duplicates? And why are they a problem?
Continue reading How to Remove Duplicates in Google Sheets

The Complete Guide to Simple Automation using Google Sheets Macros

Google Sheets Macros are small programs you create inside of Google Sheets without needing to write any code. They allow you to automate repetitive tasks. They work by recording your actions as you do something and saving these actions as a “recipe” that you can re-use again with a single click.

Sound good?

They sure are! Read on to learn how to use them, see some examples, discover their limitations and also see how they’re a great way into the wonderful world of Apps Script coding 😀

Contents

  1. What are Google Sheets macros?
  2. Why should you use macros?
  3. How to create your first macro
  4. Other options
  5. A peek under the hood of Google Sheets Macros
  6. Google Sheets Macros examples!
  7. Resources

Continue reading The Complete Guide to Simple Automation using Google Sheets Macros

Six reasons to start learning SQL

This is a guest post from Tomi Mester of Data36.

Back in 2011, during my college years, I got my first-ever job (an internship) at a cool IT startup. I got to do all kinds of interesting tasks but mostly it was data analysis.

The process was simple:

  • I received data from the developers in .csv format
  • I imported it into Excel
  • I crunched the data there
  • I sent the beautiful charts to my manager

We learned a lot about user behaviour, trends, and how we reached (or didn’t reach) our goals. I loved it – except for one thing: I always had to wait days (sometimes weeks) for the developers to export the data for me from the company’s SQL database.

That was my #1 reason to learn SQL!

I did so. And ever since then I’ve been a huge fan of this simple and elegant data language.

Why?

Because knowing SQL allowed me to do better, more detailed data analyses – more easily and faster. And I strongly believe that it can be extremely useful for everyone else who works in data analytics and who uses different spreadsheet tools in their day-to-day job.

In this article, I’ll give you 6 reasons why you should learn SQL too!
Continue reading Six reasons to start learning SQL