Playlist Duration

Playlist · excelisfun

Latest excelisfun Videos

by excelisfun · 715 videos (2 unavailable)

Total watch time

6d 15h 44m

at 1× speed · exactly 6 days, 15 hours, 43 minutes, 40 seconds at 1×

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

The shape of the course

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

10h 27m

WatchedTo watch

Compare Open on YouTube JSON

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

Your plan

Plan to finish

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

Videos (717)

6d 15h 44m in total · tick what you've watched

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

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

Embed a badge

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

Watch time: 6d 15h 44m · 715 videos

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

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