New in Google Sheets! More Options for Charts, Analyzing Data and Collaboration

Customize Your Charts: 

• Use data labels to display the exact values of bars and points in charts.
• Choose different shapes and symbols for data points in both line and scatter charts.
• Move and resize charts more easily.

Collaborate More Confidently:

• You can restrict who can edit an entire worksheet or range of cells using the protected sheets and ranges feature. 
• To reduce the number of unintended changes (e.g. typos) made by people who have permission to edit, Google now warns individuals who attempt to edit certain cells. 
• Share only specific cells, columns, rows or individual tabs using the ImportRange formula

Analyze Your Data:

• Preview the results of a formula, including any formula errors, instantly as you type.

• Filter rows and columns by conditions, including “less than,” “greater than,” “text contains,” “date after,” and more.

Do More With Pivot Tables:

• Add calculated fields to pivot tables in order to apply formulas to pivot table data.
• Use the GETPIVOTDATA function to retrieve data from a pivot table.