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!
Google Sheets is a go-to tool for marketers handling data analysis, project management, and performance tracking. Two of the most versatile functions in Sheets are the AND and OR functions. These logical functions help marketers streamline data analysis, automate repetitive …
AND and OR Functions in Google Sheets for Marketing Read more »
The IFS function in Google Sheets is a powerful tool for marketers to simplify complex, multi-criteria analysis. It allows you to test multiple conditions and return a result based on the first condition met. This can be useful in marketing …
How to Use IFS in Google Sheets (Step-by-Step Guide) Read more »
Google Sheets has become an essential tool in digital marketing, especially for tracking performance metrics, monitoring campaign budgets, and visualizing data. Among its versatile functions, IF and IF AND stand out as powerful tools to help marketers streamline data analysis, …
Master IF and AND in Google Sheets for Better Marketing Reports Read more »
Blending data lets you create charts, tables, and controls based on multiple data sources. I’ve already posted several articles about blending data. In one of them I showed how all the types of joins work and in another one – …
How to Blend CRM Data in Looker Studio for Better Reporting Read more »
The date column is present in most of the tables that every marketer creates on a daily basis. However, not every marketer knows these 7 Google Sheets date formulas that surely will make your work easier! In this article, we …
Master Google Sheets Dates: 7 Formulas You’ll Use Daily Read more »
Are you struggling to get your dates formatted just right in Google Sheets? Whether you’re a spreadsheet novice or a seasoned pro, mastering date formatting can make your data more readable and visually appealing. Luckily, the TEXT formula in Google …
Get the month name from the date in Google Sheets Read more »
When it comes to tracking purchases, Google Sheets emerges as a handy tool for organizing and manipulating data. With Google Sheets functions like MAXIFS and MINIFS, businesses can easily pinpoint crucial details such as the date of the first and …
How to get the first and last purchase date of the customer in Google Sheets? Read more »
You may already be familiar with the VLOOKUP function in Google Sheets, but there is a XLOOKUP function that can replace it nicely. In this article I am going to tell you the difference between these two functions and I …
How to use XLOOKUP in Google Sheets and comparison with VLOOKUP Read more »
In Google Sheets, dates are often stored in a default format, which may not always be suitable for your specific needs. Fortunately, with the TEXT() formula, you can easily convert date values into a variety of formats, allowing for greater …
Copying and inserting data from different Google Sheets documents to one may be confusing and tiring. There is an IMPORTRANGE formula that will help you to avoid manual mistakes and pull up your data in a few clicks! Before reading …
0 items in the cart (0 €)