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