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!
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 →
Errors in Google Sheets… It happens every time! Breaks the charts in Looker Studio and is simply an eyesore while working with data! Read the article about Google Sheets errors handling! In this article I am going to teach you …
Mastering data in Google Sheets: ERRORS handling with these formula tricks Read more →
Welcome back to the second part of the tutorial of creating a cohort analysis in Google Sheets. In the previous chapter we’ve seen what kind of data we need to input and started doing the calculations. I’ve filmed a video …
How to create a cohort analysis in Google Sheets – part 2 Read more →
Cohort analysis is a type of analysis when we split the users by groups and observe the behavior of these groups based on certain characteristics. In this article we will start doing all the settings and calculations for cohort analysis …
How to create cohort analysis in Google Sheets? Part 1 Read more →
If you work in the area of data visualization in Looker Studio, for sure you have to work in Google Sheets to prepare your data. Today I would like to share a case with the REGEXMATCH Google Sheets formula. Task …
0 items in the cart (0 €)