Sheetgo Blog
Your go-to resource for all things spreadsheet related
How to create a dashboard in Google Sheets
Get actionable insights with a data dashboard Think of the last time you needed to check a KPI or another important metric for a report. Searching through a sea of raw data in multiple tabs and multiple spreadsheets is incredibly frustrating. Especially when you need...
Top 5 free Google Sheets inventory templates
Whether you are a small eCommerce business or a major warehouse, inventory matters. You need to have accurate inventory information to make sure you are making the right top-level business decisions. Too much inventory can lead to profit loss, while not enough can...
Inventory lending template in Google Sheets
Does a department in your company lend items internally? Perhaps you have a library in your school that lends books to students. Or an IT department that lends computer equipment to employees. Maybe you run a hire business where you rent items to customers, such as...
Inventory management template in Google Sheets
What is inventory management? Inventory management means tracking your stock levels in real-time. The process involves monitoring every item that either comes in or goes out of your inventory. An inventory is essentially a list of all the items, goods, merchandise and...
Expense tracker template in Google Sheets
Why track expenses? Keeping on top of your team's spending is a key part of budgeting for your business. Rather than waiting to collect a pile of receipts at the end of the month (and possibly getting a nasty shock at how much your team have spent) it's good to be...
Gradebook template in Google Sheets
If you're a teacher, the time-consuming task of monitoring student grades can be very overwhelming, especially when you've got multiple classes and you're grading students on multiple assignments. Many teachers rely on manual systems (and their excellent memory!) to...
Top 5 free Google Sheets sales templates
We all know that that making spreadsheets look nice can be a tedious task. On top of that, it’s difficult to come up with big-picture ideas to figure out how the entire spreadsheet should function, what you want it to do, and what you want it to show. Fortunately, we...
Business unit plan template in Google Sheets
All companies encompass several business units, such as accounting, sales, marketing, R&D, production and HR. When you want to measure your company's overall performance, it's important to analyze the performance of each individual business unit separately. Two of...
Budget vs Actual spreadsheet template in Google Sheets
Budget vs. Actual analysis is a bit like a financial reality check for your business. Formally referred to as "budget to actual variance analysis," this process involves comparing how your planned budget (what you wanted to spend) compares with what you've actually...
Student attendance tracker template in Google Sheets
Busy teachers—this one's for you! Every school or college teacher can name a couple of students who regularly skip class. But when you want to analyze student attendance in detail, you need something better than your memory and a stack of old-fashioned paper...
3 Ways to work less and increase productivity at work
What does productivity at work really mean? It sometimes seems like productivity is the buzzword of our times. Employers want more of it from their employees—and spend a lot of time and money trying to get it. Everywhere you look there's a new app, tool, expert or...
Sales report template in Google Sheets
Sales is a dynamic, high pressure and fast-paced line of work—and when you're busy selling all day, there's little time to sit down and analyze your sales processes and results. But ploughing ahead without analysis and reporting could cost you growth in the long term....