#HOW TO FORMAT PIVOT TABLES IN EXCEL 2013 HOW TO#

absolute reference and array averageifs cell cell address cell format cell formula cell reference cell selection Change shape comment box shape change Conditional Formatting count counta countblank countif Countifs ctrl+1 data analysis database data entry data entry form data validation dynamic range enhance excel form Excel tip Excel tips feature form format painter formula function Highlighting with colors how cell reference how to increase cell how to make formulas invisible Hyperlink Hyperlinks If increase Index indirect logical lookup Match offset or paste special pivottable pivot table Product protection Rand Randbetween random random dates Random numbers random text reference selecting sheet protection shortcuts speak split Split windows statistical sum sumifs summary Templates tips Vlookup worksheet protectionД®nter your email address to follow this blog and receive notifications of new posts by email.By distributing the fields into the relevant areas, you are creating the actual pivot table.

If you have any queries regarding this post, please post it on the forum.Д¬hart Database function Datetime Excel Features Excel Tips Formatting Formulae Logical Lookup&Reference functions Shortcuts Statistical functions Templates Text functions I hope you will learn it easily and play with it. We can easily summarize enormous amounts of data with a Pivot Table without using a formula. Pivot tables are very powerful and easy to use. Just change some amount in any month, say in January month, and put your cursor on the Pivot Table and press keyboard shortcut Alt+JT+F+A. If you want, you can change the number format to currency as it looks relevant.ДЇinal Step: Go to Pivot Table Tool tab вЂ“> DesignвЂ“> Report LayoutвЂ“> Show in Tabular form. In the custom name field type вЂњ AmtCollectedвЂќ.ДЄnd select sumfrom the below scroll area as we want the sumof the Amount in a month. Step 11: Repeat the process for SumoftheAmount. Step 10: In the custom name field type вЂњ NoOfChequesвЂќ as this is more meaningful.ДЄnd select countfrom the below scroll area as we want the countof the cheques in a month. Step 9: Just double click on the heading вЂњ SumofRefNoвЂќ,a dialog box appears namely Value Step 7: Now press on any date in column F, right click вЂ“> GroupвЂ“> select Months. Step 6: Now in the Pivot table field list, select Date, RefNo, Amount as these are the important fields for our analysis. Then choose the location in the Location Bar above.

In our case, letвЂ™s go for existing sheet. Step 5: If you choose a different sheet, Pivot table will be appeared in the next sheet, if you choose the existing sheet, choose the cell reference where you want it to be located. Step 4: You can either make sit your Pivot table in the existing sheet or on a New sheet. Then you should see the following screen. If not you have to select the whole range of data manually. Step 3: Almost always Excel guesses the correct range. Step 2: Press Keyboard shortcut Alt+N+V+T or Goto Insert вЂ“> PivotTableвЂ“> PivotTable.

Step 1: Keep the cursor somewhere on the data. We will see that how.Д«efore you start doing something with Pivot table, have your data located as mentioned above in sheet1. If we want to see the data month wise without using any complex formula, Pivot table comes into the scene. LetвЂ™s suppose this whole data lies in sheet1and the donations keep on flowing in as the dates change.

LetвЂ™s assume the data is spread over as follows.

Today we are going to learn How we can analyze data with a Pivot Table while playing with it.ДЄ viewer by name Asif asked me to help him analyze the data relating to donations of a charitable trust.

How to format pivot tables in excel 2013