Latest Content

How to use VLOOKUP in Google Sheets

How to use VLOOKUP in Google Sheets

If the basic LOOKUP function left you feeling a little underwhelmed, I'm sure you'll appreciate the VLOOKUP. It’ll help you sort out those table sorting issues – pun intended!

Also, this is the only tutorial you need to check if you want to know everything about how to use VLOOKUP in google sheets.

Read more

The Ultimate Google Sheets LOOKUP function guide

The Ultimate Google Sheets LOOKUP function guide

Being able to conditionally look for data is one of the pillars of well-done spreadsheets.

If you've ever wondered about the Google Sheets LOOKUP formula in all its variants, wonder no more. After reading this article, you’ll have no doubts on setting up your lookup table and how to use this powerful function.

Read more

All About Google Sheets IMPORTRANGE

All About Google Sheets IMPORTRANGE

The Google Sheets IMPORTRANGE function allows you to import a range of cells from either an external spreadsheet or an existing sheet in a different sheet or spreadsheet.

Read more

Are formulas and functions the same thing?

Are formulas and functions the same thing?

When conducting keyword research for my Google Sheets website content, I often stumble across keywords like 'VLOOKUP formula' or similar phrases.

In this article, I've decided to clarify this concept, as there's a subtle distinction between these two terms, even if they're often used interchangeably.

Read more

All you need to know about Google Sheets ID

All you need to know about Google Sheets ID

In this article, I will go through all you need to know about Google Sheets ID.

Even if it may seem silly to be interested in this topic, it actually contributed to dramatically improving my productivity at work and saving hours of unnecessary work with my employer.

Read more

Welcome to 'Automate The Sheet Out Of It,' the website dedicated to helping you reclaim your most valuable asset: Your time at work.

Hi, I'm Alex. Throughout my career as an employee, I've consistently noticed that I'm much faster than most others. This realization led me to believe that:

  1. I'm probably more organized than the average person.
  2. Many employees are content with not working more (understandably) and therefore take their time.

With the rise of remote work, particularly since 2020, the second option has become less relevant.

So, how can I assist you?

It's no coincidence that most jobs have daytime shifts; it's when we're typically awake and productive.

If you work extensively with spreadsheets, especially Google Sheets, you can automate many tasks, particularly if your employer doesn't emphasize solid process building. By automating tasks, you can save significant time to allocate as you see fit.

Some of my friends claim to hold multiple jobs, but I prefer focusing on one and having ample free time for myself.

Whether you're a solopreneur building automations or someone in a 9-to-5 job looking to reduce hours (to perhaps a 9-to-3 schedule), if you're open to learning and adapting, you can achieve your goals.

Let's get started!