Out Of Tech

how to make pivot table in excel and google sheet

Confused about how to easily process hundreds to thousands of data in Excel? No need to worry, see the following article to find out how to make a pivot table

Processing hundreds to thousands of data, especially in the form of numbers, is a very difficult thing. You need full concentration and a keen eye for even small mistakes can be fatal, gang.

Table processing software Microsoft Excel is now more sophisticated and practical. Unfortunately, there are still many who do not understand how to maximize the features embedded in it.

One of the coolest and most useful features of Microsoft Excel is Pivot Table. In this article, ApkVenue will review in full about how to make a pivot table in Excel easily.

How to Create a Pivot Table in Excel

Pivot tables are a Microsoft Excel feature that allows users to quickly retrieve information from large data sets. Pivot Tables can be used as an alternative to perform data analysis related to grouping and summarizing data.

If the number of your data is only tens, it may not feel. However, this feature is very useful when you are writing a thesis or working in an office that often requires you to process large amounts of data in a short time.

Curious about how to create an Excel Pivot Table and Pivot Table formulas? Just take a look at the following Jaka tutorial, gang!

Step 1 - Setting Up the Table

  • Before you create a Pivot Table, of course you must prepare the base table first. The table that you create does not need to be as good as possible, the important thing is that it is neat and thorough.
Microsoft Corporation Office & Business Tools Apps DOWNLOAD
  • If you are confused about what kind of table you want to make, you can use the following Jaka table example for practice. Don't forget to also enter Excel formulas so that the calculations in the table become practical.

Step 2 - Creating a Pivot Table

  • After your table is ready, Jaka will teach you how to easily create a pivot table. Table block by left-clicking and dragging until the cursor covers the entire table area.
  • Click on the ribbon Insert located at the top of your spreadsheet page. After that, click PivotTable to bring up a menu that will help you create a Pivot Table.

  • In the window that appears, you will find several options that look confusing. But you don't need to worry because it's actually not that complicated, really.

  • Click option Select a table or range. If you have previously blocked the table you want to analyze, then in the column Table/Range will be automatically listed the location of the table that you have created.

  • If you want to analyze data in a table in the same worksheet as your table, select the option Existing Worksheet, then decide where you will put the Pivot Table.

  • Jaka's suggestion, determine the location of the Pivot Table a few rows below your previous data table so that it is easier for you to organize the data. Click OK if you are sure about the Pivot Table options.

  • After you confirm the location of the Pivot Table, you don't need to be confused if your Pivot Table is empty. You just have to look at the right side of the screen, to be precise, the column PivotTable Fields, then put a tick on the column you want to appear in the pivot table.

Step 3 - Filtering Data in Pivot Table

  • As Jaka said at the beginning, Pivot Tables are very useful if you want to analyze data that amounts to hundreds to thousands. Not only for sales reports, you can also use pivot tables for inventory and other things.

  • To make it easier for you to analyze the data, then you have to start filtering the data. To do so, click the down arrow button on Row Labels, then select the field you want.

  • For example, Jaka wants to analyze stationery sales data on a certain date. Click the Date option in the field, then tick the date you want to analyze specifically.

  • After you finish sorting the data by date, your Pivot Table will change to something like the following image:
  • On the other hand, if you want to analyze data, for example by type of goods; you just click on Row Labels again, then select the Item Name option in the field, then tick the type of item you want.
  • After you finish sorting the data by item name, your Pivot Table will change to something like the following image:
  • Suppose you want to know how many pencils were sold and the sales results specifically on April 3, 2020, look at the bottom right of your worksheet, exactly below the column PivotTable Fields.

  • There are 4 boxes with 1 empty space in the Filters column. Click the Date menu under Rows, then drag and drop (Click & Drag) in the Date column.

  • Set the Date and Item Name options as you wish. Voila! Your data is now more specific and easier to process.

How to Create a Pivot Table in Google Sheet

Google Sheets or Google Sheets is a free service from Google that allows you to create, edit, and access spreadsheets like Excel online and at the same time.

Google Sheets can be an option for those of you who want to create a pivot table but don't have Microsoft Excel software on a laptop or PC. How How to make a pivot table in Google Sheet? Come on, see the gang!

Step 1 - Setting Up the Table

  • The first step in creating a pivot table in Google Sheet is setting up the table you want. How to operate it is quite similar to Excel, only with a few modifications.

  • Enter site address //www.google.com/docs/about/ in the browser search field. Click on tab Sheet which is at the top left of the page.

  • To be able to access Google Sheets for free, select the option Personal. After that, login with your Google account. Create a table by selecting Blank on Start a new spreadsheet.

  • If you want to try the pivot table feature on Google Sheets but don't have your own table, you can use an example of the table that Jaka created as shown in the image below:

Step 2 - Creating a Pivot Table

  • After the table is ready, now is the time for you to create a pivot table, gang. First of all, click on the ribbon Data which is at the top of your screen. In the menu that appears, select Pivot Table.

  • If you want to create a pivot table in the same spreadsheet, select Existing Sheet. After that, select the location where you want to place the pivot table by selecting the icon with the window shape.

  • Click on the column you want. Jaka's suggestion, put the pivot table a few boxes below the table that you created earlier. When finished, select OK.

  • Your pivot table will appear, it's just that no data has appeared. Look to the right of your screen and look for it PivotTable Editor.

  • Enter Row, Columns, and Value as you want. For example, Jaka wants to know the total sales every day, then Jaka sets the pivot table editor as follows:

  • After you set up the pivot table editor, then in your spreadsheet a table like this will appear, gang.

That's Jaka's article on how to easily create a Pivot Table in Excel and Google Sheets. Hopefully this article can help you in your work and assignments, well!

See you again in other Jaka's interesting articles. Don't forget to leave a comment in the form of a comment in the column provided.

Also read articles about Out of Tech or other interesting articles from Prameswara Padmanaba