HomeApplicationOffice information

Use Pivot Table in the Google Docs Spreadsheet

TipsMake.com - This week, Google Docs has officially announced the Pivot Tables - Excel's missing feature for a long time. This process is really useful when you have a spreadsheet with huge amounts of data, and you have to create general statistics, with a mechanism that works on rotation, retrieves information from many different angles.

Sample instruction video:

Specifically, we will show more specifically in the steps below. First, you need to prepare a fairly large amount of data, which can be taken from examples on the Internet:

Use Pivot Table in the Google Docs Spreadsheet Picture 1
In this example, our number of records is about 10,000

Next, select everything in the spreadsheet (including all rows and columns), then click Data> Pivot Table Report:

Use Pivot Table in the Google Docs Spreadsheet Picture 2

Google Docs will automatically assign a new table (displayed in the lower left corner of the browser) with the name Pivot Table 1 , and notice the new Report Editor tool displayed on the right. This function works like building a general spreadsheet with small scale, users just need to select the corresponding lines and columns, and then the data will be filled in.

Use Pivot Table in the Google Docs Spreadsheet Picture 3
Note that you only need to select the necessary pieces of information

When you assign the Values parameter to the Pivot table, change the settings in the Summarize by section. If you only want to display general statistics, select the COUNTA function:

Use Pivot Table in the Google Docs Spreadsheet Picture 4

With such basic and effective features, Pivot table is the best tool for handling documents with huge amounts of data. Although this setup process is quite new and simple, it cannot replace Microsoft Excel or Open Office:

Use Pivot Table in the Google Docs Spreadsheet Picture 5

Good luck!

4 ★ | 1 Vote
Tutorialstechniquessettingstoolssupportgoogle docsonlinespreadsheet

You should read it

May be interested

  • PIVOT clause in SQL ServerPIVOT clause in SQL Server
    in sql server (transact-sql), the pivot clause allows cross tabulation to pass data from one table to another.
  • How many of the best features have you missed on Google Docs?How many of the best features have you missed on Google Docs?
    google docs not only has a simple utility for you to edit, edit or share documents, but it also has many other unique features. these features will make your writing faster.
  • Useful tools to know in Google DocsUseful tools to know in Google Docs
    google docs is an online application for writing, editing, managing and sharing powerful google documents. you can consult some of the tips below to use google docs more effectively.
  • How to Create Pivot Tables in ExcelHow to Create Pivot Tables in Excel
    pivot tables are interactive tables that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. they can sort, count, and total the data, and are available in a variety...
  • How to Create a Brochure Using Google DocsHow to Create a Brochure Using Google Docs
    you can access google docs for free and easily, this service is very useful for those who want to create brochures (brochures). there are also templates available on docs for you to use. however, you can completely set up other formats to suit your needs. use column, table, and text dialog boxes to customize your brochure. let's start from step 1.
  • How to insert Google Sheets tables into Google DocsHow to insert Google Sheets tables into Google Docs
    inserting tables from google sheets into google docs is easy and you can also change the format for the table.
  • How to Create a Budget Spreadsheet in Google SheetsHow to Create a Budget Spreadsheet in Google Sheets
    google sheets helps you create a budget management table through a number of spreadsheet templates. then you just need to fill in the data into the budget spreadsheet on sheets.
  • 12 steps to pivot startup12 steps to pivot startup
    if many pivot startup startups, there may be more startups. pivot is a secret to survive. learning how to pivot will help you save your startup from failure and keep growing for a long time.
  • How to insert link links in Google Docs documentsHow to insert link links in Google Docs documents
    inserting links in textual content google docs lets you access the web more quickly, easily or cite articles in google docs at any time.
  • How to insert musical note notation in Google DocsHow to insert musical note notation in Google Docs
    google docs provides users with a symbol table for us to use and insert symbols into docs documents. for example, you can insert musical notation in google docs.

Office information