playlistduration

Uploads from excelisfun

by excelisfun · 750 videos · first 750 of 3,884

Total watch time

6d 19m

at 1× speed · exactly 6 days, 19 minutes, 6 seconds at 1×

1×6d 19m 6s
1.25×4d 19h 27m 17s
1.5×4d 12m 44s
1.75×3d 10h 28m 3s
2×3d 9m 33s
Average video11m 33s
Longest3h 44m 8s
Shortest23s
Compare Open on YouTube JSON

Plan to finish

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

Videos (750)

6d 19m in total · tick what you've watched

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

Videos to
Watched
1 Formulas or Power Query or Regex: Why Do I Get Zero When I SUM? Excel Magic Trick 1923 13:45 2026-09-17
2 Power Query #8: Optimize Performance with SQL Server Database Connection 28:48 2026-09-13
3 PQ #6 Part 2: Multiple Excel Files, Different Sheet Names Into Table with Combine Button 4:31 2026-09-07
4 Power Query #7: Merge Join Feature: All Seven Examples 21:54 2026-09-01
5 Power Query #6: 12 Tables Into One Table With Just A Click: Combine Files Button 12:46 2026-08-25
6 Power Query #5: Append Tables with Table.Combine Function: Seven Examples 17:59 2026-08-18
7 Power Query #4: How to Unpivot Columns with Table.UnpivotOtherColumns function 20:05 2026-08-12
8 Conditionally Format Row in Schedule for Today’s Date - Mixed Cell References | EMT 1924 5:59 2026-08-09
9 Sort "City, State" Text by State Then City | SORTBY Array Function - EMT 1923 3:58 2026-08-06
10 Excel Sort Left To Right. Horizontal Sort. Excel Short 83 0:53 2026-08-05
11 PQ #3: Full Free Lesson in Power BI Desktop: Power Query, M, Data Model, DAX Formulas, Visualizing 42:20 2026-08-04
12 Excel Keyboard to Select Full Range & Remove Only The Formatting!!!! Excel Short 82 0:57 2026-08-03
13 Amazing Excel Selection Keyboard Shortcut. Do You Know It? Excel Short 81 0:46 2026-08-02
14 Power Query #2: Import, Clean, Transform & Load Data in Excel 52:01 2026-07-28
15 Power Query #1: Introduction to Power Query & Data Analysis in Excel & Power BI 22:24 2026-07-22
16 excelisfun Boomerangs Back to YouTube: Make More Excel & Power BI Videos & Classes in 2026 & Beyond! 1:59 2026-07-20
17 Last Video From Mike "excelisfun" Girvin on Feb 16, 2026, 18 years at YouTube!!! Go Team!!! 0:55 2026-02-16
18 Excel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation. EMT 1922. 10:54 2026-02-03
19 Excel Formula for Accounting Bank Reconciliation with IF, ISNUMBER & SUM Functions. EMT 1921. 11:12 2026-01-07
20 Complete Lesson in Excel Text Formulas that use References to Dates, Money & Arrays. EMT 1920. 7:47 2025-12-23
21 excelisfun Flashback Friday 6: Sparkling Christmas Tree in Excel! Build Conditional Formatting Tree 2:44 2025-12-20
22 Extend Excel Date Format To Other Dates: Fill Formatting Only Trick! Excel Short 80 1:02 2025-12-16
23 Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919 13:18 2025-12-09
24 Power Query Nested Functions in Custom Column: Convert Multiple Csv Files into One Table. EMT 1918 15:21 2025-12-02
25 Build Power Query Custom Function: Convert Multiple Csv Cross Tab Tables into Single Table EMT 1917. 18:18 2025-11-23
26 Part 2: Power Query Unpivot Cross Tab Table with 2 Column Variables. An Easier Way! EMT 1916 Part 02 9:41 2025-11-18
27 Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916 10:10 2025-11-17
28 2 Excel Formulas to Add Sequential Numbers Each Time a New Row Is Added To a Table. EMT 1915 5:09 2025-11-11
29 PivotTable New Features (Spill Error & Auto Refresh) and PivotTable Basics Revealed. EMT 1914 7:54 2025-11-07
30 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
31 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13
32 Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911 8:45 2025-10-03
33 Magic Data Validation List using Dynamic Range Reference or Spilled Range Operator!! EMT 1910 7:25 2025-10-01
34 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909 4:25 2025-09-29
35 The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908 7:43 2025-09-16
36 Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907 3:40 2025-09-12
37 Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906 5:35 2025-09-11
38 Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905 2:34 2025-09-10
39 Excel TEXTSPLIT function to Split Values By Delimiter & More! Excel Magic Trick 1904 5:11 2025-09-09
40 Turn Off Excel Copilot Pop-up Button in Worksheet. Excel Magic Trick 1903 1:25 2025-09-04
41 Dad & Son Skateboard & BMX West Coast Tour: 20 stops in 9 days 3:30 2025-08-24
42 Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902 24:47 2025-08-21
43 COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901 24:46 2025-08-15
44 PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900 13:29 2025-07-27
45 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
46 Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898 8:20 2025-06-22
47 Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897 4:40 2025-06-20
48 Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896 2:13 2025-06-19
49 Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895. 1:51 2025-06-18
50 Create Random Dates with Excel Functions. Excel Magic Trick 1894 3:22 2025-06-17
51 XLOOKUP, LEFT, TEXTBEFORE, & LOOKUP Functions & Math Tricks to Calculate Discounted Sales! EMT 1893 6:26 2025-06-11
52 Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892 2:51 2025-06-08
53 3 Months of Seattle Skatepark Clips in 3 Minutes. excelisfun & Son Skateboard and BMX Action. 2:46 2025-05-14
54 Import Worksheet of Data From External Excel File into Current Excel File. Excel Short 79 1:15 2025-05-09
55 Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887 17:44 2025-05-08
56 Increase Excel Row Height for Multiple Columns Excel Short 78 0:32 2025-05-06
57 Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889 3:56 2025-05-04
58 COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891 6:09 2025-05-03
59 Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890 3:08 2025-05-02
60 INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888 3:42 2025-05-01
61 Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886 3:00 2025-04-26
62 File Explorer Skills To Be Good In Excel? 100% Yes! File Extensions & F2 Trick! EMT 1885 1:23 2025-04-25
63 The Beauty Of Power Query! One Quick Example : ) 1:59 2025-04-21
64 MS 365 Excel Basics #13: Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas 46:46 2025-04-20
65 Opposite of TEXTJOIN? It's TEXTSPLIT used to Split Sub-text from Text String. Excel Short 76 Part 3 1:00 2025-04-19
66 Array of Delimiters in TEXTJOIN for the Perfect Join! Excel Magic Trick Short # 76 part 02 0:56 2025-04-18
67 MS 365 Excel Basics 12: Power BI Desktop & Interactive Visuals / Dashboards, Import Excel Data Model 25:17 2025-04-17
68 GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883 2:46 2025-04-16
69 MS 365 Excel Basics 11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context Too! 39:24 2025-04-15
70 Turn Off GETPIVOTDATA Function So I Can Refer To My PivotTable With A Cell Reference. Excel Short 77 1:25 2025-04-14
71 Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882 4:21 2025-04-14
72 MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total 3:28 2025-04-13
73 Excel TEXTJOIN Function Trick to Join Text from 2 Columns into 1 Cell! Excel Short Magic Trick 76 1:20 2025-04-12
74 MS 365 Excel Basics #10 Part 03: FILTER Array Function to Dynamically Filter! 4:41 2025-04-11
75 Introduction to excelisfun @ YouTube: Free Excel Classes, Videos & Practice Files & Power BI Too! 1:47 2025-04-10
76 MS 365 Excel Basics #10 Part 02: SORT Array Function & the Many Varied Tasks It Can Achieve! 6:14 2025-04-09
77 MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples. 1:28:49 2025-04-07
78 Mind-Blowing: GROUPBY Function Beats PivotTable, Hands-down. Beats COUNTIFS Too! Excel Short # 75 1:50 2025-03-30
79 MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples! 51:23 2025-03-30
80 Temporary Fix for GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? EMT 1881 1:23 2025-03-28
81 GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks? 2:11 2025-03-27
82 Excel Revolution with PIVOTBY & GROUPBY Functions! #Short Preview of Upcoming Video 0:26 2025-03-26
83 How to Add Subtitles to YouTube Videos in Multiple Language March 25 2025 Update 2:33 2025-03-26
84 Add Slicer to PivotTable & Chart To Enable Quick Analysis Excel Short Magic Trick 74 1:00 2025-03-24
85 Fast Keyboard to Create Excel PivotTable Excel Short Magic Trick 73 1:15 2025-03-23
86 Why Excel Table Feature is Amazing & How To Create Them: Excel #Short Magic Trick 72 1:50 2025-03-23
87 MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips! 35:54 2025-03-23
88 PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879 1:22 2025-03-15
89 Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878 2:35 2025-03-14
90 Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71 0:46 2025-03-13
91 Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70 2:23 2025-03-12
92 Increase All Numbers by a Multiple of 10: Excel Paste Special Multiply Magic!! Short Excel Trick 69 0:42 2025-03-11
93 Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68 2:30 2025-03-10
94 PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877 2:21 2025-03-09
95 Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876 2:33 2025-03-08
96 No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875 4:42 2025-03-07
97 FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874 3:24 2025-03-06
98 LET Function to Define LAMBDA as f, then Perform Column Iteration With Vertical Spill. #Short 67 2:29 2025-03-05
99 LET & BYCOL Functions to Spill Column Aggregate calculations Vertically. #Short 66 2:19 2025-03-04
100 Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872 13:36 2025-03-03
101 Spill Aggregate Totals with the AGGREAGATE Function. #Short 65 2:19 2025-03-02
102 Spill Aggregate Totals with BYCOL Function (GEOMEAN too), Across Bottom of Table! #Short 64 2:07 2025-03-01
103 AI Doesn't Know This: Best Solution for Excel Table Running Count Error! #Short Excel Trick 63 1:37 2025-02-27
104 BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871 6:54 2025-02-26
105 Excel's WRAPCOLS Array Function to Undo Table Into a Specified # of Columns. #Short Excel Trick #62 0:47 2025-02-25
106 Add Secondary Series of Numbers To Excel Chart & Add Second X-Axis Labels to Chart: EMT 1873 3:01 2025-02-25
107 GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870 5:45 2025-02-24
108 No More VBA! Amazing WRAPROWS Function Converts Column of Records to Table. #Short Excel Trick 61 1:36 2025-02-23
109 Best Formula for % Change (Daily Stock Returns). #Short Excel Trick 60 1:09 2025-02-22
110 Stock Portfolio Expected Return & Beta with single cell array formula. Bonus Trick Too! #Short 59 1:39 2025-02-21
111 Expected Return & Standard Deviation 4 Portfolio of Stocks Single Cell Excel Array Formula #Short 58 2:10 2025-02-20
112 Expected Return & Standard Deviation for 2 Stocks: Single Cell Excel Spilled Array Formula #Short 57 2:28 2025-02-19
113 excelisfun YouTube Channel is 17 Years Old!!!!!!! 0:35 2025-02-18
114 Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56 1:53 2025-02-18
115 Excel's Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55 2:10 2025-02-17
116 Dynamic PivotTable To Count SalesRep Monthly Sales & Visualize Trend. Excel Magic Trick 1869 7:49 2025-02-15
117 Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54. ACCTG 455 #68.4 2:30 2025-02-14
118 Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53. ACCTG 455 #68.3 1:27 2025-02-13
119 Net Present Value: Do We Buy Asset? PV or NPV Function? #Short 52. ACCTG 455 #68.2 2:20 2025-02-12
120 Build Text Formula for Dynamic Label For Financial Model. #Short 51. ACCTG 455 #68.1 1:41 2025-02-11
121 Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50. ACCTG 455 #63.2 1:56 2025-02-10
122 Visualize How Stock Values Changes as Dividend Growth Rate Changes. #Short 49. ACCTG 455 #63.1 1:11 2025-02-09
123 Bond Rate Risk: Lower Coupon Rate, The More YTM Affects Bond Price. #Short 48. ACCTG 455 #54.2 1:45 2025-02-08
124 Excelisfun Needs Your Help in Solving A Formula Number Formatting Mystery. #Short 52 Part 02 0:43 2025-02-07
125 Bond Rate Risk: Longer Maturity, More YTM Affects Bond Price. #Short 47. ACCTG 455 #54.1 2:05 2025-02-06
126 Visualize Inverse Relationship for Bond Price & YTM Rate. #Short Excel Trick 46. ACCTG 455 50.4 1:13 2025-02-05
127 Spill Bond Valuation PV Function Formula Across YTM Rates. #Short Excel Trick 45. ACCTG 455 #50.3 1:21 2025-02-04
128 IFS Function for Bond Value "Par", "Discount", or "Premium". #Short Excel Trick 44. ACCTG 455 # 50.2 1:23 2025-02-03
129 Conditional Formatting for Bond Sold at Discount or Premium. #Short Excel Trick 43. ACCTG 455 # 50.1 1:23 2025-02-02
130 Deep Discount Loan Spilled Amortization Table (Treasury Bonds) . #Short Excel Trick 42. ACCTG 455. 1:23 2025-02-01
131 Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41. ACCTG 455. 1:20 2025-01-31
132 Excel Spilled Loan Amortization Table. #Short Excel Trick 40. ACCTG 455. 1:39 2025-01-30
133 What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39 1:11 2025-01-25
134 CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38 1:08 2025-01-24
135 Excel Formulas: Arrow Keys or Mouse? Return on Assets & Return on Equity Show the Best! #Short ET 37 1:15 2025-01-24
136 I Can’t See All of My Excel Worksheet Tabs!?!?! #Short Excel Trick 36 0:23 2025-01-23
137 Subtle Excel Keyboard Awesomeness: Ctrl + Shift + Arrow, then, Shift + Arrow #Short Excel Trick 35 1:11 2025-01-22
138 MS 365 Excel Basics #3.5: Spill Rectangle Range of Weekly Commission Paid Amounts: #Short EMT 34 1:20 2025-01-21
139 ACCTG 455: Excel Finance Class 19.75: DuPont ROE Analysis. EMT Short #33. 1:51 2025-01-21
140 ACCTG 455: Excel Finance Class 19.5: Why DuPont ROE Analysis is So Clever! 1:50 2025-01-21
141 World’s Greatest Excel Keyboard Short Cut? It’s a Tie Between Two!!! #Short Excel Magic Trick 32 0:33 2025-01-20
142 Warning About Excel SUM Function Keyboard Shortcut: Alt + = #Short Excel Magic Trick 31 0:45 2025-01-19
143 ACCTG 455 Excel Finance Class 15.75: Three Common Sized Balance Sheet: Single Formula #Short EMT 30 1:00 2025-01-18
144 ACCTG 455, Excel Finance Class 13.5: Financial Statement Cash Flow Equation Algebra Hint for HW 19 3:16 2025-01-17
145 ACCTG 455 Excel Finance Class 15.5: Formula for Multiple Common Sized Income Statements #Short ET 29 1:00 2025-01-17
146 ACCTG 455 Excel Finance Class 14.5: Common Size Income Statement Spilled Array Formula #Short EMT 28 1:01 2025-01-16
147 How To Make Your Worksheet Formula Solution Better! 0:56 2025-01-15
148 Slicer Not Working With Second PivotTable? Here Is The Easy Fix! #Short Excel Magic Trick 26 0:37 2025-01-14
149 Create Excel PivotTable and Slicer is Less Than One Minute! #Short Excel Magic Trick 25 0:56 2025-01-13
150 Spill SUM Functions ? BYROW & BYCOL to Spill Any Aggregate Function! #Short Excel Magic Trick 24 1:00 2025-01-12
151 25 Formulas with a Single Keyboard Shortcut: Believe it! #Short Excel Magic Trick 23 0:44 2025-01-11
152 Excel Dynamic Range with TRIMRANGE Function #Short Excel Magic Trick 22 0:59 2025-01-10
153 Excel Dynamic Range Reference Operator .:. Trim Range Reference. #Short Excel Magic Trick 21 0:59 2025-01-09
154 Remove All Workbook References From Formulas Quickly with Excel Replace Feature #Short EMT 20 0:56 2025-01-08
155 Rad Is Rad: BMX or Skateboards or Excel: Old or Young: Having Fun Is It!!! 1:16 2025-01-07
156 Excel 365 Basics #7: Comprehensive Formula & Function Lesson To Become An Excel Formula Guru! 1:26:24 2025-01-06
157 Highline College Excel Corporate Finance ACCTG 455 Class 2025 Winter by Mike "excelisfun" Girvin 5:37 2025-01-06
158 Select All Empty Cells & Delete Them: Go To Dialog Box and F5 Key #Short Excel Magic Trick 19 0:41 2025-01-05
159 Select All Cells With Excel Formulas! Go To F5 Key. #Short Excel Magic Trick 18 0:43 2025-01-04
160 What is the Difference Between Excel Merge Across & Merge Cells? #Short Excel Magic Trick 17 0:46 2025-01-04
161 Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868 17:11 2025-01-04
162 Spreadsheet Construction Busn 218 Class @ Highline College, 2025 Winter by Mike "excelisfun" Girvin 9:15 2025-01-03
163 Highline College Statistical Analysis Busn 210 Class 2025 Winter taught by Mike "excelisfun" Girvin 12:41 2025-01-02
164 2024 Christmas Tree with Excel Formula 1:29 2024-12-24
165 Excel 365 Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task! 49:21 2024-12-22
166 Excel 365 Basics #5: IF Function & Logical Tests IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More 46:45 2024-12-12
167 Excel 365 Basics #4: Date & Time Formulas, Functions & Formatting: All The Basics You Need to Know 42:28 2024-11-24
168 Excel 365 Basics #3: Number Formatting as Façade & when you MUST use ROUND Function 21:46 2024-11-17
169 Excel 365 Basics #2: SUMIFS, COUNTIFS, COUNT, COUNTA, ROWS, SUM & IF Functions to Add & Count 52:01 2024-11-11
170 Excel 365 Basics #1: What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup 1:05:26 2024-10-31
171 Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables 51:58 2024-10-03
172 Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866 11:30 2024-09-19
173 Highline College Busn 218 Advanced Excel Fall, 2024 Introduction 8:54 2024-09-19
174 Highline College Busn 210 Excel Statistical Analysis Fall, 2024 Introduction 12:19 2024-09-19
175 Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865 13:32 2024-08-14
176 Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864 2:52 2024-08-09
177 Special Offer: New Power BI & Excel Power Query M Code Book from excelisfun!!! 1:15 2024-08-06
178 GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863 6:00 2024-08-04
179 1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862 3:26 2024-07-28
180 Poem about excelisfun and MVP by Hiran de Silva 2:37 2024-07-19
181 excelisfun online form to fill out to regain MVP from Celia Alves 0:46 2024-07-19
182 Introduction to the excelisfun Channel at YouTube: Free Videos, Files and Full Free Courses!! 1:41 2024-07-17
183 UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861 1:56 2024-07-15
184 Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860 3:38 2024-07-12
185 Microsoft Revokes excelisfun MVP Status! 0:37 2024-07-11
186 excelisfun Boomerangs Back With Gold Plaque!!! and more!!!! 1:47 2024-07-08
187 excelisfun One Million YouTube Subscribers!!!! 1:52 2024-06-07
188 DAME 07: How to Make Effective Dashboard. Three Examples in Power BI 31:56 2024-06-03
189 DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class 2:31:36 2024-05-27
190 DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis) 1:50:07 2024-05-19
191 DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples. 52:18 2024-05-05
192 DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks. 44:29 2024-04-25
193 DAME 2 (Updated): MS Data Analysis Tools: Excel, Power Query, Power BI, Data Flow, DAX & M Code! 1:46:13 2024-04-24
194 DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools! 23:33 2024-04-08
195 Why Are So Many Decimal Showing In Excel? Answer Student’s Question About Number Formatting 2:41 2024-04-06
196 Spring 2024 Data Analysis With Microsoft Power Tools - BI 348 at Highline College 3:23 2024-03-31
197 Spring 2024 Business Excel Statistical Analysis - Busn 210 at Highline College 7:48 2024-03-31
198 PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859 2:48 2024-03-25
199 Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858 3:10 2024-03-18
200 Generate Random Data Sets with Dates & Sales Numbers: RANDARRAY Function. Excel Magic Trick 1857 3:09 2024-03-11
201 Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856 5:52 2024-03-04
202 GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855 5:59 2024-02-29
203 Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854 3:23 2024-02-26
204 Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853 2:14 2024-02-22
205 Append Tables in Excel. Excel Magic Trick 1852 1:08 2024-02-19
206 Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851 2:58 2024-02-12
207 Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849 5:41 2024-02-05
208 Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848 5:50 2024-01-29
209 Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850 3:02 2024-01-23
210 Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847 4:30 2024-01-19
211 Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10 1:46:52 2024-01-03
212 Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845 19:34 2023-11-20
213 ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846 2:29 2023-11-19
214 2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2 3:07 2023-11-18
215 GROUPBY Excel Worksheet Function. Single Cell Reports Made Easy! 11 Examples. EMT 1844 28:33 2023-11-18
216 FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843 2:23 2023-11-01
217 FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842 3:33 2023-10-25
218 FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841 8:29 2023-10-18
219 Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840 7:46 2023-10-11
220 Excel Formula: Extract City Name from Description. Excel Magic Trick 1839 4:02 2023-10-04
221 Excelisfun's Mom 0:29 2023-10-02
222 Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838. 5:15 2023-09-10
223 FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837 6:10 2023-09-03
224 Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836 5:42 2023-08-27
225 Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function? 4:17 2023-08-25
226 Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835 3:30 2023-08-22
227 Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834 9:03 2023-08-11
228 XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833 4:36 2023-08-07
229 Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832 3:35 2023-08-04
230 Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831 3:27 2023-08-01
231 LOOKUP Beats XLOOKUP For Horizontal / Vertical Lookup. Excel Magic Trick 1830 2:09 2023-07-29
232 LOOKUP Beats XLOOKUP For Single Cell Revenue Calculation. SUMPRODUCT Too! EMT 1829 3:34 2023-07-26
233 Federal Income Tax Calculation: LOOKUP Function Beats VLOOKUP & XLOOKUP! EMT 1828 Part 3 3:05 2023-07-23
234 LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2 3:03 2023-07-21
235 LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828 2:49 2023-07-20
236 3 Power Query Formulas: Hours Worked for Day & Night Shift from Time Values. Excel Magic Trick 1827 8:54 2023-07-16
237 Formula to Calculate Hours Worked in Excel & DAX: Day or Night Shift! Excel Magic Trick 1826 6:55 2023-07-11
238 Sunday Old Guy BMX Bike Racing & Park Action, Port Angeles, WA 2:03 2023-07-10
239 Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825 5:59 2023-07-09
240 Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824 7:33 2023-07-06
241 Excel Formula To Randomly Lookup Pictures or Any Item. Excel Magic Trick 1823 2:53 2023-07-04
242 Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822 2:54 2023-06-29
243 Generate Letters A to Z in Excel #Short Excel Magic Trick 16 0:59 2023-06-27
244 Two Date Columns in Fact Table? How To Create Report? DAX, Power Query, Excel? 365 MECS Class 22 18:12 2023-06-22
245 Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21 15:49 2023-06-18
246 Excel Formulas Sort By Last Name, Names My Have Middle Name #Short Excel Magic Trick 15 0:57 2023-06-16
247 Conditional Format Row When Employee Is Listed More Than 1 Time For Date. Excel Magic Trick 1821. 3:09 2023-06-14
248 What Is My CD Worth? A Lesson in Finance & Worksheet Model Building. 365 MECS Class 20 18:25 2023-06-10
249 Budget Vs. Actual Variance Analysis: Data Modeling, DAX, or Worksheet Formulas? 365 MECS Class 19 15:01 2023-06-02
250 Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas? 365 MECS Class 18 37:30 2023-05-31
251 INDEX Function Beats XLOOKUP? #Short Excel Magic Trick 14 0:52 2023-05-28
252 Sort By Last Name using Excel Formula: Amazing Solution!! #Short Excel Magic Trick 13 0:42 2023-05-24
253 Full Free DAX Class: Fundamentals of DAX in Power BI & Power Pivot. 365 MECS Class 17 2:26:22 2023-05-18
254 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820 3:53 2023-04-25
255 SUMIF Function Trick: Single Cell Dynamic Range! #Short Excel Magic Trick 12 0:39 2023-04-16
256 SUMIF Trick that Beats SUMIFS. #Short Excel Magic Trick 11 0:44 2023-04-13
257 Turn Off Excel Table Formulas and Use Cell References Instead. #Short Excel Magic Trick 10 0:26 2023-04-11
258 #1 Keyboard Shortcut in Excel. #Short Excel Magic Trick 09 0:33 2023-04-09
259 Auto Numbers in an Excel Table with a Formula. #Short Excel Magic Trick 08 0:33 2023-04-07
260 Convert ISO Dates to Dates with Power Query: Excel or Power BI. #Short Excel Magic Trick 07 0:28 2023-04-05
261 Automatic Sequential Numbers Just Pop Up! SEQUENCE & IF functions. #Short Excel Magic Trick 06 0:30 2023-04-03
262 BI 348: Data Analysis with Microsoft Power Tools- Spring - 2023 Quarter Introductory Video 3:32 2023-04-02
263 Excel Statistical Analysis for Business – Busn 210 - Spring 2023 Quarter Introductory Video 10:40 2023-04-02
264 List Products Sold in Cell for Each Sales Rep with Excel Formula. #Short Excel Magic Trick 05 0:55 2023-04-01
265 Excel’s #1 Most Hidden Trick: Insert Picture In Comment. #Short Excel Magic Trick 04 0:37 2023-03-29
266 Dad & Son Skate & BMX Rad in Seattle on Sunday 1:35 2023-03-27
267 Excel Array Formulas in 1 Minute. # Short Excel Magic Trick 03 0:59 2023-03-26
268 Word Replace Feature for Special Characters: Replace All Hard Returns with 2 Hard Returns. #Short 0:36 2023-03-22
269 Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16 33:49 2023-03-21
270 INDEX & RANDARRAY Functions to Create Table of Data. # Short Excel Magic Trick 03 0:58 2023-03-20
271 Format Total Row in Dynamic Spilled Array (Conditional Formatting) # Short Excel Magic Trick 02 0:59 2023-03-20
272 Count Files in Folder Using Excel? Power Query!!! Excel Magic Trick # Short 01 0:51 2023-03-19
273 7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15 22:02 2023-03-12
274 Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14 3:38 2023-03-08
275 Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13 1:49:33 2023-03-02
276 Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819 16:06 2023-02-26
277 Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818 6:04 2023-02-24
278 Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_ 1:34 2023-02-22
279 Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817 5:38 2023-02-21
280 Help Delete FAKE excelisfun Account (How To Report Fake YouTube Account) 0:41 2023-02-17
281 excelisfun @ YouTube for 15 Years! Birthday Party! 0:45 2023-02-15
282 Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12 1:41:38 2023-02-03
283 Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts 0:59 2023-01-26
284 Save Time in Excel: Copy Only Excel Format with Format Painter. Excel Magic Trick 1815 #Shorts 1:25 2023-01-26
285 Remove All Excel Format to Help Fix Reports and Data Errors. Excel Magic Trick 1814 #Shorts 1:55 2023-01-22
286 Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts 3:38 2023-01-19
287 Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shorts 2:45 2023-01-16
288 Visualizing Data and Building Dashboards in Excel & Power BI - 365 MECS 11 1:42:27 2023-01-12
289 Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 9:47 2023-01-07
290 Busn 218 – Advanced Excel – Winter 2023 Quarter Introductory Video 8:55 2023-01-07
291 Excel Statistical Analysis for Business – Busn 210 – Winter 2023 Quarter Introductory Video 10:41 2023-01-07
292 Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810 4:00 2023-01-05
293 Excel LAMBDA function – Every Single Things You Ever Wanted To Know - 2022 Version 365 MECS 10 1:45:05 2022-12-30
294 Excel Sparkling Christmas Tree with Changeable Ornaments with LAMBDA function! EMT 1809 1:19 2022-12-24
295 Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808 4:39 2022-12-12
296 Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807 7:37 2022-12-09
297 Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806 4:06 2022-12-07
298 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805 8:06 2022-11-29
299 Excel Dynamic Spilled Array Formulas & Functions: 50 Examples to Become an Expert! - 365 MECS 09 1:10:10 2022-11-20
300 Mike excelisfun Girvin 60th Birthday Party: BMX Park and BMX Track: Rad Old Guy Fun! 0:57 2022-11-07
301 XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804 3:29 2022-11-05
302 Spilled 2-Way Lookup Commission Report using LAMBDA and BYROW Functions. EMT 1803 5:22 2022-11-02
303 Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802 3:28 2022-10-30
304 FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801 3:24 2022-10-27
305 All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX – 28 Examples! - 365 MECS 08 1:18:51 2022-10-20
306 Dad & Son Skatepark Sunday Seattle Rad, Oct. 16, 2022. Boneless-Ones Skate Music. 0:52 2022-10-16
307 Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800 3:52 2022-10-13
308 FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799 4:41 2022-10-10
309 Logical Tests: Excel Formulas, Conditional Formatting, PivotTables, Power Query, & More- 365 MECS 07 1:48:22 2022-10-02
310 Excel Statistical Analysis for Business – Busn 210 - Fall 2022 Quarter Introductory Video 11:43 2022-09-25
311 Busn 218 – Advanced Excel - Fall 2022 Quarter Introductory Video 9:01 2022-09-25
312 Text Formulas & Functions in Excel Worksheet and Power Query - 365 MECS 06 34:27 2022-09-14
313 Date & Time Formulas & Functions in Excel Worksheet and Power Query - 365 MECS 05 50:36 2022-09-05
314 Excel & Power BI Data Analysis Complete Class in One Video - 4 Hours - Download Files - 365 MECS 04 3:44:08 2022-08-21
315 Create Sequence of Time Values in Excel for Stock Market Price Data – Excel Magic Trick 1798 7:18 2022-08-15
316 Excel Formula to make First a 1, Second a 2, Third a 3, and so on. 6 Formula Examples. EMT 1797 4:04 2022-08-11
317 Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796 7:50 2022-08-09
318 Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795 3:02 2022-08-07
319 excelisfun’s new book The Only App That Matters Book is Released!!! Microsoft 365 Excel = The Best! 1:10 2022-08-02
320 M 365 Excel Worksheet Formulas & Models – Everything You Ever Wanted To Know - 365 MECS 03 1:11:13 2022-07-24
321 Excel Formulas & Functions, PivotTables, Slicers & Charts - 365 MECS 02 1:13:45 2022-07-11
322 Excel Formula to Lookup Cell Address Of Max Value: 12 Amazing Examples. Excel Magic Trick 1794 9:55 2022-07-05
323 How To Access Excel F Keys on Laptop Computer – Huge List of Function Keys too - 365 MECS 01 Part 2 2:01 2022-07-03
324 Introduction to Microsoft 365 Excel & Conventions for Class - 365 MECS 01 27:38 2022-06-29
325 Microsoft 365 Excel Complete Class: free from excelisfun at YouTube - 365 MECS 00 1:47 2022-06-27
326 Excel Statistical Analysis for Business – Busn 210 - Summer 2022 Quarter Introductory Video 15:32 2022-06-26
327 excelisfun e-Book release: The Only App That Matters: Microsoft 365 Excel. Preview of Book! 2:32 2022-06-16
328 Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793 8:39 2022-06-14
329 Dad & Son Seattle Jefferson Sunday Skatepark Rad: Boneless-Ones Skate Music Pumps The Action! 2:44 2022-06-13
330 Linear Regression Made Easy! The Epic Full Story with all Details. Excel Statistical Analysis 50 1:12:11 2022-06-05
331 Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792 12:05 2022-05-31
332 Sunday Seattle Green Lake Old Guy BMX Park Fun, May 29, 2022. Boneless-Ones Skate Music 1:12 2022-05-30
333 Excel Statistical Analysis 49: Hypothesis Testing for Proportion (Binominal) using Normal Curve 7:27 2022-05-22
334 Excel Statistical Analysis 48: Hypothesis Testing with T Distribution, Two Tail Example 8:54 2022-05-21
335 Excel Statistical Analysis 47: Hypothesis Testing with T Distribution, 1 Tail Lower (Left) Test 7:48 2022-05-21
336 Excel Statistical Analysis 46: Hypothesis Testing with T Distribution, 1 Tail Upper (Right) Test 11:02 2022-05-21
337 Excel Statistical Analysis 45: Hypothesis Testing with Z Distribution, Two Tail Test Example 9:56 2022-05-20
338 Excel Statistical Analysis 44: Hypothesis Testing with Z Distribution, 1 Tail Lower (Left) Test 10:58 2022-05-20
339 Excel Statistical Analysis 43: Hypothesis Testing: P-value & Critical Value Methods: 1 Tail Upper 32:48 2022-05-19
340 Excel Statistical Analysis 42: Confidence Interval for Proportions (Binomial Experiments) 10:29 2022-05-18
341 Excel Statistical Analysis 41: Confidence Interval for t Distribution, use when Sigma NOT Known 18:43 2022-05-17
342 Excel Statistical Analysis 40: Confidence Interval for z Distribution, use when Sigma Known 8:54 2022-05-16
343 Excel Statistical Analysis 39: Confidence Intervals: Theory for Estimating Population Parameter 14:07 2022-05-15
344 Excel Statistical Analysis 38: Normal Bell Curve to Estimate Range of Sample Proportions 10:29 2022-05-13
345 Excel Statistical Analysis 37: Learn Central Limit Theorem by Building Sampling Distribution of Xbar 49:53 2022-05-09
346 Excel Statistical Analysis 36: Sampling & Sampling Distribution of Sample Means (Xbar) 24:47 2022-05-08
347 Excel Statistical Analysis 35: Exponential Probability Distribution & EXPON.DIST function 11:47 2022-05-05
348 Excel Statistical Analysis 34: Answering Probability Questions With NORM.DIST Function 8:56 2022-05-02
349 Excel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart 15:10 2022-04-29
350 Excel Statistical Analysis 32: Bell Curve Functions: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV 23:50 2022-04-27
351 Excel Statistical Analysis 31: Uniform Probability Distribution 15:11 2022-04-26
352 Excel Statistical Analysis 30: Introduction to Continuous Probability Distributions 9:14 2022-04-25
353 XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791 6:59 2022-04-21
354 Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials 16:57 2022-04-19
355 Dad/Son Rad Road Trip To Oakland Lower Bobs Skatepark 1:40 2022-04-17
356 Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790 4:07 2022-04-16
357 Excel Statistical Analysis 28: Poisson Distribution, POISSON.DIST function and Poisson Column Chart 21:55 2022-04-11
358 Excel Statistical Analysis 27: Binomial Probability Distributions. BINOM.DIST.RANGE Function & Chart 32:04 2022-04-07
359 Excel Statistical Analysis 26: Accounting & Finance Discrete Probability Distribution Examples 9:38 2022-04-05
360 TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789 3:26 2022-04-04
361 BI 348 - Microsoft Power Tools – Highline College Spring 2022: Introduction Video 4:51 2022-04-03
362 Excel Statistical Analysis for Business – Busn 210 - Spring 2022 Quarter Introductory Video 15:22 2022-04-03
363 Busn 135 - Business Math – Spring 2022 Introduction Video 12:28 2022-04-03
364 DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788 12:14 2022-03-31
365 Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787 18:07 2022-03-28
366 BMX & Skate Park Adventure #14: Lake Stevens, Sunday, Sunday, March 27, 2022 1:40 2022-03-28
367 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786 6:29 2022-03-25
368 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
369 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784 3:38 2022-03-23
370 Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783 8:29 2022-03-22
371 14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782 18:35 2022-03-19
372 HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781 11:30 2022-03-18
373 HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780 5:34 2022-03-16
374 3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779 11:33 2022-03-16
375 Excel Statistical Analysis 25: Import Excel data: Build PivotTable Discrete Probability Distribution 12:50 2022-03-14
376 Excel Statistical Analysis 24: Build Discrete Probability Distributions with Worksheet Formulas 28:44 2022-03-12
377 Excel Statistical Analysis 23: Discrete Probability Distributions: Terms and Definitions 13:23 2022-03-12
378 Power Query: Extract Records For Invoices 1 to 30 Days Past Due - EMT 1778 3:49 2022-03-09
379 COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777 10:51 2022-03-07
380 Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method - EMT 1776 6:05 2022-03-04
381 Sum Top 3 Values When There Is Missing Data – 3 Unbelievable Solutions (LAMBDA too) EMT 1775 6:21 2022-03-02
382 Excel Statistical Analysis 22: Bayes’ Theorem, Tabular Method, Probability Tree, SUMPRODUCT function 21:49 2022-02-27
383 Excel Statistical Analysis 21: Multiplication Law of Probability, AND Logical Test, Probability Tree 11:26 2022-02-26
384 Turn Off GETPIVOTDATA Function - EMT 1774 1:35 2022-02-25
385 Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or PivotTable? 9:09 2022-02-25
386 Excel Statistical Analysis 19: Conditional Probability 5 Examples 15:20 2022-02-24
387 Excel Statistical Analysis 18: Addition Law of Probability, OR Logical Test: Formulas & PivotTables 17:23 2022-02-22
388 Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions 28:44 2022-02-20
389 Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too 43:44 2022-02-17
390 Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773 2:48 2022-01-28
391 Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas 26:23 2022-01-21
392 Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of Standard Deviations 23:56 2022-01-19
393 Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of Variation 26:07 2022-01-17
394 Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772 2:07 2022-01-14
395 FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771 7:13 2022-01-13
396 Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank Functions & Algorithms 19:07 2022-01-12
397 Excel Statistical Analysis 11: Geometric Mean to Calculate Average Compounding Rate per Period 15:52 2022-01-08
398 Excel Statistical Analysis 10: Weighted Mean. Awesome Accounting Example!! 11:22 2022-01-07
399 Excel Statistical Analysis for Business – Busn 210 - Winter 2022 Quarter Introductory Video 15:04 2022-01-05
400 Highline College Advanced Excel – Busn 218 - Winter 2022 Quarter Introductory Video 9:35 2022-01-05
401 Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More! 40:24 2022-01-03
402 Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770 6:35 2022-01-01
403 SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769 5:34 2021-12-28
404 Excel Flashing Christmas Tree 2021- Happy Holidays Old School Formula Method. EMT 1768 2:18 2021-12-25
405 Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767 9:49 2021-12-20
406 Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766 11:09 2021-12-15
407 Excel Statistical Analysis 08: X-Y Scatter Charts for Linear Data: Excel Chart? Analyze Data Button? 12:28 2021-12-13
408 Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s Paradox 33:11 2021-12-10
409 Excel Statistical Analysis 06: Frequency Distributions, Visualizations & Skew for Quantitative Data 28:45 2021-12-06
410 Excel Statistical Analysis 05: Frequency Distributions & Visualizations for Categorical Data 33:37 2021-12-01
411 Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions 36:25 2021-11-26
412 Flip Column in Excel? Formula, Sort, Power Query or LAMBDA? Dueling Excel #196 Mr Excel & Excelisfun 11:11 2021-11-25
413 Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765 5:24 2021-11-22
414 Old Guy BMX Park Adventure #13: Lake Stevens BMX Park, Sunday, November 21, 2021 2:41 2021-11-21
415 Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video 43:20 2021-11-14
416 Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more 19:57 2021-11-11
417 Excel Statistical Analysis 01: Data & Statistics 22:56 2021-11-08
418 Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764 10:14 2021-11-01
419 Old Guy BMX Racing, then Park Riding: SeaTac BMX Track and Burien Park BMX: Rad Fun! 2:12 2021-10-31
420 Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763 12:37 2021-10-27
421 Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762 8:19 2021-10-22
422 Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761 3:46 2021-10-18
423 Excel & Statistics Busn 210, Week 4, Day 1, Fall Quarter, 2021 3:56 2021-10-17
424 INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2. 2:09 2021-10-12
425 VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760 4:33 2021-10-11
426 Sunday Oct 10, 2021 Old Guy BMX Park Fun at Lower Woodland BMX Park 2:01 2021-10-10
427 Excel Hack Video: Power Query to fix files in Windows Explorer? Excel Magic Trick 1759 4:14 2021-10-07
428 VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758 5:26 2021-10-05
429 Power Query From Sheet option Import Tables, Defined Names or Dynamic Arrays. Fast Keyboard EMT 1757 1:53 2021-09-27
430 Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756 2:29 2021-09-23
431 Busn 210 – Statistical Analysis with Excel - Fall 2021 Introduction Video 13:50 2021-09-22
432 Busn 135 - Business Math - Fall 2021 Introduction Video 11:43 2021-09-22
433 Import OneDrive File or Folder using Power Query. EMT 1755 4:29 2021-09-20
434 Tulalip Skate-BMX Park Sunday Rad: Two Old Guys and a Kid! 1:53 2021-09-19
435 Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754 4:46 2021-09-17
436 Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753 1:58 2021-09-13
437 Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752 9:14 2021-09-07
438 Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751 4:43 2021-08-31
439 BMX Old Guy Sunday Fun: Lake Stevens Park. Old Guys Just Wanna Have Fun! 1:26 2021-08-30
440 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750 3:04 2021-08-24
441 7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749 16:30 2021-08-17
442 BMX Park Old Guy Sunday Fun at Greenlake Lower Woodland Skate-BMX, Seattle, WA, Aug 15, 2021 1:28 2021-08-15
443 Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748 6:59 2021-08-10
444 Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747 16:31 2021-08-03
445 IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746 9:05 2021-07-28
446 Excel Magic Trick 1745 Part 2: Create & Spill Random Normally Distributed Values 1:02 2021-07-26
447 11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745 10:15 2021-07-20
448 Average Excluding Min and MAX Values. TRIMMEAN function. 6 Formula Examples. EMT 1744 6:16 2021-07-13
449 OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743 10:33 2021-07-06
450 Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742 11:38 2021-06-29
451 Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741 2:43 2021-06-22
452 Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740 11:18 2021-06-14
453 SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739 5:56 2021-06-08
454 Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738. 11:44 2021-05-31
455 Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737. 9:45 2021-05-24
456 Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas 58:02 2021-05-10
457 Excel Data Analysis Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals 1:16:13 2021-05-03
458 Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More! 1:16:25 2021-04-26
459 Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts 36:04 2021-04-19
460 Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736. 6:21 2021-04-16
461 New Excel & Business Instructor at Highline College, Here @ YouTube too! 0:33 2021-04-15
462 Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data 5:30 2021-04-12
463 Organizational Data Types in Excel M365 & Power BI. Excel Magic Trick 1735 3:27 2021-04-09
464 Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734. 4:38 2021-04-07
465 Create PivotTable in Excel Online. Excel Magic Trick 1733. 3:00 2021-04-05
466 Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732 4:35 2021-04-02
467 Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731 6:10 2021-03-30
468 BI 348 - Microsoft Power Tools - Spring 2021: Introduction Video 4:31 2021-03-28
469 Busn 135 - Business Math - Spring 2021: Introduction Video 11:10 2021-03-26
470 PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730 12:17 2021-03-23
471 4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729. 7:08 2021-03-16
472 Old Guy BMX Park & Racing in Same Day = Rad! 1:25 2021-03-07
473 Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727. 5:34 2021-03-01
474 Moving Annual Total with DAX Measure. Excel Magic Trick 1726. 4:50 2021-02-23
475 Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725 15:43 2021-02-18
476 Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724 4:27 2021-02-15
477 Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723 4:12 2021-02-12
478 Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722 5:06 2021-02-08
479 Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2 1:18 2021-02-04
480 Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721 5:04 2021-02-01
481 PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720 7:02 2021-01-25
482 Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719 7:19 2021-01-20
483 INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718 3:32 2021-01-18
484 Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717 6:57 2021-01-15
485 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716 4:52 2021-01-13
486 Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715 2:02 2021-01-11
487 BMX Saturday Seattle Park Adventure: 3 Parks, 2 Kids, 3 Old Guys! 2:38 2021-01-11
488 Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714. 13:09 2021-01-08
489 Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713 9:24 2021-01-06
490 INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712. 14:09 2021-01-05
491 Old Guy BMX Park . Lower Woodland Skate Park, Seattle January 3, 2021. 1:58 2021-01-05
492 Excel Magic Flashing Christmas Tree. Plus, BIG LET Surprise!!! Excel Magic Trick 1711 1:56 2020-12-25
493 Christmas Eve 2020 Old Guy BMX Park Fun! 1:52 2020-12-25
494 Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710 8:35 2020-12-22
495 Highline College Busn 210 Statistical Analysis with Excel Intro Video, Winter & Spring 2021 8:27 2020-12-22
496 Highline College Busn 135 Winter 2021 Intro Video 11:11 2020-12-22
497 Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709 6:56 2020-12-20
498 Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708. 5:15 2020-12-14
499 12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707 14:38 2020-12-09
500 Getting BMX Rad at Jefferson Park, Seattle, WA, Sunday in the Rain! 1:50 2020-12-08
501 LAMBDA Excel Function. LET & LAMBDA together to make Single Cell Reports. Excel Magic Trick 1706 5:26 2020-12-04
502 MOD function & Number.Mod Functions. Why They Give Different Answers. Excel Magic Trick 1705. 9:11 2020-12-01
503 Old Guy Park Rad. Even When It Rains! Green Lake Lower Woodland Skatepark. 2:06 2020-11-29
504 Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704. 1:51 2020-11-27
505 Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703. 24:50 2020-11-23
506 Old Guy BMX. 5 Parks in One Day: Walter E Hall, Snohomish, Lake Stevens, Kenmoore, Woddenville. 2:35 2020-11-22
507 Basics of Excel Spilled Array Formulas to create Monthly Sales Report. Excel Magic Trick 1702. 15:02 2020-11-19
508 Basics of SUMIFS & PivotTables for Monthly Sales Report. Excel Magic Trick 1701. 9:20 2020-11-16
509 Biggest Sale for Each Product: PivotTable, Formulas or Power Query? Excel Magic Trick 1700. 5:59 2020-11-13
510 Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699. 18:53 2020-11-10
511 How to Rank in Power Query. EMT 1698 by excelisfun. 3:44 2020-11-02
512 Free Excel Finance Course at YouTube 1:22 2020-10-26
513 Free YouTube Excel for Statistical Analysis in Business & Economics Course 1:08 2020-10-26
514 Free Excel Business Analytics (Statistics & Math) Course at YouTube 0:55 2020-10-26
515 Free Excel Business Math & Formulas Course at YouTube 1:10 2020-10-26
516 Free Advanced Data Analysis & BI Course at YouTube (MSPTDA) 1:48 2020-10-26
517 Free Excel Data Analysis Basics Course at YouTube (E-DAB) 1:33 2020-10-26
518 Free Advanced Excel Course at YouTube 1:04 2020-10-26
519 Free Excel Basics Course at YouTube 1:06 2020-10-26
520 OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697. 6:11 2020-10-25
521 Excel FILTER based on list, not individual values? Easy! Excel Magic Trick 1696. 3:56 2020-10-18
522 Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695. 9:38 2020-10-13
523 XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694. 5:20 2020-10-09
524 FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693. 13:30 2020-10-05
525 Dynamic Count Between Lower & Upper Limit Report! Excel Magic Trick 1692. 7:26 2020-09-28
526 Highline College Busn 210 Statistical Analysis with Excel Intro Video 8:26 2020-09-24
527 Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691. 9:56 2020-09-21
528 Highline College Busn 135 Fall 2020 Intro Video 11:44 2020-09-21
529 Expand Years to Rows: Power Query or VBA? Dueling Excel #195 with Mr Excel & Excelisfun 8:54 2020-09-18
530 Create Excel Database and Data Entry Form. Excel Magic Trick 1690. 8:08 2020-09-14
531 Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689. 6:59 2020-09-11
532 List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688. 4:47 2020-09-09
533 List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687. 7:07 2020-09-07
534 Compare Two Lists, Deliver Cell Address. Dueling Excel #194 with Mr Excel & Excelisfun 11:27 2020-09-04
535 Dynamic Excel Amortization Table. Microsoft 365 Spilled Array Magic! Excel Magic Trick 1686. 11:21 2020-08-31
536 Power Query Split, Add, Combine. Dueling Excel #193 with Mr Excel & Excelisfun 13:27 2020-08-28
537 FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685. 5:08 2020-08-25
538 SPLIT, JOIN and ARRAYFORMULA Functions in Google Sheets to Split Text & Add Numbers. GS 1. EMT 1684. 2:01 2020-08-24
539 Add 500 to All Numbers in Text String? LET or VBA? Dueling Excel #192 with Mr Excel & Excelisfun 11:51 2020-08-21
540 Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683. 7:59 2020-08-17
541 Dueling Excel #191: Net Working Hours Spanning Midnight & Weekend with Mr Excel & Excelisfun 17:11 2020-08-14
542 Append Two Number Columns and Sort. Excel Magic Trick 1682. 5:10 2020-08-10
543 LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681. 14:32 2020-08-03
544 Excel Conditional Formatting Weekend & Holiday Date for Row in Table. Excel Magic Trick 1680. 6:02 2020-07-27
545 Excel Table Column Formulas and Spilled Arrays? Excel Magic Trick 1679 3:38 2020-07-20
546 Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678. 11:50 2020-07-11
547 Replace & Text To Columns to Convert Text Dates to Real Dates. Excel Magic Trick 1677 1:51 2020-07-09
548 Convert SAP Dates to Real Dates in Excel. Excel Magic Trick 1676 4:52 2020-07-06
549 Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675. 6:01 2020-07-01
550 Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674 6:07 2020-06-29
551 LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673 7:01 2020-06-22
552 Lookup 2nd Smallest Number. 2nd Biggest too. UNIQUE or FREQUENCY function? Excel Magic Trick 1672 6:38 2020-06-15
553 SORTBY, UNIQUE, INDEX and SUMIFS Functions: Dynamic Spilled Array Reports. Excel Magic Trick 1671 7:28 2020-06-08
554 Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670 12:18 2020-06-01
555 Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669. 6:08 2020-05-16
556 INDEX & MATCH or XLOOKUP for Lookup Formula in SUMIFS Criteria Argument. Excel Magic Trick 1668. 5:11 2020-05-13
557 Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667 8:26 2020-05-09
558 Show File Extensions (File Types). EMT 1666 1:11 2020-05-07
559 Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665. 8:49 2020-05-05
560 Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664 10:42 2020-05-01
561 Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663 6:49 2020-04-28
562 Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661 8:18 2020-04-23
563 Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660. 22:22 2020-04-17
564 Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662 0:57 2020-04-12
565 Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659 18:33 2020-04-10
566 Learn At Home With YouTube. Amazing Free Learning Resources for Kids, Families & The Rest of Us Too 1:13 2020-04-06
567 Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658. 9:56 2020-04-03
568 PivotTables Are Easy: 6 Criteria Cross Tabulated Counting Report. Excel Magic Trick 1657. 5:35 2020-04-01
569 Highline College BI 348, People & Canvas Web Sites Introduction 4:03 2020-03-31
570 COUNTIFS 6 Criteria Counting Cross Tab Report. Change Cell Reference Every 3 Columns Too! EMT 1656 11:34 2020-03-29
571 Excel Music Video: UNSTOPPABLE Office 365 Excel. Old School Formulas v. New School Formulas EMT 1655 3:09 2020-03-27
572 INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654 4:31 2020-03-26
573 Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653 3:33 2020-03-25
574 Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652 5:42 2020-03-24
575 Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651 4:17 2020-03-23
576 Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650. 5:03 2020-03-22
577 Create a Dynamic Lookup Table using INDEX & LOOKUP Functions. Excel Magic Trick 1649 4:26 2020-03-21
578 Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648 5:28 2020-03-20
579 Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647 8:05 2020-03-17
580 Welcome to the excelisfun Excel YouTube Channel! 1:42 2020-03-14
581 Append Multiple Columns with Excel Dynamic Spilled Array Formula. Excel Magic Trick 1646. 8:28 2020-03-13
582 OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645 6:35 2020-03-11
583 Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644. 6:47 2020-03-07
584 Free Excel Business Math & Formulas Course at YouTube 1:45 2020-03-05
585 Highline College Assessment by M. Girvin about Microsoft Big Data Tools in the Classroom 3:34 2020-03-02
586 Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643 8:55 2020-02-28
587 Free Excel Basics Course at YouTube 2:03 2020-02-26
588 Free Advanced Excel Course at YouTube 1:39 2020-02-24
589 Free Excel Finance Cash Flow Model Building Course at YouTube 3:11 2020-02-21
590 Free Excel Business Analytics (Statistics & Math) Course at YouTube 1:34 2020-02-19
591 excelisfun YouTube Birthday Party: 12 Years @ YouTube. Feb 15, 2008 – Feb 15, 2020. 1:11 2020-02-15
592 Free Excel for Statistical Analysis in Business & Economics Course at YouTube 1:57 2020-02-13
593 Free Advanced Data Analysis & BI Course at YouTube (MSPTDA) 2:49 2020-02-11
594 Free Excel Data Analysis Basics Course at YouTube (E-DAB) 2:28 2020-02-07
595 Flash Fill, Array Formula or Power Query? To Insert Dash Between Text & Number. EMT 1641 6:45 2020-02-03
596 REPLACE Function to Insert a Dash Into Text. Flash Fill Too. Excel Magic Trick 1639 2:36 2020-01-31
597 Which Lookup Formula is Fastest? Excel Magic Trick 1631 Part 02 2:51 2020-01-29
598 Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634 17:24 2020-01-23
599 Power Query to Insert Dashes into Text. Flash Fill too! Excel Magic Trick 1638 3:44 2020-01-19
600 TEXTJOIN & MID? LEFT, 2 MID, RIGHT? Excel Formulas to Insert Dashes into Text Excel Magic Trick 1637 3:32 2020-01-17
601 Excel Formula for Discounted Sales: Standard Formula or Spilled Arrays? Excel Magic Trick 1636 5:32 2020-01-14
602 Excel FIXED Function Easier than TEXT Function! (DOLLAR Function too). Excel Magic Trick 1635 2:54 2020-01-11
603 Repeat Number Down Column with Excel Formula & Conditional Formatting - Excel Magic Trick 1633 5:14 2020-01-10
604 Dynamic Inventory Running Total Excel SUMIFS Formula Based on Transaction Records (EMT 1632) 4:03 2020-01-07
605 Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631. 9:00 2020-01-03
606 Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629. 10:46 2019-12-30
607 Count NOT “Apple” with Excel Formula & Conditional Formatting - Excel Magic Trick 1630 2:37 2019-12-27
608 Spilled Array Christmas Tree in Excel. Conditional Formatting Christmas Tree. Excel Magic Trick 1628 1:18 2019-12-24
609 MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables 13:23 2019-12-22
610 Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621 15:43 2019-12-20
611 VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627 4:23 2019-12-19
612 Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626) 18:34 2019-12-13
613 Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625 3:46 2019-12-08
614 Double The Records When I Refresh? Power Query Excel.CurrentWorkbook Recursion - EMT 1624 2:03 2019-12-06
615 Repeat Columns in my Power Query Append?? Too Many Columns? Extra Columns? EMT 1623 8:04 2019-12-05
616 Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622) 9:44 2019-11-30
617 Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620 9:32 2019-11-25
618 How To Import Text File into Excel (4 Examples, including Tab & CSV Files) – Excel Magic Trick 1619 3:23 2019-11-22
619 INDEX & MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes (EMT 1618) 12:25 2019-11-15
620 Split Text By Capital Letters in Excel using Power Query EMT 1617 7:58 2019-11-09
621 Bring Excel Sheet Variable Into a DAX Measure (Measure Input From Excel Sheet) EMT 1616 5:53 2019-11-03
622 Bring Excel Sheet Variable Into Power Query (Query Input from Excel Sheet) - EMT 1615 4:58 2019-11-01
623 TEXTJOIN & TEXT Functions working on Multiple Rows or Columns (DOLLAR Function too) EMT 1614 4:41 2019-10-29
624 MSPTDA 35: Power BI & DAX Formula for Data Modeling with a Slowly Changing Dimensions 10:34 2019-10-26
625 MSPTDA 34: Data Modeling for Slowly Changing Dimensions with Power Query & Power Pivot 11:30 2019-10-25
626 Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613 3:47 2019-10-22
627 MSPTDA 33 Part 2: Power Query & Standard PivotTable To Show All Employees Sales Or Not 7:10 2019-10-21
628 Excel Formula for Text Number Label with Lead Zeroes: 010-030, 030-050, 050-070 - EMT 1612 5:24 2019-10-19
629 MSPTDA 33: Data Modeling for Slowly Changing Dimensions with Power Query & PivotTable 12:46 2019-10-17
630 MSPTDA 32: Slowly Changing Dimensions Team-Employee Report with Worksheet Formulas 8:34 2019-10-14
631 XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611 1:50 2019-10-11
632 Extract Top 5 Values with Names with Dynamic Array Formulas & Conditional Formatting – EMT 1610 4:47 2019-10-08
633 excelisfun Flashback Friday 05: Extract Top 5 Values & Names with Array Formula 18:16 2019-10-05
634 excelisfun Flashback Friday 04: Randomized Conditional Formatting Set to 80s Music!?!?! 1:31 2019-10-03
635 Excel Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609 6:08 2019-09-29
636 Dynamic Array & Old Array Formulas to Create Student Classes Report - Excel Magic Trick 1608 7:48 2019-09-26
637 DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607 4:22 2019-09-24
638 List Student Classes in Single Cell – Power Query (From Text File & Parameter Query)- EMT 1606 10:59 2019-09-22
639 Sum Last Digits for All Numbers - Excel Magic Trick 1605 3:27 2019-09-20
640 Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604 3:29 2019-09-19
641 Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603 3:13 2019-09-18
642 Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601 4:14 2019-09-14
643 3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602 3:56 2019-09-14
644 Highline College Busn 218 Class Introduction Video 6:29 2019-09-14
645 Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600 25:02 2019-09-06
646 Extract Customer Names, Not in Master Lists with Power Query - Excel Magic Trick 1599 3:53 2019-09-04
647 Extract Customer Names, Not in Master Lists with Advanced Filter - Excel Magic Trick 1598 5:06 2019-09-02
648 Excel Formula to Extract Items from Two Lists - Excel Magic Trick 1597. Is Item NOT in List? 3:40 2019-08-31
649 Excel Formula to Compare Two Lists - Excel Magic Trick 1596. Is Item in List? 4:33 2019-08-28
650 Array Formula: Filter Rows with List of Does NOT Contain Criteria - Excel Magic Trick 1595 5:52 2019-08-27
651 Advanced Filter: Filter Rows with List of Does NOT Contain Criteria - Excel Magic Trick 1594 4:01 2019-08-25
652 Power Query Filter Rows by NOT Contains Criteria - Single Formula Solution - Excel Magic Trick 1593 8:05 2019-08-23
653 Power Query - Filter Table Based on Distinct NOT Conditions from List - Excel Magic Trick 1592 9:18 2019-08-21
654 One Lookup Value, Return Multiple Items – The Easy Way with FILTER - Excel Magic Trick 1591 1:44 2019-08-19
655 Two Lookup Values for Excel Lookup? FILTER or INDEX? - Excel Magic Trick 1590 2:07 2019-08-17
656 excelisfun Flashback Friday 03: VLOOKUP & Data Validation 4:34 2019-08-16
657 Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589 4:39 2019-08-14
658 Power Query Running Count Based on Row Condition – Excel Magic Trick 1588 7:25 2019-08-13
659 Count Number of Saturdays in Month - 5 Different Formulas!- Excel Magic Trick 1587 8:51 2019-08-11
660 Dynamic Arrays to Increment 1-6, 7-12, 13-18 - SEQUENCE Array Function… - Excel Magic Trick 1586 2:30 2019-08-09
661 Excel Formula to Increment Numbers: 1-6, 7-12, 13-18 for Raffle Ticket - Excel Magic Trick 1585 4:23 2019-08-08
662 Show Formula & Cell Location with Excel Text Formula, Unicode Arrow too - Excel Magic Trick 1584 3:35 2019-08-06
663 Extract Date from End of Description with Excel Worksheet Formula - Excel Magic Trick 1583 1:48 2019-08-04
664 excelisfun Flashback Friday 02: AVERAGE with Zeroes or Blanks? Ctrl + Enter Keyboard 3:11 2019-08-02
665 Extract Data From Cell with Flash Fill - Excel Magic Trick 1582 1:29 2019-08-01
666 Excel Formula to Reverse First & Last Name. Better Than Power Query & Flash Fill? - EMT 1581 3:21 2019-07-31
667 Power Query - Group Suppliers, Join with Line Feed From Multiple Text Files - Excel Magic Trick 1580 9:30 2019-07-30
668 Array Formula - List All Suppliers by Material in Single Cell with Line Feed, Excel Magic Trick 1579 5:52 2019-07-29
669 Excel PivotTable Keyboard? Keyboard for PivotTable –Excel Magic Trick 1578 0:38 2019-07-29
670 Summarize Survey Results with PivotTable in One Minute - Excel Magic Trick 1577 1:01 2019-07-28
671 Power Query M Code Group By Formula to Transform Invoice Table - Excel Magic Trick 1576 7:25 2019-07-26
672 Unique Invoice / Vendor List with Items Listed Horizontally - Excel Dynamic Array Formula- EMT 1575 4:11 2019-07-25
673 OFFSET Function Dynamic Range inside COUNTIFS Function - Excel Magic Trick 1573 4:40 2019-07-24
674 INDEX Function To Lookup Column inside COUNTIFS Function - Excel Magic Trick 1574 2:52 2019-07-24
675 Excel Conditional Format Row, Column & Intersecting Cell - Excel Magic Trick 1572 4:39 2019-07-22
676 Excel’s # 1 Silliest Formula: INDEX or INDIRECT? Excel Magic Trick 1571 (Two Way Lookup Trick) 4:41 2019-07-21
677 Excel Intersection Operator, An Excel Party Trick? - Excel Magic Trick 1570 1:10 2019-07-19
678 Excel Union Operator For Aggregate, Statistical & Finance Functions - Excel Magic Trick 1569 2:40 2019-07-19
679 Excel Two Way Lookup with INDEX & MATCH Functions - Excel Magic Trick 1568 2:32 2019-07-18
680 Excel Two Way Lookup with VLOOKUP & MATCH Functions - Excel Magic Trick 1567 2:40 2019-07-18
681 Excel Keyboard Shortcut to Jump To Formula Bar. Excel Magic Trick 1566. 1:41 2019-07-17
682 Excel Keyboard to Insert Sheet & Rename Sheet. Excel Magic Trick 1565. (Sheet Tab or Worksheet) 0:33 2019-07-17
683 4 Types of Criteria for SUMIFS & COUNTIFS - Excel Magic Trick 1564, SUMIF & COUNTIF too 6:50 2019-07-16
684 Last Working Day Of Month – Excel Formula – Excel Magic Trick 1563 2:51 2019-07-15
685 Excel Formulas & Functions – excelisfun Flashback Friday 01 – Excel Basics 10:54 2019-07-12
686 YouTube Learning Playlists Announcement for excelisfun, July 11, 2019 1:45 2019-07-12
687 Jump To Any Excel Sheet – 7 Methods in One Minute – Excel Magic Trick 1562 1:08 2019-07-10
688 DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561) 11:06 2019-07-09
689 Excel Magic Trick 1560: Half Year Running Totals in PivotTable 5:32 2019-07-08
690 Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales 4:20 2019-07-07
691 Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change 3:27 2019-07-05
692 Keyboard Shortcut to Open Smart Tags in Excel, Word & PowerPoint (Excel Magic Trick 1557) 1:10 2019-07-03
693 Create Column of Month End Dates in Excel - Excel Magic Trick 1556 0:54 2019-07-02
694 Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555 3:32 2019-07-01
695 MSPTDA 31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT? 15:12 2019-06-28
696 Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554 21:48 2019-06-20
697 MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports 10:19 2019-06-14
698 MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas 10:20 2019-06-11
699 Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553 31:16 2019-06-07
700 MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship 17:28 2019-06-02
701 MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships 13:38 2019-05-31
702 Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula: Excel Magic Trick 1552 22:45 2019-05-28
703 MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model 10:51 2019-05-23
704 MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH 6:17 2019-05-23
705 Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND 7:46 2019-05-19
706 MSPTDA 24: DAX Multiply / Divide Data Types Discrepancies Solved! 6:29 2019-05-18
707 MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table 1:04:59 2019-05-15
708 MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations 20:08 2019-05-08
709 MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size 25:13 2019-05-04
710 MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query 11:07 2019-04-27
711 COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550 3:11 2019-04-22
712 COUNTIFS in Power Query? Excel Magic Trick 1549 2:12 2019-04-19
713 Excel Table NOT Automatically Copy Formula Down Column? Option Setting to Fix This. Magic Trick 1548 1:40 2019-04-17
714 Excel Table NOT Automatically Add New Column or Rows? Option Setting to Fix This. Magic Trick 1547 1:10 2019-04-15
715 Power Query Get Previous Row? Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546 12:44 2019-04-10
716 Create Random Data, Variable Height INDEX & RANDARRAY Dynamic Array Function: Excel Magic Trick 1545 6:46 2019-04-08
717 Excel Magic Trick 1544: FILTER Array Function to Filter Between Upper & Lower Text Number Limits 6:20 2019-04-06
718 E-DAB 00: Introduction to Excel Data Analysis & Business Intelligence Class: E-DAB YouTube Class! 1:35 2019-03-30
719 Introduction to People & Canvas Web Sites for Highline College BI 348 Class 6:27 2019-03-30
720 E-DAB-10: Excel & Power BI Together! Import, Publish and Share Reports & Visualizations 14:37 2019-03-27
721 E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations 37:37 2019-03-26
722 E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards 44:42 2019-03-22
723 E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot? 45:21 2019-03-16
724 E-DAB 06: The Magic of Power Query to Import, Transform & Load Data 26:40 2019-03-10
725 E-DAB 05: Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards 54:41 2019-03-07
726 E-DAB 04: PivotTables & Slicers Create Dashboards & Summary Reports 28:55 2019-02-27
727 E-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays? 29:53 2019-02-24
728 E-DAB 02: Data, Proper Data Sets, Excel Tables, Logical Tests, More 35:27 2019-02-21
729 E-DAB 01: What is Data Analysis & Business Intelligence? 12:42 2019-02-19
730 Excel Magic Trick 1543: MAXIFS & MINIFS to Lookup Numbers on Either Side of Hurdle 3:20 2019-02-16
731 Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?! 7:09 2019-02-15
732 Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS 7:09 2019-02-14
733 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column 6:00 2019-02-13
734 Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array). 5:46 2019-02-12
735 Excel Magic Trick 1538: Sum Last Digit of Each Cell in Range with SUM or SUMPRODUCT? 5:05 2019-02-11
736 MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples) 1:48:28 2019-02-02
737 Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue 4:39 2019-01-18
738 EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts 10:50 2019-01-15
739 EMT 1535: Average Daily Revenue: SUMIFS with INDIRECT? or SEQUENCE? Inside AVERAGE 8:08 2019-01-13
740 Traditional Arrays or Office 365 Dynamic Arrays? Count Unique Dates Product Was Sold. EMT 1534 7:37 2019-01-09
741 VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function? 7:56 2019-01-06
742 MSPTDA 18: DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI 1:07:00 2018-12-30
743 Count Products Report: Excel? DAX? Power Query? Office 365? Excel Magic Trick 1533 15:38 2018-12-23
744 MSPTDA 17: Power BI Online: Dashboards, Reports, Excel Workbooks, Data Sets. 8:35 2018-12-18
745 VLOOKUP To Get Complete Record: ROWS, COLUMNS or SEQUENCE Function? EMT 1532 8:30 2018-12-15
746 MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing 1:19:35 2018-12-09
747 MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions 2:04:00 2018-11-17
748 Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531) 6:46 2018-11-11
749 Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530) 12:31 2018-11-09
750 Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529) 17:03 2018-11-07

Embed a badge

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

Watch time: 6d 19m · 750 videos

Markdown
[![Watch time: 6d 19m · 750 videos](https://playlistduration.com/badge/playlist/UUkndrGoNpUDV-uia6a9jwVg.svg)](https://playlistduration.com/playlist/UUkndrGoNpUDV-uia6a9jwVg)
HTML
<a href="https://playlistduration.com/playlist/UUkndrGoNpUDV-uia6a9jwVg"><img src="https://playlistduration.com/badge/playlist/UUkndrGoNpUDV-uia6a9jwVg.svg" alt="Watch time: 6d 19m · 750 videos" width="210" 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/UUkndrGoNpUDV-uia6a9jwVg 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.