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!
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 …
Google Sheets offers plenty of functions to handle dates efficiently, making it an indispensable tool for organizing schedules, tracking deadlines, and analyzing trends. Among these functions, DATE() and EOMONTH() stand out for their versatility and utility. In this tutorial, we’ll …
How to get first day of month in Google Sheets? EOMONTH() function Read more »
Are you seeking a straightforward method to showcase the day of the week as text in your Google Sheets? Whether you’re creating schedules, tracking deadlines, or analyzing trends, presenting the day of the week in textual format enhances clarity and …
How to show the day of the week as a text in Google Sheets? Read more »
Do you still determine the first day of the week in your Google Sheets documents manually? Luckily, there’s a straightforward solution that doesn’t require complex functions or scripts. By harnessing the power of the MOD() formula, you can effortlessly calculate …
Are you ready to become a pro at calculating date differences in Google Sheets? From tracking project timelines to managing personal schedules, understanding how to find the difference between two dates in Google Sheet is a fundamental skill. Fortunately, Google …
How to calculate differences between dates in Google Sheets? Read more »
In the realm of Google Sheets, the EDATE formula stands out as a powerful tool for date manipulation. Whether you’re a seasoned spreadsheet aficionado or just starting out, understanding how to leverage this formula can significantly enhance your data management …
How to Add Months to Date in Google Sheets? EDATE () formula Read more »
0 items in the cart (0 €)