In this section you can find various articles both theoretical and tutorials about Google Sheets. Tricks & Tips, formula explanations, creating cohort analysis, add-ons overviews and many other useful things about Google Sheets are here!
Have you ever wondered how to find and remove duplicates in Google Sheets? Here I am to teach you how to do that in 5 minutes! I will share some tips and tricks with you and for better understanding you …
Find and remove duplicates in Google Sheets in 5 minutes! Read more »
Did you know that there are plenty of tips and tricks that will surely make using Google Sheets easier and amusing? Today I would love to tell you about about how to turn date into day of week (Google Sheets). …
Turn date into day of week in Google Sheets tutorial 2023 Read more »
When you start working with Looker Studio you may ask yourself “How do I connect a Google Sheets to Looker Studio?” I am here to explain! Keep up with the video tutorial to get a better understanding: Google Sheets tips …
How to connect and use Looker Studio with Google Sheets 2023 Read more »
Did you know that you can do conditional formatting in Google Sheets based on another cell value? Keep reading this article to get to know it! Also, you may find interesting my article about the basics of conditional formatting. But …
Conditional formatting in Google Sheets based on another cell value in 2023 Read more »
Let’s talk about one useful function in Google Sheets – conditional formatting. I will show you how to set it up using a pivot table (read the article about creating a pivot table here). Check out the video tutorial here: …
Conditional formatting in Google Sheets for beginners Read more »
It is impossible to imagine data analysts working without pivot charts. If you’re not familiar with them, here I am with my new article – Pivot tables in Google Sheets tutorial for beginners. I would like to tell you about …
Pivot charts in Google Sheets tutorial for beginners Read more »
Continuing reviewing the connectors, I would like to review Power My Analytics Facebook Ads connector that I’ve mentioned in my previous article. I’ve already connected my Google Sheets Account and I’ve already installed the add-on (read the article about it …
Power My Analytics Facebook Ads connector to Google Sheets Read more »
Continuing reviewing different Google Sheets add-ons, today I’d like to tell you about Power My Analytics Google Sheets add-on. I like this Google Sheets data connector and frequently use it in my work. I discovered it a couple of years …
Power My Analytics add-on to Google Sheets overview Read more »
Sometimes it’s better to pull and transform your data from Google Analytics to Google Sheets than to Looker Studio. Especially, if you want to merge the data from Universal Analytics and GA4, you can use add-ons that can help you. In …
Free Google Sheets add-on to pull Google Analytics 4 data Read more »
When talking about Google Sheets extensions, to pull up data from different platforms most likely we’ll need connectors to do it. Recently, I’ve discovered a Windsor.ai connector that I would like to review in this article. Check out the video …
Windsor.ai Google Sheets extension overview and my experience Read more »