Category: PivotTables
How to Show and Format Excel Pivot Table Dates
With the most recent versions of Excel, you have gained more and more functionality with Pivot Tables. It is now much easier to work with dates. There are two features that you can put to work right away: data filtering (2007) and timeline slicer (2013). There’s also a change to…
Read More
Excel PivotTable Formulas
It’s easy to create formulas with PivotTable data. The key is to remember that you are working with aggregate values, not individual ones. We’ll take a look at how to create a simple formula using something called a Calculated Field. And then, we’ll take a look at two common causes…
Read More
PivotTable from a PivotTable
While it is not technically possible to pivot a pivot table, you can reduce the number of records to analyze by using some of the functionality available in Excel 2010 and later versions. Download Pivot Table from Pivot Table.xlsx to work along. The Steps To accomplish the goal of reducing…
Read More
How to Calculate Median in an Excel PivotTable – Almost!
A frequent question that comes up when working with Excel PivotTables is how to calculate median using the table's filters and analysis. The short answer is "Excel doesn't do that". Meaning, there isn't a simple way to change the Value Field Settings to calculate "Median". The closest you can get…
Read More
How to Create PivotTables Using the Quick Analysis Tool in Excel
Storing information is only part of the useful things Excel spreadsheets can do. Once you have collected a set of data, Excel can help you organize it and analyze it. One of the most powerful tools for analysis is the PivotTable. PivotTables do more than generate graphs out of one…
Read More
How to Use Slicers in Excel 2010 and 2013
Excel's Slicer Filter was added in Excel 2010 and enhanced in Excel 2013. This useful feature is excellent for viewing and comparing varied combinations of your data with a simple click. Something like a cross between a button and a filter, Slicers have become a prized tool for analyzing large…
Read More
The Pivot Table and Percentage of Total Calculations
Once you learn how to create an Excel PivotTable, you'll discover that organizing your information is only the first step in getting the most out of this useful feature. PivotTables then give you the ability to further manipulate the organized information. Value Field Settings let you perform different types of…
Read More
Create a PivotTable Calculated Item in Excel
Excel's PivotTable feature allows you to organize information in such a way that you can answer many questions about your data that would otherwise require lots of formulas, functions and "IF" statements. To get even more answers out of your data, PivotTables offer Calculated Fields and Calculated Items. Calculated Fields…
Read More
Using the Excel Pivot Table Grouping by Month to View Data Differently
PivotTables have some useful "hidden" features that can make interpreting your data even easier. One such feature allows you to view data by date groupings (such as month, quarter, even week and hour of day). By grouping within the PivotTable itself, you avoid constantly changing your source data and creating…
Read More
Excel 2013: How to Create a PivotTable from Multiple Sheets
Once you become a PivotTable fan, you will start to see lots of uses for this powerful analysis tool. But what can you do when the data you want to use is in separate tables in multiple sheets across your workbook? Excel 2013 introduced a method – called the Data…
Read More