Sheetgo Blog

Your go-to resource for all things spreadsheet related

Event registration form template in G Suite

Event registration form template in G Suite

As an HR manager, managing all company events and employee birthdays can be real chaos. Receiving and approving event attendance requests via email and manually entering or deleting dates from a spreadsheet is incredibly time-consuming and can lead to overlap. Looking...

read more
Company culture template in Google Sheets

Company culture template in Google Sheets

What is company culture? Chances are if you’re reading this article, you’re already attuned to both the importance of having a strong company culture and the world of confusion on how to build one. Let me fill you in. In the simplest of terms, company culture is the...

read more
Holiday tracking in Google Sheets: How to set it up

Holiday tracking in Google Sheets: How to set it up

If you’re an HR manager, managing your team’s annual leave and vacation days can be a real headache. Receiving and approving vacation requests via email and manually entering or deleting dates from a spreadsheet is incredibly time-consuming and can lead to mistakes....

read more
Free budget template in Excel: the top 8 for 2020

Free budget template in Excel: the top 8 for 2020

Looking for a free budget template in Excel? Here we've picked out 8 of the best, available online. This post is written by a guest writer, Anthony Stevens. He is the content specialist for Excel Templates, a resource for free Excel templates including calendars and...

read more
How to filter Google Sheets without affecting other users

How to filter Google Sheets without affecting other users

Spreadsheets are capable of holding a huge amount of information, so it can be a time-consuming—or virtually impossible—task to locate and analyze the data you need. Google Sheets has easy-to-use filters built into the app that you can apply directly to the data. But...

read more
10 Top free marketing tools for Google Sheets

10 Top free marketing tools for Google Sheets

Top free marketing tools for Google Sheets Marketing can be an expensive business. There's a host of comprehensive CRM systems and specialist marketing software out there. Once your company reaches a certain size, it's definitely worth investing in a big integrated...

read more
5 Best practices for spreadsheet data structure

5 Best practices for spreadsheet data structure

How good spreadsheet data structure helps you work smarter Spreadsheets are one of the most widely-used pieces of software in the world. Over 1 billion people use them to collect, process and report data every day. Microsoft created Excel back in the late 1980s and it...

read more
Combine QUERY with IMPORTRANGE in Google Sheets

Combine QUERY with IMPORTRANGE in Google Sheets

How to use QUERY with IMPORTRANGE Importrange is one of the most useful and powerful functions in Google Sheets. As the name suggests, it imports, or transfers, a range of cells from one spreadsheet to another. Once you have moved data with Importrange you can apply...

read more
How to create simple Power BI reports

How to create simple Power BI reports

Creating Power BI reports Power BI is Microsoft's cloud-based data analytics and reporting service. It allows you to build models and visualizations to share insights from advanced datasets. Power BI reports differ slightly from dashboards, but you can create both...

read more
How to connect Google Forms to Google Sheets

How to connect Google Forms to Google Sheets

Harness the power of Google Forms G Suite is a powerful set of online productivity tools and Google Forms is one of the most useful (and often overlooked) apps in the platform, especially if you're working with Google Sheets. You probably think of Google Forms as a...

read more
How to connect Google Sheets automatically

How to connect Google Sheets automatically

Want to connect Google Sheets? Did you know that you can transfer data from one Google Sheet to another, automatically? Google has already revolutionized the way we work with spreadsheets. In the past, spreadsheets were closed, offline files — and many people still...

read more
How to create a Gantt chart in Google Sheets

How to create a Gantt chart in Google Sheets

Manage your projects with a Gantt chart Project managers are often expected to be masters of multi-tasking. But there's a limit to how much information anyone can juggle and retain at one time. And no matter how well you plan a project at the outset, unexpected events...

read more

Subscribe to Sheetgo Blog