The future of spreadsheets in the world of finance
It seems like yesterday for the old timers, or just the distant past to more recent newcomers, but spreadsheets have been around for very long. Spreadsheets have replaced paper-based systems throughout the business world. They were first developed for accounting or...
Database vs spreadsheet, which one is better?
The comparison of database vs spreadsheet plays a huge part in the daily operations of many businesses. Understanding the key differences between them is vital if you want to make the best use of either or both of them. Spreadsheets and databases involve different...
How to upload Excel to Google Sheets
“How to upload Excel to Google Sheets” is a guest post by Kasper Langmann from Spreadsheeto. The text had been revised by Jonatan Silva from Sheetgo. Google Sheets is great for collaborative work, but sometimes you like using Excel for the initial development. Have no...
10 spreadsheet tips and tricks to maximize Google Sheets
Spreadsheet tips and tricks Why would you need spreadsheet tips and tricks? A lot of people have already chosen to work with Google Sheets. One of the reasons for this change is that with Google Sheets, you can create and edit spreadsheets directly in your web...
Improve the performance of Google Sheets
As one of the major players in the internet realm, Google provides a variety of services — among them a spreadsheet software named Google Sheets. With this software, Google aims to outcompete other spreadsheet software providers and in particular Microsoft with their...
Business Intelligence on Google Sheets
Business Intelligence is the collective knowledge of the hive. It is a technology-driven process of analyzing existing data and organizing actionable information. It is used to help managers and executives make strategic decisions for a firm. Google Sheets business...
Scoring spreadsheet: The most important spreadsheet
Let’s talk about scoring spreadsheets. Since my very first job, I have always used spreadsheets as a tool to complete tasks. As I have always worked in small companies, Microsoft Excel was not an option because you have to pay for it. Not only is Google Sheets free,...
How to embed Google Sheets in Google Sites
Google Sites is a tool that allows you to follow the metrics of your business. At Google Site, you monitor the data from your Google sources: Google drive, Google Sheets, Google Slides, docs forms, etc. It stands to reason that if your business uses Google tools, then...
How to solve the #REF! error on spreadsheets
How to solve the REF Google spreadsheet error Can there be anything more annoying than getting #REF! error in the cells of your spreadsheet? The biggest problem Excel users face when trying to share files for reporting purposes is the fact that, unless those files are...
How to solve the 5 million cell limit in Google Sheets
At Sheetgo, we work with many clients using Google Sheets, and quite frequently they experience errors. After analyzing all the errors, one of the most frequently reported problems refers to the Google Sheets cell limit of 5 million. What happens if you are close to...
Data validation on Google spreadsheets
I used to work in a company that had built up an entire ERP on top of spreadsheets. We had moments when many different personnel were inputting data—while the manager was creating reports and doing analysis at the same time. Spreadsheets offer a lot of freedom, but...