<

New updates on Google Sheets

Published on
4,396 Points
996 Views
4 Endorsements
Last Modified:
Last month, Google released a new update for Google Sheets. This new update offers new ways to visualize and analyze data. Use this article to learn how to take advantage of the new tools now available for charts, cells and collaboration with Google Sheets. 
 

Change the Shape of Data Points

In a line or scatter graph, you can change the shape of your points with the new update.
 
  1. Create a graph with data points.
  2. Go into edit mode. 1EditMode.png
  3. Click on any point on the graph and a toolbar will appear.
  4. From here you can choose a shape from the dropdown menu. 2Plots.png
 

Add Data Labels to your Graph

You can now show the precise value of bars or points.
 
  1. Create a bar or line graph.
  2. Go into edit mode.
  3. Click on any point on the graph and a toolbar will appear.
  4. Select the data label icon.
  5. Choose Value from the dropdown menu. 3Value.png
  6. Your points will now be labeled on your graph with the exact value. 4Valueee.png
 

Preview Formula Results

You can now use a feature to help catch formula errors quickly. This new tool allows you to preview formula results as you type.
 
Once you add a formula into a cell, the preview will be down right above it before you even click enter. 5Preview.png 

Filter by Conditions

With the new update, you now have conditions that you can filter your rows and columns by.
 
  1. Select the column you would like and select Filter from the toolbar above. 6Filter.png
  2. After you select the dropdown menu from the column, choose Filter by condition.
  3. From here, you can choose a condition that will make your sheet only show you the data you want to see. 7FilterLessThan.png
 

Protect Cells

You can make sure that certain people can not edit specific cells or sheets.
 
  1. Select a sheet, row or column.
  2. Select Data from the toolbar and choose Protected sheets and ranges8ProtectCells.png
  3. You can then choose who can edit certain ranges of cells or sheets from the panel on the right.  


Hopefully these new tools help your experience with analyzing and visualizing your data on Google Sheets. 
4
0 Comments

Featured Post

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

This Micro Tutorial demonstrates how to create custom reports and the secrets of determine the metrics and dimensions for your data that works best with your needs.
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month