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!
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 …
Google Sheets is a great tool that I use everyday in my work and as we all know it has plenty of formulas that easen our routine tasks and one of the formulas that I find really interesting and useful …
When working with interrelated data, one of the foremost common challenges is finding data over different sheets. You frequently perform such tasks in everyday life, for example when checking a flight plan board for your flight number to induce the …
How to use the VLOOKUP function in Google Sheets? Read more »
Have you ever faced an issue while working in Google Sheets when you need to convert cost or revenue from one currency to another? It is much easier than you may think because Google Sheets has a special function for …
How to convert currency in Google Sheets by a specific date using Googlefinance formula? Read more »
Supermetrics Facebook Ads add-on for Google Sheets is a powerful tool that allows users to import and analyze Facebook Ads data directly in Google Sheets. In this article I am going to review this add-on and check how it works. …
Supermetrics Facebook Ads add-on for Google Sheets Read more »
Google Sheets is a powerful spreadsheet software that allows you to perform a variety of data analysis tasks. One common task is extracting the month from a date. This can be useful if you need to group data by month …
How to extract month from date in Google Sheets – Tutorial Read more »
While working with Google Sheets, have you ever felt the need to pull the and union data from several tabs into another one? Basically, you can simply link certain tabs to a sheet. But if you work with dynamic data …
If you have ever worked with Looker Studio, you may know that when you connect Google Sheets that contain calculated fields, the values in Looker Studio may be inaccurate. Today I would like to tell you how to calculate ROAS, …
How to calculate ROAS, CTR, CPC correctly in Google Sheets and Looker Studio Read more »
0 items in the cart (0 €)