Excel 2013 Pivot Tables

View:  
Sorted by:  

How to Use the Recommended Pivot Tables Button in Excel 2013

You can generate a new pivot table in Excel 2013 in a snap with the new Recommended Pivot Tables command button if creating a new pivot table with the Quick Analysis tool in Excel 2013 is too much work [more…]

How to Manually Create a Pivot Table in Excel 2013

Sometimes, you’ll need to manually create a pivot table because none of the pivot tables that Excel 2013 suggests when creating a new table with the Quick Analysis tool or the Recommended PivotTables command [more…]

How to Filter a Pivot Table Report in Excel 2013

In Excel 2013, perhaps the most important filter buttons in a pivot table are the ones added to the field(s) designated as the pivot table FILTERS. By selecting a particular option on the drop-down lists [more…]

How to Filter Column and Row Fields in Excel 2013

In Excel 2013, the filter buttons on the column and row fields attached to their labels enable you to filter out entries for particular groups and, in some cases, individual entries in the data source. [more…]

How to Filter Pivot Tables with Slicers in Excel 2013

Slicers in Excel 2013 make it a snap to filter the contents of your pivot table on more than one field. (They even allow you to connect with fields of other pivot tables that you’ve created in the workbook [more…]

How to Filter Pivot Tables with Timelines in Excel 2013

Excel 2013 introduces a new way to filter your data with its timeline feature. You can think of timelines as slicers designed specifically for date fields that enable you to filter data out of your pivot [more…]

How to Modify Pivot Table Fields in Excel 2013

Excel 2013 makes it as easy to modify pivot table fields from the original data source display in the table as it did adding them when the table was created. Additionally, you can instantly restructure [more…]

How to Pivot a Table’s Fields in Excel 2013

As pivot implies, the fun of pivot tables in Excel 2013 is being able to restructure the table simply by rotating the column and row fields. This makes it easier to organize your information. [more…]

How to Modify the Pivot Table’s Summary Function in Excel 2013

By default, Excel 2013 uses the good old SUM function to create subtotals and grand totals for the numeric field(s) that you assign as the Data Items in the pivot table. [more…]

How to Create a Pivot Chart in Excel 2013

After creating a pivot table in Excel 2013, you can create a pivot chart to display its summary values graphically in two simple steps. Follow the steps below to take your pivot table to the next step: [more…]

How to Filter Pivot Charts in Excel 2013

The time may come when you will need to filter your pivot charts in Excel 2013. When you graph the data in a pivot table using a typical chart type, such as column, bar, or line, that uses both an x- and [more…]

How to Format Values in the Pivot Table in Excel 2013

Excel 2013 makes formatting a new pivot table you’ve added to a worksheet as quick and easy as formatting any other table of data or list of data. All you need to do is click a cell of the pivot table [more…]

How to Move Pivot Charts to Separate Sheets in Excel 2013

You may find it easier to customize and work with your pivot table in Excel 2013 if you move the chart to its own chart sheet in the workbook, even though Excel automatically creates all new pivot charts [more…]

How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool

Excel 2013 makes creating a new pivot table a snap with its new Quick Analysis tool. To preview various types of pivot tables that Excel can create for you on the spot using the entries in a data table [more…]

How to Move Pivot Charts in Excel 2013

Although Excel 2013 automatically creates all new pivot charts on the same worksheet as the pivot table, you may find it easier to customize and work with it if you move the chart to its own chart sheet [more…]

How to Use the Excel 2013 Quick Analysis Tool

Excel 2013 makes it simple to create a new pivot table using a data list selected in your worksheet with its new Quick Analysis tool. To preview various types of pivot tables that Excel can create for [more…]

The PowerPivot and Power View Add-Ins for Excel 2013

In Excel 2013, the PowerPivot add-in, introduced in Excel 2010, that enables you to efficiently work with and analyze large datasets (such as those with hundreds of thousands or even millions of records [more…]

Data Modeling with PowerPivot in Excel 2013

PowerPivot in Excel 2013 makes it easy to perform sophisticated modeling with the data in your Excel pivot tables. To open the PowerPivot for Excel window, you click the Manage button in the Data Model [more…]

Switch between the Data View and Diagram View in Excel's PowerPivot

Diagram View is among the most useful features for data modeling offered by the Excel 2013 PowerPivot add-in. When you switch from the default Data View to Diagram View either by clicking the Diagram View [more…]

How to Use DAX in Excel's PowerPivot Add-In

DAX stands for Data Analysis Expression and is the name of the language that PowerPivot for Excel 2013 uses to create calculations between the columns [more…]

How to Create Visual Reports with Power View in Excel 2013

Power View is a COM (Component Object Model) add-in that comes with most versions of Excel 2013. This add-in works with PowerPivot for Excel 2013 to enable you create visual reports for your Excel Data [more…]

How to Add Calculated Fields to Pivot Tables in Excel 2013

You can create your own Calculated Fields for a pivot table in Excel 2013. Calculated Fields are computed by a formula that you create by using existing numeric fields in the data source. To create a Calculated [more…]

Use Excel Pivot Tables to Get Top and Bottom Views

The top and bottom displays you create can be as simple as source data that you incorporate into your Excel dashboard. A pivot table is an amazing tool that can help create interactive reporting. Take [more…]

How to Create a Standard Slicer for Excel Dashboards

Slicers give you the ability to add an attractive as well as interactive user interface to your dashboards and reports. Slicers allow you to filter your pivot table in a way that’s similar to the way Filter [more…]

Create a Histogram with a Pivot Table for Excel Dashboards

Did you know you can use a pivot table as the source for a histogram for your Excel dashboards and reports? That’s right. With a little-known trick, you can create a histogram that’s as interactive as [more…]

Sign Up for RSS Feeds

Computers & Software
Great Gadget Giveaway -- Enter to Win!

Inside Dummies.com