Playlist Duration

Playlist · excelisfun

Excel Pivot Tables (PivotTable) Tricks

by excelisfun · 175 videos

Total watch time

2d 4h 2m

at 1× speed · exactly 2 days, 4 hours, 2 minutes, 3 seconds at 1×

At an hour a day you'd finish in 53 days

The shape of the course

175 videos in blocks of 10 · each column is a block's total, to scale

6h 26m

WatchedTo watch

Compare Open on YouTube JSON

Next time, skip the copying: change youtube.com to playlistduration.com in any playlist, video or channel address and it opens here. Or see the total on YouTube itself, with our extension for Chrome, Firefox or Edge.

Your plan

Plan to finish

About 53 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 53 days. Turn on JavaScript to plan around your week.

Videos (175)

2d 4h 2m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
1 PivotTables Are Easy! 30 Examples for Highline College Professional Development Day 2014 44:09 2014-10-17
2 Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As 39:50 2017-11-17
3 Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples 1:21:50 2013-11-16
4 Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model) 21:35 2017-11-20
5 PivotTables & Slicers Made Easy! 4 Amazing Examples for WAAT Accounting Seminar August 26, 2016 35:38 2016-08-24
6 Excel For Accountants: VLOOKUP & PivotTables Complete Lessons: Basic to Advanced: CWU Seminar 1:32:45 2017-01-12
7 Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis) 24:09 2011-02-05
8 Slaying Excel Dragons Book #39: Data Analysis Pivot Tables & Pivot Charts, PivotTables & PivotCharts 19:34 2013-03-12
9 Slaying Excel Dragons Book #40: Grouping Dates in PivotTables: Years, Months or Weeks, and more 11:46 2013-03-14
10 Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer 14:28 2017-05-11
11 Excel Basics #20: Data Analysis Pivot Tables PivotTables 10:23 2008-12-16
12 Highline Excel Class 20: Pivot Tables 20 Examples 25:44 2009-04-14
13 You Tubers Love Excel#11: Pivot Table, SUMPRODUCT & SUMIFS 8:09 2008-04-17
14 YouTubers Love Excel 12: Pivot Table AVERAGEIF SUMIF/COUNTIF 8:17 2008-04-17
15 YouTubersLoveExcel#25: Dynamic Range for Pivot Table & Chart 7:19 2008-05-30
16 Excel Name Trick #5: Names for Pivot Tables & more... 6:54 2008-06-13
17 Excel Statistics 04: Frequency Pivot Table Chart Basics 10:13 2008-07-09
18 YTLE#53: Excel Pivot Table and COUNTIF function 3:26 2008-07-14
19 YTLE#59: Pivot Table for Age Account Receivable 4:30 2008-07-18
20 Excel Statistics 16: Categorical Cross Tabulation with Pivot Table 7:51 2008-07-25
21 Excel Statistics 19: Grouping Categories w Formula & Pivot Table 6:35 2008-07-25
22 Excel Statistics 15: Category Frequency Distribution w Pivot Table & Pie Chart 10:09 2008-07-25
23 YTLE#70 PivotTable & TRIM function & AVERAGES 8:32 2008-07-28
24 Excel Statistics 24: Quantitative Freq. Dist. w Pivot Table 10:04 2008-07-28
25 Excel Statistics 25: % Freq. Dist.& Histogram w Pivot Table 10:02 2008-07-28
26 Excel Statistics 26: Cumulative Freq. Dist w Pivot Table (Running Total) 8:30 2008-07-28
27 Excel Statistics 29: Quantitative Cross Tabulation W Pivot Table 5:43 2008-07-28
28 YTLE#86: Pivot Table Filtering & Functions 5:15 2008-08-07
29 YTLE#91: PivotTable: Average w MONTH criteria 4:59 2008-08-11
30 Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports 7:34 2011-09-27
31 YTLE#106: Alternatives To Pivot Tables - Excel 9:23 2008-08-30
32 YTL Excel #124: Pivot Table Bowling Average 5:40 2008-09-11
33 Excel Magic Trick #114: GetPivotData ISERROR and IF function 4:42 2008-10-10
34 Excel Magic Trick #172: Running Total Formula or Pivot Table 3:59 2008-12-30
35 Excel Magic Trick #168: Cross Tabulation For a Survey 6:27 2008-12-30
36 Excel Magic Trick 216 Pivot Table 4 Variable Cross Tabulation 3:10 2009-01-20
37 Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2 7:40 2009-01-21
38 Excel Magic Trick #218: Pivot Table Macro w Dynamic Range #1 4:28 2009-01-21
39 Excel Magic Trick 250 Pivot Table Unique List in Unique List 2:03 2009-02-04
40 Excel Magic Trick 257 Convert Dates as Text to Dates As No. 4:48 2009-02-12
41 Excel Magic Trick 401: Quarterly Comparative Report - Pivot Table (PivotTable) 6:10 2009-10-08
42 Excel Magic Trick 402: Monthly Comparative Report - Pivot Table 3:52 2009-10-08
43 Excel Magic Trick 403: March End Quarterly Comparative Report - Pivot Table 8:32 2009-10-08
44 Excel Magic Trick 482: 2 Pivot Tables with Different Date Groupings On Same Sheet 5:25 2010-01-14
45 Excel Magic Trick 498: 6 PivotTable Calculation Tricks (Pivot Table) 8:21 2010-02-05
46 Excel Magic Trick 542: PivotTable Count How Many Times A Word Occurs In Word Document 7:01 2010-03-12
47 Excel Magic Trick 556: Change PivotTable Source Data (Pivot Table) 4:41 2010-03-23
48 Excel Magic Trick 710: average with 3 Criteria Using PivotTable Pivot Table 2:47 2010-09-03
49 Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format 11:19 2011-09-16
50 Excel Magic Trick 805: Unique List When Adjacent Cell Contains 1 of 4 Words SEARCH Function & More 11:18 2011-09-16
51 Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports 7:34 2011-09-27
52 Excel 2010 Statistics #15: Frequency Distributions, Histograms, Column Charts (11 Examples) 1:18:29 2011-06-30
53 Excel 2010 Statistics #17 Ogive Chart Formula PivotTable Data Analysis Toolpak Add-in & Pareto Chart 35:11 2011-07-01
54 Excel 2010 Statistics #21: Cross Tabulation With PivotTable Frequencies and % Column & % Row 15:13 2011-07-01
55 Excel 2010 Statistics #41: Joint Probability Table with PivotTable 9:11 2011-07-12
56 Learn Excel PowerPivot From Chandoo and Rob 0:50 2013-08-02
57 Excel Magic Trick 1034: Convert Summarized Table To Proper Data Set With PivotTable Trick 3:19 2013-08-05
58 Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable 6:16 2013-08-05
59 Excel Magic Trick 1112: Clean Transactional Data, Then Create PivotTable Monthly Cost Report 7:51 2014-05-15
60 Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column 1:13 2014-05-17
61 Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable 6:55 2014-07-15
62 Excel 2013 PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable 10:52 2014-11-15
63 Excel 2013 PowerPivot Basics #12: Show Report Filter Pages Not Available In PowerPivot Pivot Table 2:49 2014-11-15
64 Excel Magic Trick 1151: Get Two Tables Into Pivot Table Field List using Excel 2013 5:34 2014-11-15
65 Excel Magic Trick 1158: Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013 4:25 2014-11-26
66 Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable 5:23 2015-03-27
67 Excel Magic Trick 1203: 2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change 9:09 2015-05-26
68 Excel Magic Trick 1218: PivotTable & Slicer To Show Historical Adj Stock Price by Year & Month 9:01 2015-08-01
69 Excel Magic Trick 1219: Paste Special Linked Picture so PivotTable is not Hidden When Filter Applied 4:17 2015-08-03
70 Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data 5:44 2015-08-10
71 Excel 2013 PivotTables from A to Z for the Northwest Accounting Educators 2015 Conference 1:04:47 2015-08-31
72 Excel Magic Trick 1255: Formula to Convert Text Dates With Missing Year & Extra Spaces To Real Dates 5:10 2016-01-16
73 Excel Magic Trick 1256: Grouped Dates in PivotTable With Becomes UnGrouped When I Refresh!!! 5:15 2016-01-17
74 Excel Magic Trick 1267: PivotTable Automatic Date Grouping: New in Excel 2016 3:20 2016-01-31
75 Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List 6:27 2016-02-01
76 Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model 10:09 2016-02-03
77 Excel Magic Trick 1273: Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins 4:49 2016-02-08
78 Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model 1:43:05 2016-04-17
79 Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting 36:16 2016-05-27
80 Highline Excel 2016 Class 20: Power Query Import Multiple Excel Files & PivotTable Show Values As 24:01 2016-06-08
81 Highline Excel 2016 Class 22: How To Build Data Model & DAX Formulas in Power Pivot 1:04:43 2016-06-23
82 Excel Magic Trick 1298: Group By Date in Power Pivot Data Model, New in Excel 2016 2:49 2016-07-01
83 Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New in Excel 2016 3:47 2016-07-01
84 Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables. 5:07 2016-09-06
85 Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula? 12:38 2016-09-03
86 Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods) 26:42 2016-09-11
87 Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL? 30:37 2016-09-13
88 Excel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation 5:46 2016-09-14
89 Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transform) 28:34 2016-10-13
90 Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform 29:48 2016-10-16
91 Excel Magic Trick 1350: Formulas in PivotTables For Gross Profit & Percentage of Gross Profit 8:21 2016-11-26
92 Excel Magic Trick 1380: Slicer Power Query Report To Show Incomplete Student Assignments 8:57 2017-02-16
93 Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total 7:34 2017-03-14
94 Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total 16:33 2017-03-16
95 Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item 5:13 2017-03-17
96 Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total 34:41 2017-03-18
97 Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples) 11:08 2017-03-21
98 Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments 12:47 2017-03-26
99 Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar 2:22:28 2017-04-24
100 Excel Magic Trick 1409: Build PivotTable From 2 Tables without Power Pivot or VLOOKUP 7:54 2017-04-29
101 Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report 6:56 2017-05-02
102 Excel Magic Trick 1413: Set Default Layout in a PivotTable (New in Excel 2016, Office 365) 3:17 2017-05-03
103 Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer 27:06 2017-05-12
104 Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas? 28:07 2017-05-17
105 Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot 7:05 2017-05-27
106 Excel for Accountants: Power Query & PivotTables to Import & Clean Data and Build Reports 51:24 2017-07-12
107 Excel Magic Trick 1450: Replace VLOOKUP When Making PivotTables with Excel 2016 Relationships 10:20 2017-07-31
108 Excel Magic Trick 1451: Hack Data Model, Date Table & DAX Measures WITHOUT buying Power Pivot 35:56 2017-08-03
109 Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years 22:36 2017-07-24
110 Excel Magic Trick 1452: Max Monthly Customer Total for Year: Array Formula or PivotTable? 16:56 2017-08-06
111 Excel Magic Trick 1456: PivotTable & Slicer to Create 8 Year Sales Report by Product & Month 4:35 2017-08-21
112 Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later 4:26 2017-11-20
113 Excel Magic Trick 1469: Add Daily Rainfall 5 AM to 5 AM Next Day: Helper Column & PivotTable 9:24 2017-12-09
114 MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel 19:09 2018-10-12
115 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520 9:16 2018-10-24
116 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528 13:02 2018-10-28
117 MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions 2:04:00 2018-11-17
118 EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts 10:50 2019-01-15
119 MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples) 1:48:28 2019-02-02
120 E-DAB 04: PivotTables & Slicers Create Dashboards & Summary Reports 28:55 2019-02-27
121 E-DAB 05: Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards 54:41 2019-03-07
122 E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot? 45:21 2019-03-16
123 E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards 44:42 2019-03-22
124 MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query 11:07 2019-04-27
125 MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table 1:04:59 2019-05-15
126 MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model 10:51 2019-05-23
127 MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship 17:28 2019-06-02
128 Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales 4:20 2019-07-07
129 Excel Magic Trick 1560: Half Year Running Totals in PivotTable 5:32 2019-07-08
130 Summarize Survey Results with PivotTable in One Minute - Excel Magic Trick 1577 1:01 2019-07-28
131 Excel PivotTable Keyboard? Keyboard for PivotTable –Excel Magic Trick 1578 0:38 2019-07-29
132 DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607 4:22 2019-09-24
133 Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620 9:32 2019-11-25
134 Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622) 9:44 2019-11-30
135 Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626) 18:34 2019-12-13
136 Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621 15:43 2019-12-20
137 MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables 13:23 2019-12-22
138 PivotTables Are Easy: 6 Criteria Cross Tabulated Counting Report. Excel Magic Trick 1657. 5:35 2020-04-01
139 Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658. 9:56 2020-04-03
140 Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667 8:26 2020-05-09
141 List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688. 4:47 2020-09-09
142 Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719 7:19 2021-01-20
143 PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720 7:02 2021-01-25
144 4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729. 7:08 2021-03-16
145 PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730 12:17 2021-03-23
146 Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732 4:35 2021-04-02
147 Create PivotTable in Excel Online. Excel Magic Trick 1733. 3:00 2021-04-05
148 Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts 36:04 2021-04-19
149 Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More! 1:16:25 2021-04-26
150 Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas 58:02 2021-05-10
151 Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756 2:29 2021-09-23
152 3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779 11:33 2022-03-16
153 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784 3:38 2022-03-23
154 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
155 Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13 1:49:33 2023-03-02
156 Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14 3:38 2023-03-08
157 Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845 19:34 2023-11-20
158 Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848 5:50 2024-01-29
159 Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849 5:41 2024-02-05
160 Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853 2:14 2024-02-22
161 PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859 2:48 2024-03-25
162 Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858 3:10 2024-03-18
163 GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855 5:59 2024-02-29
164 1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862 3:26 2024-07-28
165 GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863 6:00 2024-08-04
166 PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879 1:22 2025-03-15
167 GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks? 2:11 2025-03-27
168 MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples! 51:23 2025-03-30
169 MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples. 1:28:49 2025-04-07
170 Turn Off GETPIVOTDATA Function So I Can Refer To My PivotTable With A Cell Reference. Excel Short 77 1:25 2025-04-14
171 GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883 2:46 2025-04-16
172 Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886 3:00 2025-04-26
173 Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890 3:08 2025-05-02
174 PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900 13:29 2025-07-27
175 PivotTable New Features (Spill Error & Auto Refresh) and PivotTable Basics Revealed. EMT 1914 7:54 2025-11-07
For your README

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 2d 4h 2m · 175 videos

Markdown
[![Watch time: 2d 4h 2m · 175 videos](https://playlistduration.com/badge/playlist/PLDF4390866B480CD2.svg)](https://playlistduration.com/playlist/PLDF4390866B480CD2)
HTML
<a href="https://playlistduration.com/playlist/PLDF4390866B480CD2"><img src="https://playlistduration.com/badge/playlist/PLDF4390866B480CD2.svg" alt="Watch time: 2d 4h 2m · 175 videos" width="221" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLDF4390866B480CD2 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-11-03 (cached). Private or deleted videos are excluded from totals.