Check out all the tutorials of the blog here! There are various of them about Looker Studio and Google Sheets. Formulas, report creation, tricks & tips – everything is in this section.
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 »
Customizing the navigation menu of your dashboard in Looker Studio can help you better organize your reports and make it easier for users to find the information they need. Here are some steps to help you get started. Here is …
How to customize the navigation menu of your dashboard in Looker Studio 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 »
The correctly made report consists of the header, body and the footer. You may have many pages in your report, and recreating headers and footers on every page must be tiring and taking a lot of time! In this Looker …
Page- and report-level elements in Looker Studio – Tutorial Read more »
If you have ever tried working in Looker Studio, you surely have to know how long it takes to set up all the tables and elements to be in the same style. In this Looker Studio tutorial I am going …
How to copy element styles in Looker Studio – Tutorial Read more »
Today I am going to show you the trick in Looker Studio that lets you run a successful data blending in a minute! Here is the video, if you prefer this format: I’ve prepared three charts beforehand – the dimensions …
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 €)