The future of spreadsheets in the world of finance
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...
Database vs spreadsheet, which one is better?
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....
10 spreadsheet tips and tricks to maximize Google Sheets
10 spreadsheet tips and tricks to maximize Google Sheets Spreadsheet tips and tricks Are you new to Google Sheets? Sheets is an intuitive and accessible piece of online spreadsheet software. Free to use, you can create and edit spreadsheets directly in your web...
Improve the performance of Google Sheets
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...
Business Intelligence on Google Sheets
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...
Scoring spreadsheet: The most important spreadsheet
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...
How to embed Google Sheets in Google Sites
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...
How to solve the #REF! error on spreadsheets
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 spreadsheet users face when trying to share files for...
How to solve the 5 million cell limit in Google Sheets
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...
Data validation on Google spreadsheets
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....