google-sheets

6 Google Sheets tricks to improve your reports

You have collected data about your latest marketing campaign or from last year sales data. You need to figure out the trends and turn them into reports. How can you do that in a way that is not very complicated and time consuming?

Google Sheets is a totally free online tool that allows you to create and edit in collaboration with others to facilitate teamwork. This has become a perfect tool for marketers at the time of making reports and other activities.

Tricks to use Google Sheets

Below, you find some essential tricks that will help you make reports in an easier and more effective way:

Create a heat map with conditional formatting

Creating a heat map on Google sheets is a great way to highlight relevant points of information so you and your team can identify them quickly and easily. A heat map can draw the attention to the highest values of the report (highlighted in one color) and show the lowest values in another color. All intermediate values could be presented in another color.

How this work? Here we will show you how to create a heat map step by step.

Step 1: Select your information, select from the top menu bar: Format. Then, select “Conditional Formatting.”

After that, you need to choose the “Color Scale” tab from the menu above. Once you do that, Google Sheets will automatically apply default colors, and you will be able to see your heat map. You can change the colors whenever you want it.

Add images to the cell

You could also add images on your Google Sheets reports. To do so, you have to select “insert” in the top bar, then choose “image” and upload the image from your computer. There is another also another way that is much faster.

First, select the cell where you want to insert the image and type “= image”. After that open a parenthesis, followed by quotes and paste the URL of the image you want to place. Then you need to close the quotes and close the parentheses. Lastly, press enter, and the image will show up.

Create data visualization

After you have collected all the data you need, you can create a new sheet and label it “Dashboard” and use all the data to create visualizations. All you need to do is click the “insert chart” button in the navigation. Choose the visualization of your preference and customize as needed.

Set email notifications

Do you want to send a report to your team or to a stakeholder? You can also use Google Sheets to do that. Here is the trick. Go to “Tools” at the top of the browser and select “Notification Rules”. Then, select the notification rules you want to place and save the changes. Done it

Create QR codes

You can also create QR codes in Google Sheets. Firstly, you open up a Google Spreadsheet. In A column, insert the website links (a different cell for each website). In B column, insert this formula =if(isblank(A1), “BLANK”, image(“https://chart.googleapis.com/chart?chs=150×150&cht=qr&chl=”&A1))

Copy the formula down. After that, just print the QR Codes, attach them to your products and they are ready to be scanned.

Add international currencies

If your company have foreign providers or customers, knowing how to place other currencies in your reports is quite important. Luckily, Google Sheets makes this task easy for you. To access the massive Google Sheets coin list, you have to click on the “123” icon in the browser above. From there go to “More Formats” and to “More Currencies”. Then you have to select the type of currency you prefer from the list and click on the blue “apply” button.

 

DataScope-LOGO-300x75

 

DataScope is a platform which allows various industries to streamline, organize and evaluate the work of their field staffs thanks to online forms which provide real time indicators 100% adaptable to any field.

Learn how to stop using paper today!



Leave a Comment

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Learn how to stop using paper today!