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!
December and January are the months I plan budgets for the year ahead. I built a practical, ready-to-use eCommerce marketing planner that combines Google Sheets and Looker Studio so you can plan budgets by channel, produce monthly and yearly forecasts, …
How to Plan Your 2026 eCommerce Marketing Budget (Template) Read more »
Managing and merging datasets in Google Sheets can be time-consuming, especially when dealing with multiple tables. The VSTACK and HSTACK functions provide a simple yet powerful way to stack data dynamically, eliminating the need for manual copying or complex array …
How to Join Tables in Google Sheets Using 3 Simple Formulas Read more »
The OR function is one of the most essential tools in Google Sheets, helping you create dynamic formulas that respond to different conditions. Whether you need to categorize data, calculate values based on criteria, or automate decision-making, mastering the OR …
Google Sheets: Master the OR Function with Simple Examples Read more »
If you still don’t know how to use the IF function in Google Sheets, you’re missing a lot! The IF function can help you to solve diverse challenges that marketers face, hence making your work easier. In this tutorial, you’ll …
Master the IF Function in Google Sheets with Practical Examples Read more »
Do you know how to use the AND function in Google Sheets? I am here to explain to you how it works and how it can make your Google Sheets practice significantly easier! Check out the video tutorial here: Formula …
Google Sheets: How to Use AND in Logical Formulas Read more »
Have you ever felt the need to use several conditions when working with the IF function? Most likely you surely have. In this article I am going to tell you everything you need to know about the IFS function, which …
Google Sheets: Learn the IFS Function with Easy Examples Read more »
In the realm of business intelligence (BI) and data visualization, the tools you choose can significantly impact how effectively your organization analyzes and interprets data. Two of the most popular platforms in this space are Looker Studio (formerly Google Data …
Power BI vs Looker Studio: Which One Is Better for Your Business? Read more »
The SUMIFS formula in Google Sheets is a powerful tool for anyone looking to perform conditional summation efficiently. Whether you’re a marketer analyzing campaign performance, a financial analyst evaluating budgets, or a project manager tracking resources, SUMIFS can simplify complex …
Complete Guide to the SUMIFS Function in Google Sheets Read more »
Google Sheets is a powerful tool that offers various functions to manage, analyze, and visualize data. Among its many features, the COUNTIF formula stands out as a versatile tool for counting cells based on specific conditions. In this article, we …
Complete Guide to the COUNTIF Function in Google Sheets Read more »
If you’re managing data across platforms like Google Sheets and Looker Studio (formerly known as Google Data Studio), the ability to manipulate and combine data efficiently is essential. One function that often gets overlooked in this workflow is the CONCAT …
CONCAT in Google Sheets and Looker Studio – Simple Guide Read more »
0 items in the cart (0 €)