Sheetgo Blog
Your go-to resource for all things spreadsheet related
Track Google Classroom attendance automatically
We all know how working from home can be difficult. But for teachers, it's an even bigger challenge. They are used to creating their classes and teaching right in front of their students, delivering a very personal and interactive course. Recently, however, we've seen...
10 Remote work productivity templates in Google Sheets
Working from home, or working remotely, can come as a big shock if you haven't done it before. And if you're a manager, maintaining team cohesion and keeping projects on schedule poses an even bigger challenge. Luckily, the recent growth in cloud-based software (tools...
Working remotely: 15 ways to keep your team connected
"Distributed teams", "location-flexible", "telecommuting", "WFH" (working from home). A whole new language for a whole new way of working. Many of us had never even heard of these terms until a few weeks ago and now thousands of teams around the world are scrambling...
Inventory with barcode scanner system in Google Sheets
Forget expensive inventory software. There's absolutely no need to invest time and money into a complex system to create an inventory with barcode scanner system. Instead, use the product you and your team are most familiar with: spreadsheets. Sheetgo connects your...
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...
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...
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....
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...
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...
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...
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...
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...