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 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...
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...
BigQuery Data Connector for Google Sheets: How to get more than 10,000 rows
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 Google Sheets Connector If you are using the new BigQuery Google...
How to analyze BigQuery data within Google Sheets
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...
The Explore feature in Google Sheets: How to use it
The Explore feature in Google Sheets: 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...
How to collaborate on Google Sheets
How to collaborate on Google Sheets Google Sheets was built around the fabric called collaboration. Unsurprisingly, all the innovations of this cloud-based application are centered around that idea. Unlike the case with other spreadsheet applications of age, one can...
How location and timezone can affect your Google Sheets
How location and timezone can affect your Google Sheets Unlike other desktop-based spreadsheets, Google Sheets is a cloud-based application that is ubiquitous. It is location and device independent. All we need is a browser and an Internet connection. With such a...
How to color Google Sheets tabs?
How to color Google Sheets tabs? Google Sheets primarily helps us handle information. In fact, a lot of it. Besides providing us with tools that help us reorganize, manipulate, analyze and summarize metrics. Because this cloud-based application lets us store huge...
How do I create macros in Google Sheets?
How do I create macros in Google Sheets? We most commonly use Google Sheets to store data and share it with others. Among other things it also lets us manipulate and analyze data, resulting in accordingly establishing trends etc. For a regular user, the tasks can get...
Google Sheets Keyboard Shortcuts Guide
Google Sheets Keyboard Shortcuts Guide We all know the disruption the mouse enabled graphical user interface brought to the world. It was revolutionary. Without a doubt, navigation within the applications has become a lot more intuitive. However, for a regular user,...