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
