Make PIVOT TABLE in EXCEL- How to make, insert and modify Pivot table - Tutorial

Published: 07 August 2015
on channel: now Y know

3,715

Make Pivot table in excel tutorial. Learn how to make, insert, modify and use EXCEL pivot table, to organize properly your reports and visualize your data in an extremely useful and impressive way !

A pivot table is especially useful with large amounts of data. For example, a store owner might list monthly sales totals for a large number of merchandise items in an Excel spreadsheet. If the owner wanted to know which items sold better in a particular financial quarter, it would be very time-consuming for her to look through pages and pages of figures to find the information. A pivot table would allow the owner to quickly reorganize the data and create a summary for each item for the quarter in question.
PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to create and customize them.

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a pivot table can automatically sort, count total or give the average of the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.

How to Create an Excel Pivot Table :

There are several ways to build a pivot table. Excel has logic that knows the field type and will try to place it in the correct row or column if you check the box. For example, numeric data such as Precinct counts tends to appear to the right in columns. Textual data, such as Party would appear in rows.
While you can simply check fields to display and let Excel build your pivot table, I prefer to use the “drag and drop” method. This is partly because I like to visualize my data in columns and rows. I think it may also be easier if you have fields, which can appear to be numbers like a precinct value.
1. Open your original spreadsheet and remove any blank rows or columns.
2. Make sure each column has a heading, as it will be carried over to the Field List.
3. Make sure your cells are properly formatted for their data type.
4. Highlight your data range
5. Click the Insert tab.
6. Select the PivotTable button from the Tables group.
7. Select PivotTable from the list.
8. Double-check your Table/Range: value.
9. Select the radio button for New Worksheet.
10. Click OK.

This is a free on line video tutorial about how to learn MS office and how to use MS office in an easy to learn way. In particular, in this free excel tutorial, you will learn how to use Microsoft excel, how to implement Microsoft excel tips, how to make and how to do specific things in excel, how to analyze numbers and perform data analysis with MS excel and MS office. This online, video free tutorial, is suitable either for beginners in excel and/or for advanced excel learning and refreshing. Watch this video and gain professional knowledge in data analysis and practical organizational skills in an easy way.

Being able to analyze all the data in your worksheet can help you make better business decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. Excel can help you by recommending and then automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data.

Pivot tables are one of Excel's most powerful features. In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a pivot table can automatically sort, count total or give the average of the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.

In this video tutorial about pivot tables in excel 2010 you will learn how to insert and modify pivot tables. How to move the Pivot Table field list, choose fields to include in your Pivot Table, format your Pivot Table, group dates, apply filters, stop auto fit columns, remove column/row labels, apply Pivot Table styles, change your Pivot Table layout, and drill down to detail.

For more and more remember to subscribe !!!
Have Fun !!

On this page of the site you can watch the video online Make PIVOT TABLE in EXCEL- How to make, insert and modify Pivot table - Tutorial with a duration of hours minute second in good quality, which was uploaded by the user now Y know 07 August 2015, share the link with friends and acquaintances, this video has already been watched 3,715 times on youtube and it was liked by 10 viewers. Enjoy your viewing!

51,140