playlistduration

Excel 2013 PowerPivot Playlist of Videos

by excelisfun · 62 videos

Total watch time

19h 1m

at 1× speed · exactly 19 hours, 1 minute, 16 seconds at 1×

1×19h 1m 16s
1.25×15h 13m 1s
1.5×12h 40m 51s
1.75×10h 52m 9s
2×9h 30m 38s
Average video18m 24s
Longest1h 12m 7s
Shortest2m 49s
Compare Open on YouTube JSON

Plan to finish

About 20 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 20 days. Turn on JavaScript to plan around your week.

Videos (62)

19h 1m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel 2013 PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013 38:33 2014-10-08
2 Excel 2013 PowerPivot Basics #02: Import Large Non-Normalized Data Set To Reduce File Size 5:03 2014-10-10
3 Excel 2013 PowerPivot Basics #03: Replace VLOOKUP with Excel 2013 Data Model & Relationships 7:24 2014-10-10
4 Excel 2013 PowerPivot Basics #04: DAX Formulas Can Be Easier & Faster Than Array Formulas 9:19 2014-10-10
5 Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text) 12:53 2014-03-16
6 Excel 2013 PowerPivot Basics #05: Import External Excel Tables, Build Data Model with SUMX function 16:53 2014-10-11
7 Excel 2013 PowerPivot Basics 6: Import, Filter, Edit From Multiple Data Sources: Access, Excel, Text 20:26 2014-10-14
8 Excel 2013 PowerPivot Basics 7: Calendar Table Calculated Columns: Month Year Quarter Fiscal Quarter 23:00 2014-10-17
9 Excel 2013 PowerPivot Basics #8: Edit Existing Connections, Import New Data, Existing Reports Update 7:29 2014-10-19
10 Excel 2013 PowerPivot Basics #09: Measures (Calculated Fields) & DAX Functions 9 Examples 29:50 2014-10-26
11 Excel 2013 PowerPivot Basics #10: CALCULATE function to Change Filter Context (14 Examples) 53:02 2014-11-05
12 Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP 12:23 2014-08-04
13 Excel 2013 PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable 10:52 2014-11-15
14 Excel 2013 PowerPivot Basics #12: Show Report Filter Pages Not Available In PowerPivot Pivot Table 2:49 2014-11-15
15 Excel 2013 Power Query #01: Append 3 Tables Into One in PowerPivot or Excel Table 5:31 2014-11-11
16 Excel 2013 Power Query #02: Transform Data and Import Into PowerPivot or Excel Table 9:04 2014-11-11
17 Excel 2013 PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data 8:21 2014-11-15
18 Excel Power Query #05: Create Dimension Table From Fact Table for PowerPivot During CSV File Import 9:01 2014-11-29
19 Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model 6:32 2014-11-29
20 Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks 9:35 2014-11-30
21 Basic Excel Business Analytics #40: Introduction to PowerPivot & Data Modeling 36:23 2015-10-26
22 Basic Excel Business Analytics #41: Excel 2016: Introduction to PowerPivot & Data Model 10:53 2015-10-28
23 Basic Excel Business Analytics #42: Comprehensive PowerPivot, Data Model, DAX & Reporting Example 1:01:05 2015-10-29
24 Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model 10:09 2016-02-03
25 Excel Magic Trick 1298: Group By Date in Power Pivot Data Model, New in Excel 2016 2:49 2016-07-01
26 Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New in Excel 2016 3:47 2016-07-01
27 Highline Excel 2016 Class 23: Intro to Power BI Desktop to Create Data Model & Visualization 24:29 2016-07-01
28 Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL? 30:37 2016-09-13
29 Excel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation 5:46 2016-09-14
30 Comprehensive Power BI Desktop Example: Visualize Excel Data & Build Dynamic Dashboard (EMT 1360) 30:35 2016-12-23
31 Import Power Pivot Data Model into Power BI Desktop (Excel Magic Trick 1365) 3:36 2016-12-30
32 Power BI Desktop: Build Data Model, Get Data, DAX Formulas, Visualizations, Publish 2 Web (EMT 1366) 1:12:07 2016-12-31
33 Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples) 55:04 2017-01-31
34 Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula? 29:29 2017-02-11
35 Excel Magic Trick 1385: Import Tables from SQL Server Database into Power Pivot or PBI Data Model 5:46 2017-02-28
36 Excel Magic Trick 1386: Power Query to Import & Append Large Text File in Power Pivot Data Model 6:15 2017-03-01
37 Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & Country 28:32 2017-03-02
38 Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total 34:41 2017-03-18
39 Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks 41:14 2017-03-27
40 Excel Magic Trick 1403: DAX Formulas: Explicit or Implicit Measures? Why Explicit is Better. 11:22 2017-04-08
41 Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables 12:46 2017-04-19
42 Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too) 14:01 2017-04-22
43 Excel Magic Trick 1409: Build PivotTable From 2 Tables without Power Pivot or VLOOKUP 7:54 2017-04-29
44 Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer 27:06 2017-05-12
45 Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas? 28:07 2017-05-17
46 Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR 9:45 2017-05-22
47 Excel Magic Trick 1431: XNPV, OFFSET & VLOOKUP to Get Dates & Cash Flows for NPV & IRR Calculations 13:37 2017-05-22
48 Excel Magic Trick 1432: 9 DAX Formulas to Build Confidence Intervals CONFIDENCE.T, STDEV.S… 19:53 2017-05-23
49 Excel Magic Trick 1433: Materialize DAX Table Functions: Existing Connections, DAX Studio, Power BI? 20:15 2017-05-24
50 Excel Magic Trick 1434: SAMPLE DAX Function to Take Random Stratified Sample from Data Set. 12:12 2017-05-26
51 Excel Magic Trick 1435: DAX Query to Export Data from Data Model to Excel Sheet & Much More! 17:49 2017-05-26
52 Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot 7:05 2017-05-27
53 Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet 8:00 2017-05-28
54 Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total 6:52 2017-05-30
55 Excel Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function 16:16 2017-05-31
56 Excel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop 21:12 2017-06-23
57 Excel Magic Trick 1447: DAX DISTINCTCOUNT & CONCATENATEX to Count & List Stores Visited 6:20 2017-07-09
58 Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years 22:36 2017-07-24
59 Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month 10:30 2017-08-11
60 DAX Approximate Match Lookup & Exact Match Lookup Together for Discounted Product Price (EMT 1490) 20:02 2018-05-06
61 DAX Approximate Match Lookup Part 2: Foreign Key & Relationship or LOOKUPVALUE? EMT1492 13:03 2018-05-08
62 EMT 1494: DAX & Power Pivot: Allocate Invoice Header Amounts To Invoice Transaction Line Table 23:16 2018-05-14

Embed a badge

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

Watch time: 19h 1m · 62 videos

Markdown
[![Watch time: 19h 1m · 62 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nGCx21PRFbsJpUIH06LKs-.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0nGCx21PRFbsJpUIH06LKs-)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0nGCx21PRFbsJpUIH06LKs-"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nGCx21PRFbsJpUIH06LKs-.svg" alt="Watch time: 19h 1m · 62 videos" width="203" 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/PLrRPvpgDmw0nGCx21PRFbsJpUIH06LKs- returns them as JSON — free, no key. API docs →

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