Sheetgo Blog
Your go-to resource for all things spreadsheet related
How to create simple Power BI reports
Creating Power BI reports Power BI is Microsoft's cloud-based data analytics and reporting service. It allows you to build models and visualizations to share insights from advanced datasets. Power BI reports differ slightly from dashboards, but you can create both...
How to connect Google Forms to Google Sheets
Harness the power of Google Forms G Suite is a powerful set of online productivity tools and Google Forms is one of the most useful (and often overlooked) apps in the platform, especially if you're working with Google Sheets. You probably think of Google Forms as a...
How to connect Google Sheets automatically
Want to connect Google Sheets? Did you know that you can transfer data from one Google Sheet to another, automatically? Google has already revolutionized the way we work with spreadsheets. In the past, spreadsheets were closed, offline files — and many people still...
How to create a Gantt chart in Google Sheets
Manage your projects with a Gantt chart Project managers are often expected to be masters of multi-tasking. But there's a limit to how much information anyone can juggle and retain at one time. And no matter how well you plan a project at the outset, unexpected events...
How to connect Excel to Google Data Studio
How to import data from Excel to Google Data Studio Google Data Studio is a powerful visual reporting tool that allows you to transform a sea of raw data into engaging and interactive dashboards and charts. The user-friendly pre-built data connectors mean you don't...
How to upload Excel to Google Sheets automatically
Microsoft Excel has dominated the spreadsheet world for decades, but many users are now moving to Google Sheets. Sheets is great for collaboration. As it’s an online application, anyone can access a spreadsheet via their browser, multiple users can work in the same...
How to convert Google Sheets to Excel automatically
Do you frequently need to convert Google Sheets spreadsheets to Excel format? When it comes to spreadsheet software, opinion is fairly divided on which option is best. Google Sheets is rapidly growing in popularity. Because it's online, Sheets is incredibly flexible,...
How to create a Pivot table in Google Sheets
What are pivot tables? Pivot tables are a powerful tool to help you extract and analyze the information you need from a large data set. They're an easy way to "slice and dice" data in spreadsheets: in other words, to filter and then group that data. For example, you...
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...