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
BigQuery Data Connector for Google Sheets: How to Get More Than 10,000 Rows
We highly recommend you to read our blog “Analyze BigQuery Data Within Google Sheets” before reading this one. The New BigQuery Data Connector for Google Sheets If you are using the new BigQuery Data Connector for Google Sheets, you are probably loving how you can...
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
The Explore feature in Google Sheets: what is it and how to use it
Most of us work with loads of data on our spreadsheets. Wouldn't it be nice to have an assistant that can help intuitively help us with our work, so that we can speed it up? The Explore feature in Google Sheets does exactly that. It intelligently gathers the context...
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