<

New updates on Google Sheets

Published on
4,332 Points
932 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
Comment
0 Comments

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Join & Write a Comment

Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial will demonstrate the easy use of Gmail embedding images in your email so the recipient of your email can view them in context.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month