{"id":160808,"date":"2018-03-23T14:37:28","date_gmt":"2018-03-23T13:37:28","guid":{"rendered":"https:\/\/zenkit.com\/blog\/6-things-you-can-do-on-google-sheets-that-maybe-you-didnt-know\/"},"modified":"2025-10-10T11:18:43","modified_gmt":"2025-10-10T09:18:43","slug":"6-things-you-can-do-on-google-sheets-that-maybe-you-didnt-know-of","status":"publish","type":"post","link":"https:\/\/zenkit.com\/de\/blog\/6-things-you-can-do-on-google-sheets-that-maybe-you-didnt-know-of\/","title":{"rendered":"6 Things You Can Do On Google Sheets (That Maybe You Didn\u2019t Know)"},"content":{"rendered":"

\"How<\/p>\n

To the untrained eye, Google Sheets is merely a bunch of rows and columns where numerical data is stored. But for those who know their stuff, it can be a thing of beauty<\/a>. While we won\u2019t be teaching you how to create artistic masterpieces using your worksheet (that\u2019s a whole other topic) we will be highlighting six cool things that you can do on Google Sheets.<\/p>\n

\"Google<\/figure>\n

Google Sheets is a cloud-based spreadsheet<\/a> offered as part of Google\u2019s Google Drive<\/a> service along with Google Docs and Google Slides. Just like other spreadsheets, it stores data in a tabular format as an electronic document, simulating a paper worksheet. Unlike its rival, Microsoft Excel, it’s free to use and no installation is required. All that is needed to use Google Sheets is a working internet connection and a web browser.<\/p>\n

\n

The Collaborative Tool of Choice<\/strong><\/h2>\n

Along with the other Google Drive apps, Google Sheets is most notable for its collaboration<\/a> features. So refined are they, that you can select the level of access a user has to a worksheet. This is handy for times like when a project manager wants to share data with their team<\/a>, however, doesn\u2019t have to grant them editing access to the document.<\/p>\n\n\n\n\n\n

\n\n \"custom\n

Stop juggling multiple tools and spreadsheets.
\nTry our all-in-one project management software for free now!
\n<\/a><\/p>\n <\/div>\n\n \n

Used as the tool of choice for many teams<\/a> and group work activities, its ability to allow users to collaborate with other users on a worksheet in real-time is what takes the cake.<\/p>\n

The beauty of having real-time collaboration features means that gone are the days of having to constantly save and send files to colleagues when working on a group project. Now, everyone can work simultaneously, and changes can be made by those who have access to the worksheet. These changes can be made on any device, as the app is available on smartphones and tablets<\/a>, as well as on desktops.<\/p>\n

Another major plus of Google Sheets is its automatic saving feature that offers perpetual backup without needing to click the \u2018save\u2019 button\u200a\u2014\u200athis basically means that even if your device crashes while you\u2019re in the middle of working, all your data is saved!<\/p>\n

\n

Things You Can Do On Google Sheets<\/h2>\n

You already know how to create a spreadsheet in Google Drive, but did you know that you can do the following things as well\u2026<\/p>\n

1. Ask it questions<\/strong><\/h3>\n

Google Sheets amplified its Explore<\/strong> functionality in its update last year. Its improved machine-learning abilities mean that you can now ask it natural language questions, such as \u201cwhich month had the highest total profits?\u201d, through a simple click of the Explore<\/strong> button. It will then analyze your data, and extract the digits that answer your question best.<\/p>\n

2. Create Waterfall charts<\/strong><\/h3>\n

Good news for those who engage in linear, sequential project methodologies<\/a>, as if Gantt charts<\/a> weren\u2019t already enough, Google Sheets now gives you the option to create Waterfall charts. All it takes is highlighting your data, then clicking Insert > Chart<\/strong>, and selecting the Waterfall option.<\/p>\n

\n

\"Screenshot
Google Sheets: a handy tool for your next\u00a0project<\/figcaption><\/figure><\/figure>\n

3. Uncover\u00a0insights<\/strong><\/h3>\n

Pivot tables can be generated by asking Google Sheets natural questions, or created from scratch. How it works is that it will propose tables based on your existing data, offering you various ways to visualize your numeric information, making it easier to uncover insights.<\/p>\n

4. Produce QR\u00a0codes<\/strong><\/h3>\n

Whether you were after an employee ID or a ticket of attendance for an event, users can now create QR codes directly from Google Sheets through add-ons. Once added, multiple QR codes can be generated by clicking on a range of values in your worksheet, and then saved into your Google Drive.<\/p>\n

5. Speed up your\u00a0workflow<\/strong><\/h3>\n

Sometimes taking the scenic route isn\u2019t always the best option, like when it comes to stimulating efficiency and meeting deadlines at work. Google Sheets offers keyboard shortcuts so that you can navigate, format, and use formulas in a more streamlined way. Some examples of common shortcuts are:<\/p>\n