Sheetgo Blog

Your go-to resource for all things spreadsheet related

Inventory Management: Definition and Best Practices

Inventory, in simple terms, is the list of goods in stock. For any organization, it is crucial that they keep tabs on the levels of their inventory at any given point in time. And that they keep their inventory in line with the present and projected demand for their...

read more

How to Manage Workflows in Spreadsheets

A workflow is a predefined sequence of steps that we can use to get our work done with. The best part about a workflow is that we can illustrate the process in the form of a sequence diagram. In the context of spreadsheets, how relevant are workflows? Can we...

read more

How to Analyze BigQuery Data Within Google Sheets

What is BigQuery? BigQuery is Google's solution to enterprise-level data storage. It is a cloud-based service that offers rapid SQL querying for big data at an affordable price. Because it is a Google product it is reliable, secure, and always improving. With...

read more

How to Get Data From BigQuery to Google Sheets Automatically

What is the BigQuery Data Connector for Google Sheets? BigQuery connectors allow users to integrate BigQuery with other platforms—either data sources or analytics tools. Google recently launched a BigQuery connector for Google Sheets which allows greater accessibility...

read more

Best of 2018: Sheetgo’s top 10 blog posts

Let's get ready for 2019...We want to look back on an amazing Sheetgo year by presenting you with the top 10 blog posts that provided you with tips and tricks on how to use Google Sheets and all its possibilities, but also the extremely handy Sheetgo Templates that...

read more

Automated Income Statement Template for Google Sheets

What is the Income Statement Template? The income statement is one of the three main Financial Statements that a company must maintain. It summarizes your revenues and expenses over a period of time. It differs from a Cash Flow Statement in that it is based on the...

read more

Company Budgeting Template in Google Sheets

Overview of Sheetgo’s Budgeting Template This system is designed for a CFO or controller to collect budget inputs from a company's department head so that they can create a company-wide budget. It includes a central budget for the CFO / controller and individual...

read more

Data filters and sorting in Google Sheets

Google Sheets is capable of holding huge data sets. But huge data can mean difficulties with handling it. Especially in terms of organizing it in a way that we can traverse through easily. In this article, we will explore the data filters and sorting methods that will...

read more

How to use ProjectSheet Planning add-on for Google Sheets

How to use ProjectSheet Planning add-on for Google Sheets ProjectSheet planning is a template made by forScale, a company that creates easy-to-use, effective technology for project management. ProjectSheet planning is an add-on for Google Sheets—use it to...

read more

How to use XLMiner Analysis ToolPak add-on for Google Sheets

How to use XLMiner Analysis ToolPak add-on for Google Sheets Excel fans turned Google Sheets users can rejoice. XLMiner ToolPak is another add-on that increases the power of Google Sheets. When Google first launched Sheets, it changed the game for many spreadsheet...

read more