5 Best practices for spreadsheet data structure
5 Best practices for spreadsheet data structure How good spreadsheet data structure helps you work smarter Spreadsheets are one of the most widely used pieces of software in the world. Over 1 billion people use them to collect, process and present data every day....
Combine QUERY with IMPORTRANGE in Google Sheets
Combine QUERY with IMPORTRANGE in Google Sheets How to use QUERY with IMPORTRANGE Importrange is one of the most useful and powerful functions in Google Sheets. As the name suggests, it imports, or transfers, a range of cells from one spreadsheet to another. Once you...
How to create simple Power BI reports
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...
How to connect Google Forms to Google Sheets
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...
How to connect Google Sheets automatically
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...
How to create a Gantt chart in Google Sheets
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...
How to connect Excel to Google Data Studio
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...
How to upload Excel to Google Sheets
How to upload Excel to Google Sheets 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,...
How to create a Pivot table in Google Sheets
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...
How to create a dashboard in Google Sheets
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...
3 Cool new Google Sheets features in 2019
3 Cool new Google Sheets features in 2019 Create an interactive dashboard in Google Sheets It’s great to see that G-Suite has released three Google Sheets new features to improve data display and reporting. The latest round of updates was announced at Google...