One thing that keeps people on Excel is the ability to use Pivot tables. Google today eliminated one more barrier to migrating to apps by implementing pivot tables today in Google Spreadsheets.
In essence, a pivot table does just that — it allows you to “pivot” or rotate data, thus looking at it from different angles and seeing a variety of patterns which may not be immediately obvious. Let’s take a very simple example of a list of students. This list includes a number of students and some information about them, including gender, class level, and major.
Updates to Spreadsheets are rolling out now.
- How to Create the Elusive Pivot Table With Medians [Excel Tip] (hubspot.com)
- Upload images in Google Spreadsheets (googledocs.blogspot.com)