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
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 Cloud Next 2019 and the gradual rollout...
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 Sheets Connector, you are probably loving how you can extract your enterprise...
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 reliable, secure, and always improving. With...
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 exactly that. It intelligently gathers the context...
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 access Google Sheets without the...
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 grand proposition of being able to serve people all over the...
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 data, the concept of worksheets makes...
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 repetitive and time-consuming leading to...
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, using a mouse to work on Google Sheets...
How to only temporarily share your Google Sheets files?
With Google Sheets, we know we can easily share the spreadsheets with people. And they can effortlessly access and work on them from any device or location. It is noteworthy to see that the Google Sheets’ Share functionality, by default, lets people access the files...