Many users have chosen online office suite Google Docs of Google to replace the software Microsoft Office or WPS Office must be installed on the machine. The Google Docs suite is suitable not only for businesses but also for individual users, helping them to create documents, presentations and spreadsheets for free and fast.
But not every user can take advantage of all the useful features in the Google Docs suite, especially when processing spreadsheets on Google Sheets, including in work and daily life. Let's Download.com.vn discover 10 useful tips when using Google Sheets to create professional, versatile spreadsheets like working with Microsoft Excel.
1. The power of function = IMAGE
With Google Sheets, you can add photos to spreadsheets as upload files. However, the fastest way to insert an image into a spreadsheet is not to manually download the image, but to use the formula = image ("url"). To put it more simply, add the image path online in quotation marks. This is a super simple formula, which helps you to insert many photos into a spreadsheet without spending time manually uploading.
2. Take advantage of available templates
In fact, there are many templates in Microsoft Office and that is also true for Google Sheets. Instead of fiddling with new spreadsheets that don't already have any content or format, you can start right away with spreadsheet templates. Click Create New , then select From Template and find the template that suits your needs.
3. From the cloud to the hard drive
The advantage of storing documents in the cloud is that you can access it wherever you are, as long as you have an Internet connection. But in terms of no network, why? Very simple, in Google Docs, you just need to select the document to be backed up. In the Actions section , select Download and save the file in .zip format. Note that you only have 2GB of document storage in this case.
4. List the entire keyboard shortcuts
To increase productivity when working with Google Spreadsheets, you need to "memorize" the list of shortcuts. Instead of having to memorize manually quite hard, you can call this list using the key combination Command + / (Mac) or Control + / (on Windows) to see the entire list, allowing sports Quickly and accurately work on spreadsheets.
5. Turn on full screen mode (Full Screen)
From the View tab, turn on Full Screen mode and control the entire workbook in Google Sheets to build layouts and proofreading easier.
6. Conditional formatting
Conditional formatting ( Conditional formating ) is the main feature of any software spreadsheets. This is no exception in the case of Google Sheets. You can use this format to color cells in text. This way also helps users see larger data and easily focus on the important information boxes on the spreadsheet.
If you are checking inventory and want to see which categories are below the default, highlight the cells you are dealing with, click the arrow to the right of the column heading and select Conditional Formatting. When opened, you can set the parameters, select the color for each parameter and then click Save Rules to save the rule.
7. Find relevant terms
Instead of using mind maps - tools that are creative and a bit complicated, you can choose Google Sheets in these cases. This is a type of Google Labs add-on called Google Sets , users only need to enter 2 related terms in the same column. Then highlight the whole column while clicking Option (on a Mac) or Ctrl (on Windows). All related terms will appear immediately.
8. Use more currencies
If you are working in the field of finance or simply want to create a spreadsheet related to money, this procedure will be very helpful for you. When you want to use currencies other than the US Dollar, simply highlight the relevant columns, press the 123 button in the toolbar, and scroll down to More Currencies. Select the currency you want to use and you're done.
9. Insert Google Sheets into Docs
If you use Google Docs , you'll find that text can be put into Google Sheets and vice versa. This is easier than you think. For charts in the Google Chrome store , you can insert Google Sheets into Google Docs by opening the Charts add-on in the corresponding menu, clicking Load Data, then selecting and dragging the data you're using. Finally, click Insert .
10. Collecting data is easy
If you're working on a project or need to use a survey to gather information for a spreadsheet, Google Forms is what you need. This is an easy sharing tool and can be embedded in a website by visiting the Forms section and selecting Create a Form. The person who takes the survey only needs to fill in the fields provided. Once completed, data will be added to the top of the spreadsheet, ready for in-depth analysis and processing.
With 10 simple tips above, hopefully you can create Google Spreadsheet spreadsheets and process data and content effectively.