10 tips and tricks in Google Spreadsheet

In recent times, Google Docs is becoming an alternative to Microsoft Office.The first reason is the Google document set that allows writing documents, presentations and spreadsheets directly on the web for free.However, in personal and business daily activities, many people seek additional features to expand the capabilities of Google Docs, and more notably Google Sheets.In this article, I will show you 10 interesting tips and tricks in Google Spreadsheet and you will be surprised about them.

1. Jaw strength = IMAGE

10 tips and tricks in Google Spreadsheet Picture 1

In fact, you can add images from uploaded files in Google Sheets. However, to make it faster, you should use the function = image ("url") , the URL is the image link from the website. This is a function that is not complicated and saves time.

2. Use Templates

10 tips and tricks in Google Spreadsheet Picture 2

You can use Templates in Microsoft Office, and so are Google Sheets. There are a lot of options and this is a great thing to get unique text in Google Docs and especially in Google Sheets. All you have to do is click "Create New" from "From Template" and use it.

3. From Cloud to hardware

10 tips and tricks in Google Spreadsheet Picture 3

Saving documents on Cloud can be a great way to access documents when offline but not the best. If you want to save the document on Google Docs as a file, this is a useful tip for you. Select the document you want to backup. Select "Download" under "Actions" , so you have the file you want with the .zip file format. Note the file limit is 2GB.

4. List of shortcuts

10 tips and tricks in Google Spreadsheet Picture 4

Shortcuts are the best way to work quickly. Press Command + "/" (in Mac) or "Ctrl" + "/" (for Windows), shortcuts will show up and you can use them to complete the job in a snap.

5. Full screen

10 tips and tricks in Google Spreadsheet Picture 5

You are often distracted by things around. When working in a collective environment, you will often be confused by distraction. In addition, there are troubles appearing on the computer screen. Google Docs will help you solve this problem. Under the "View" bar, select "Full Screen" and now, you can rest assured to focus on creating great spreadsheets on Google Sheets.

6. Conditional formatting

10 tips and tricks in Google Spreadsheet Picture 6

Conditional formatting is an important feature in spreadsheet programs, and not except Google Sheets. Today, we will focus on setting conditional formatting to color the cells in the document. Because the conditional formatting is used for large spreadsheets, use a coloring tool to help you view large amounts of data easily to handle it.

If you are inventorying and want to see the products as a set number, you need to check the boxes and click the arrow to the first right of the column and select "conditional formatting" . A new window will appear, you can set the parameters and select the color corresponding to each parameter, then "save rules" .

7. Related words

10 tips and tricks in Google Spreadsheet Picture 7

If you are like me, you will use many mind maps to create and edit at that time. With Google Sheets, you will get rid of that case. Use Google Labs settings like Google Sets, simply type two related words in the box. Then, select the entire box while selecting "option" in Mac or "Ctrl" on Windows. Related words begin to appear.

8. Add currency

10 tips and tricks in Google Spreadsheet Picture 8

You work financially or simply need to create a spreadsheet with some kind of money, this is the tip for you. If you need to enter other non-dollar currencies simply highlight the boxes, select the "123" button on the toolbar and select "More Currencies ". Click on the currency you want and that's it.

9. Insert Google Sheets into Docs

10 tips and tricks in Google Spreadsheet Picture 9

You are a Google Docs user, so you have tried to turn your text documents into Google Sheets and vice versa. To do this easily. With Charts in Google Chrome store, you can insert Google Sheets chart into Google Docs by opening the "Charts" utility in the expanded menu, selecting "Load Data" , clicking and selecting the data you need to use "Insert " .

10. Gather information more easily

10 tips and tricks in Google Spreadsheet Picture 10

If you are conducting a project or survey to gather information into a spreadsheet, Google Forms is what you are looking for. You can easily share and can even upload to the website by "Forms" then "Create a Form ". From there, individuals fill in their answers there and when completing the survey, the results will be added to the top of the worksheet you are using.

I hope, you can apply the tips and tricks learned today to work and have great spreadsheets.