Go to Master Data Analysis

With PivotTables you can process thousands (or millions) of rows extremely fast and show the results in dynamic charts called PivotCharts.

During the week (June 13 – 19, 2016) we shared several posts that ranged from very basic knowledge (how to create PivotTables) up to more advanced topics (VBA/Power Pivot).

The posts were shared through our Excel Tricks Facebook page.

Scroll down to see all the links to the posts.

The topics per day were:

  • June 13: How to create PivotTables
  • June 14: Custom calculations and counting unique values
  • June 15: Formatting and Grouping
  • June 16: Filtering: Slicers and formula filters
  • June 17: Miscellaneous tricks
  • June 18: VBA for PivotTables
  • June 19: Power Pivot

The more popular ones (by likes and shares) are summarized below.

 

Whats’s a PivotTable and how to create it?

YouTube Video (6 min)

 

Tutorial of PivotTables with some useful tips

Link

 

Change the summary function in PivotTables: Calculate Sum, Maximum, Minimum, …

Link

 

Count unique values in PivotTables (Excel 2013+)

Link

 

Custom calculations in PivotTables: How to show the sum as a percent of total, Running totals, …

Link

 

Change the style of your PivotTable

Link

 

Avoid the number format to be reset when updating PivotTables

Link

 

Applying conditional formatting to PivotTables

YouTube Video (2:13 min)

 

All about grouping in PivotTables: Dates, Numbers, and Text

Link

 

Slicers: Visual filters for PivotTables

YouTube Video (3:02 min)

 

Connecting Slicers to Multiple PivotTables

YouTube Video (7:11 min)

 

Filtering data in a PivotTable with a formula

Link

 

Advanced use of slicers to change: PivotChart, Data, Calculation

YouTube Video (8:08 min)

 

Save time with recommended PivotTables in Excel 2013 and 2016

Link

 

PivotTables and file size

Link

 

23 things you should know about PivotTables. Check items 14, 21, 23

Link

 

Combining data from multiple tables in a PivotTable

Link

 

Excel Macros to refresh PivotTables

Link

 

VBA Guide to PivotTables

Link

 

“Do you know what’s Power Pivot? Check this video to learn about it!! Note: Power Pivot is already part of Excel 2013 and 2016”

YouTube Video (4:20 min)

 

Forget about VLOOKUP, use relationships in Power Pivot

YouTube Video (3:12 min)

 

Calculate the median in Excel PivotTables with Power Pivot

Link

 

Please share this post so more people can learn and increase their knowledge about PivotTables

Newsletter

Stay up to date with our latest news, receive exclusive deals, and more.

© Master Data Analysis All Rights Reserved 2024