MS Excel

PivotTable Week – Learn all about PivotTables

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

Orlando Mezquita

Love helping out people to get better using data analysis tools! My day job is statistician for a Pharmaceutical Company.

Leave a Comment
Share
Published by
Orlando Mezquita
Tags: DataAnalysisExcelPivotTables
9 years ago

Recent Posts

18 courses to learn R in 2018

Do you want to learn or get better at R programming?  If yes, you will…

7 years ago

Calculating the median in Excel PivotTables

Go to Master Data Analysis Yes, you read the title of this post correctly, you…

7 years ago

Using R to predict if a customer will buy

In this post, I’ll show how to create a simple model to predict if a…

8 years ago

Data Science for Beginners

Are you wondering what's all this buzz about data science? The following videos will give…

8 years ago

Import excel files with a dynamic starting row

Go to Master Data Analysis This is the 4th post of a series that covers…

8 years ago

Import specific cells from Excel files

Go to Master Data Analysis This is the 5th post of a series that covers…

8 years ago

RECENT POSTS

About US

In this webpage you will see lots of resources to master data analysis skills. Specifically we focus on Excel, Minitab, and the R language