playlistduration

Excel Accounting Playlist Of Videos

by excelisfun · 428 videos (1 unavailable)

Total watch time

3d 17h 55m

at 1× speed · exactly 3 days, 17 hours, 54 minutes, 56 seconds at 1×

1×3d 17h 54m 56s
1.25×2d 23h 55m 57s
1.5×2d 11h 56m 37s
1.75×2d 3h 22m 49s
2×1d 20h 57m 28s
Average video12m 36s
Longest3h 44m 8s
Shortest36s
Compare Open on YouTube JSON

Plan to finish

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

Videos (429)

3d 17h 55m in total · tick what you've watched

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

Videos to
Watched
1 Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar 2:22:28 2017-04-24
2 Excel for Accountants: Power Query & PivotTables to Import & Clean Data and Build Reports 51:24 2017-07-12
3 Excel for Accountants: Formulas, Functions & Formatting to Build Account Templates (37 Examples) 1:37:02 2017-07-10
4 PivotTables & Slicers Made Easy! 4 Amazing Examples for WAAT Accounting Seminar August 26, 2016 35:38 2016-08-24
5 All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX – 28 Examples! - 365 MECS 08 1:18:51 2022-10-20
6 Excel & Power BI Data Analysis Complete Class in One Video - 4 Hours - Download Files - 365 MECS 04 3:44:08 2022-08-21
7 Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards 2:44:10 2013-08-29
8 Excel For Accountants: VLOOKUP & PivotTables Complete Lessons: Basic to Advanced: CWU Seminar 1:32:45 2017-01-12
9 10 Amazing Excel Lookup Formulas for WAAT Accounting Seminar August 26, 2016, VLOOKUP & More 1:01:03 2016-08-24
10 Excel 2013 Accounting Tricks for Excel CPE Credit at Poodle Dog Restaurant (50 Examples) 1:19:49 2015-04-17
11 Excel Magic Trick 744: Break Even Analysis Formulas Chart & Plotting Break Even Point On Chart 18:02 2010-12-08
12 Excel 2013 PivotTables from A to Z for the Northwest Accounting Educators 2015 Conference 1:04:47 2015-08-31
13 Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression - Ron's Class 22:24 2009-03-02
14 ACCTG 455: Excel Finance Class 84: Undoing Accrual Accounting to Get Cash Flows For Estimating NPV 7:10 2010-11-14
15 Excel Accounting Schedule of Expected Cash Collections Using A Set Of Assumptions / Formula Inputs 40:00 2013-07-25
16 Excel Magic Trick 1129: Aging Accounts Receivable Reports Using Slicer, Excel Table, Page Setup 9:20 2014-07-15
17 Excel Magic Trick 1130: Aging Accounts Receivable Reports Using Advanced Filter & Page Setup 6:51 2014-07-15
18 Excel Magic Trick 1133: Aging Accounts Receivable Reports: PivotTable & Unique Identifier 9:37 2014-07-16
19 Excel Magic Trick 1128: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula 26:34 2014-07-13
20 Excel for Accounting and Finance - Northwest Accounting Educators Conference 2012 - NAE 2012 1:47:41 2012-09-03
21 Excel 2010 - 20 New Excel 2010 Features - Northwest Accounting Educator's Conference 2011 52:08 2011-09-02
22 Excel Magic Trick #132: Borders For an Accounting Template 7:19 2008-10-17
23 Excel Magic Trick 745: Allocating Indirect Expenses to Calculate Departmental Net Income Accounting 10:58 2010-12-08
24 Excel 2010 Statistics 48: Accounting & Finance Examples of Expected Value & Standard Deviation 17:25 2011-07-15
25 Excel Magic Trick 739: Three Ways To Do Double Underline in Excel 2:18 2010-11-14
26 ACCTG 455: Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis 30:17 2010-09-30
27 ACCTG 455: Excel Finance Class 11: Finance Cash Flow From Accounting Information 38:26 2010-09-23
28 Excel Magic Trick 695: Allocate Total Costs across Categories Including Extra Pennies 6:03 2010-08-06
29 Excel Magic Trick 607: Match 3 Lists: Matching Accounting Documents PO, Receiving & Invoice 10:51 2010-05-20
30 Excel Magic Trick 366: Lookup Adding For Accounting Estimate 3:15 2009-08-13
31 Excel Busn Math 41: Payroll Deductions With Ceilings (FICA) 18:34 2009-04-26
32 Highline Excel 2013 Class Video 49: Break Even Analysis Formulas & Chart, Plotting Break Even Point 13:26 2013-12-22
33 Excel Magic Trick 1074: Multiply Quantity Times Debit or Credit: 3 Formulas Examples. 3:47 2014-02-24
34 Excel Magic Trick 1078: Total Cost Based On Per Minute Charge & Excel Time Values Nearest 15 Seconds 5:50 2014-02-28
35 Excel Magic Trick 1077: Floating Cell In Excel? Watch Window to See Formula Anywhere in Workbook 3:21 2014-02-28
36 Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable 6:55 2014-07-15
37 Power BI Desktop: Build Data Model, Get Data, DAX Formulas, Visualizations, Publish 2 Web (EMT 1366) 1:12:07 2016-12-31
38 Excel Magic Trick 1410: Calculate Closing Balance for Each Month from Balance Transaction Table 10:40 2017-04-30
39 Power BI for Accountants: Complete Introduction to Power BI Desktop to Build Reports & Dashboards 40:45 2017-07-20
40 Excel Magic Trick 1455: Convert Text Month Criteria to Upper & Lower Dates for SUMIFS Function 10:35 2017-08-15
41 MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop 19:11 2018-09-10
42 MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries 21:19 2018-09-22
43 Excel Magic Trick 1515: Yearly Income Statement Using SUMIFS Function, and NO Merge & Center 6:46 2018-10-08
44 MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel 19:09 2018-10-12
45 Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) 39:40 2018-10-20
46 Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518 7:44 2018-10-23
47 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520 9:16 2018-10-24
48 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528 13:02 2018-10-28
49 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
50 Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530) 12:31 2018-11-09
51 MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions 2:04:00 2018-11-17
52 MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing 1:19:35 2018-12-09
53 VLOOKUP To Get Complete Record: ROWS, COLUMNS or SEQUENCE Function? EMT 1532 8:30 2018-12-15
54 VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function? 7:56 2019-01-06
55 EMT 1535: Average Daily Revenue: SUMIFS with INDIRECT? or SEQUENCE? Inside AVERAGE 8:08 2019-01-13
56 EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts 10:50 2019-01-15
57 Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue 4:39 2019-01-18
58 MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples) 1:48:28 2019-02-02
59 Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array). 5:46 2019-02-12
60 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column 6:00 2019-02-13
61 Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS 7:09 2019-02-14
62 Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?! 7:09 2019-02-15
63 E-DAB 06: The Magic of Power Query to Import, Transform & Load Data 26:40 2019-03-10
64 E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot? 45:21 2019-03-16
65 E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards 44:42 2019-03-22
66 E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations 37:37 2019-03-26
67 E-DAB-10: Excel & Power BI Together! Import, Publish and Share Reports & Visualizations 14:37 2019-03-27
68 Excel Magic Trick 1544: FILTER Array Function to Filter Between Upper & Lower Text Number Limits 6:20 2019-04-06
69 Excel Table NOT Automatically Add New Column or Rows? Option Setting to Fix This. Magic Trick 1547 1:10 2019-04-15
70 COUNTIFS in Power Query? Excel Magic Trick 1549 2:12 2019-04-19
71 COUNTIFS in Power Query? Excel Magic Trick 1549 2:12 2019-04-19
72 COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550 3:11 2019-04-22
73 COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550 3:11 2019-04-22
74 MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query 11:07 2019-04-27
75 MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table 1:04:59 2019-05-15
76 Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND 7:46 2019-05-19
77 MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH 6:17 2019-05-23
78 MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model 10:51 2019-05-23
79 MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships 13:38 2019-05-31
80 MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship 17:28 2019-06-02
81 MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas 10:20 2019-06-11
82 MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas 10:20 2019-06-11
83 Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554 21:48 2019-06-20
84 Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555 3:32 2019-07-01
85 Create Column of Month End Dates in Excel - Excel Magic Trick 1556 0:54 2019-07-02
86 Keyboard Shortcut to Open Smart Tags in Excel, Word & PowerPoint (Excel Magic Trick 1557) 1:10 2019-07-03
87 Keyboard Shortcut to Open Smart Tags in Excel, Word & PowerPoint (Excel Magic Trick 1557) 1:10 2019-07-03
88 Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change 3:27 2019-07-05
89 Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales 4:20 2019-07-07
90 Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales 4:20 2019-07-07
91 Excel Magic Trick 1560: Half Year Running Totals in PivotTable 5:32 2019-07-08
92 Jump To Any Excel Sheet – 7 Methods in One Minute – Excel Magic Trick 1562 1:08 2019-07-10
93 Last Working Day Of Month – Excel Formula – Excel Magic Trick 1563 2:51 2019-07-15
94 Last Working Day Of Month – Excel Formula – Excel Magic Trick 1563 2:51 2019-07-15
95 Unique Invoice / Vendor List with Items Listed Horizontally - Excel Dynamic Array Formula- EMT 1575 4:11 2019-07-25
96 Power Query M Code Group By Formula to Transform Invoice Table - Excel Magic Trick 1576 7:25 2019-07-26
97 Power Query - Group Suppliers, Join with Line Feed From Multiple Text Files - Excel Magic Trick 1580 9:30 2019-07-30
98 Extract Data From Cell with Flash Fill - Excel Magic Trick 1582 1:29 2019-08-01
99 Extract Date from End of Description with Excel Worksheet Formula - Excel Magic Trick 1583 1:48 2019-08-04
100 Count Number of Saturdays in Month - 5 Different Formulas!- Excel Magic Trick 1587 8:51 2019-08-11
101 Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600 25:02 2019-09-06
102 3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602 3:56 2019-09-14
103 Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601 4:14 2019-09-14
104 Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603 3:13 2019-09-18
105 Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604 3:29 2019-09-19
106 Sum Last Digits for All Numbers - Excel Magic Trick 1605 3:27 2019-09-20
107 DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607 4:22 2019-09-24
108 Dynamic Array & Old Array Formulas to Create Student Classes Report - Excel Magic Trick 1608 7:48 2019-09-26
109 Dynamic Array & Old Array Formulas to Create Student Classes Report - Excel Magic Trick 1608 7:48 2019-09-26
110 Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613 3:47 2019-10-22
111 Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620 9:32 2019-11-25
112 Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620 9:32 2019-11-25
113 Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622) 9:44 2019-11-30
114 Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625 3:46 2019-12-08
115 Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626) 18:34 2019-12-13
116 VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627 4:23 2019-12-19
117 Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621 15:43 2019-12-20
118 MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables 13:23 2019-12-22
119 Count NOT “Apple” with Excel Formula & Conditional Formatting - Excel Magic Trick 1630 2:37 2019-12-27
120 Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629. 10:46 2019-12-30
121 Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631. 9:00 2020-01-03
122 Dynamic Inventory Running Total Excel SUMIFS Formula Based on Transaction Records (EMT 1632) 4:03 2020-01-07
123 Excel Formula for Discounted Sales: Standard Formula or Spilled Arrays? Excel Magic Trick 1636 5:32 2020-01-14
124 TEXTJOIN & MID? LEFT, 2 MID, RIGHT? Excel Formulas to Insert Dashes into Text Excel Magic Trick 1637 3:32 2020-01-17
125 Power Query to Insert Dashes into Text. Flash Fill too! Excel Magic Trick 1638 3:44 2020-01-19
126 Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634 17:24 2020-01-23
127 Which Lookup Formula is Fastest? Excel Magic Trick 1631 Part 02 2:51 2020-01-29
128 REPLACE Function to Insert a Dash Into Text. Flash Fill Too. Excel Magic Trick 1639 2:36 2020-01-31
129 Flash Fill, Array Formula or Power Query? To Insert Dash Between Text & Number. EMT 1641 6:45 2020-02-03
130 excelisfun YouTube Birthday Party: 12 Years @ YouTube. Feb 15, 2008 – Feb 15, 2020. 1:11 2020-02-15
131 Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643 8:55 2020-02-28
132 Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644. 6:47 2020-03-07
133 OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645 6:35 2020-03-11
134 Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647 8:05 2020-03-17
135 Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648 5:28 2020-03-20
136 Create a Dynamic Lookup Table using INDEX & LOOKUP Functions. Excel Magic Trick 1649 4:26 2020-03-21
137 Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650. 5:03 2020-03-22
138 Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651 4:17 2020-03-23
139 Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652 5:42 2020-03-24
140 Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653 3:33 2020-03-25
141 INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654 4:31 2020-03-26
142 Excel Music Video: UNSTOPPABLE Office 365 Excel. Old School Formulas v. New School Formulas EMT 1655 3:09 2020-03-27
143 COUNTIFS 6 Criteria Counting Cross Tab Report. Change Cell Reference Every 3 Columns Too! EMT 1656 11:34 2020-03-29
144 PivotTables Are Easy: 6 Criteria Cross Tabulated Counting Report. Excel Magic Trick 1657. 5:35 2020-04-01
145 Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658. 9:56 2020-04-03
146 Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659 18:33 2020-04-10
147 Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662 0:57 2020-04-12
148 Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660. 22:22 2020-04-17
149 Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661 8:18 2020-04-23
150 Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663 6:49 2020-04-28
151 Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664 10:42 2020-05-01
152 Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665. 8:49 2020-05-05
153 Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667 8:26 2020-05-09
154 Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669. 6:08 2020-05-16
155 Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670 12:18 2020-06-01
156 SORTBY, UNIQUE, INDEX and SUMIFS Functions: Dynamic Spilled Array Reports. Excel Magic Trick 1671 7:28 2020-06-08
157 Lookup 2nd Smallest Number. 2nd Biggest too. UNIQUE or FREQUENCY function? Excel Magic Trick 1672 6:38 2020-06-15
158 LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673 7:01 2020-06-22
159 Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674 6:07 2020-06-29
160 Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675. 6:01 2020-07-01
161 Convert SAP Dates to Real Dates in Excel. Excel Magic Trick 1676 4:52 2020-07-06
162 Replace & Text To Columns to Convert Text Dates to Real Dates. Excel Magic Trick 1677 1:51 2020-07-09
163 Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678. 11:50 2020-07-11
164 Excel Table Column Formulas and Spilled Arrays? Excel Magic Trick 1679 3:38 2020-07-20
165 Excel Conditional Formatting Weekend & Holiday Date for Row in Table. Excel Magic Trick 1680. 6:02 2020-07-27
166 LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681. 14:32 2020-08-03
167 Append Two Number Columns and Sort. Excel Magic Trick 1682. 5:10 2020-08-10
168 Dueling Excel #191: Net Working Hours Spanning Midnight & Weekend with Mr Excel & Excelisfun 17:11 2020-08-14
169 Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683. 7:59 2020-08-17
170 SPLIT, JOIN and ARRAYFORMULA Functions in Google Sheets to Split Text & Add Numbers. GS 1. EMT 1684. 2:01 2020-08-24
171 FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685. 5:08 2020-08-25
172 Dynamic Excel Amortization Table. Microsoft 365 Spilled Array Magic! Excel Magic Trick 1686. 11:21 2020-08-31
173 List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687. 7:07 2020-09-07
174 List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688. 4:47 2020-09-09
175 Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689. 6:59 2020-09-11
176 Create Excel Database and Data Entry Form. Excel Magic Trick 1690. 8:08 2020-09-14
177 Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691. 9:56 2020-09-21
178 FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693. 13:30 2020-10-05
179 XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694. 5:20 2020-10-09
180 Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695. 9:38 2020-10-13
181 Excel FILTER based on list, not individual values? Easy! Excel Magic Trick 1696. 3:56 2020-10-18
182 OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697. 6:11 2020-10-25
183 How to Rank in Power Query. EMT 1698 by excelisfun. 3:44 2020-11-02
184 Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699. 18:53 2020-11-10
185 Biggest Sale for Each Product: PivotTable, Formulas or Power Query? Excel Magic Trick 1700. 5:59 2020-11-13
186 Basics of SUMIFS & PivotTables for Monthly Sales Report. Excel Magic Trick 1701. 9:20 2020-11-16
187 Basics of Excel Spilled Array Formulas to create Monthly Sales Report. Excel Magic Trick 1702. 15:02 2020-11-19
188 Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703. 24:50 2020-11-23
189 Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704. 1:51 2020-11-27
190 MOD function & Number.Mod Functions. Why They Give Different Answers. Excel Magic Trick 1705. 9:11 2020-12-01
191 LAMBDA Excel Function. LET & LAMBDA together to make Single Cell Reports. Excel Magic Trick 1706 5:26 2020-12-04
192 12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707 14:38 2020-12-09
193 Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708. 5:15 2020-12-14
194 Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709 6:56 2020-12-20
195 Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710 8:35 2020-12-22
196 Excel Magic Flashing Christmas Tree. Plus, BIG LET Surprise!!! Excel Magic Trick 1711 1:56 2020-12-25
197 INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712. 14:09 2021-01-05
198 Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713 9:24 2021-01-06
199 Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714. 13:09 2021-01-08
200 Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715 2:02 2021-01-11
201 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716 4:52 2021-01-13
202 Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717 6:57 2021-01-15
203 INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718 3:32 2021-01-18
204 Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719 7:19 2021-01-20
205 PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720 7:02 2021-01-25
206 Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721 5:04 2021-02-01
207 Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2 1:18 2021-02-04
208 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
209 Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723 4:12 2021-02-12
210 Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724 4:27 2021-02-15
211 Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725 15:43 2021-02-18
212 Moving Annual Total with DAX Measure. Excel Magic Trick 1726. 4:50 2021-02-23
213 Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727. 5:34 2021-03-01
214 Private video —
215 4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729. 7:08 2021-03-16
216 PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730 12:17 2021-03-23
217 Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731 6:10 2021-03-30
218 Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732 4:35 2021-04-02
219 Create PivotTable in Excel Online. Excel Magic Trick 1733. 3:00 2021-04-05
220 Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734. 4:38 2021-04-07
221 Organizational Data Types in Excel M365 & Power BI. Excel Magic Trick 1735 3:27 2021-04-09
222 Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data 5:30 2021-04-12
223 Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736. 6:21 2021-04-16
224 Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts 36:04 2021-04-19
225 Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More! 1:16:25 2021-04-26
226 Excel Data Analysis Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals 1:16:13 2021-05-03
227 Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas 58:02 2021-05-10
228 Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737. 9:45 2021-05-24
229 Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738. 11:44 2021-05-31
230 SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739 5:56 2021-06-08
231 Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740 11:18 2021-06-14
232 Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741 2:43 2021-06-22
233 Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742 11:38 2021-06-29
234 OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743 10:33 2021-07-06
235 Average Excluding Min and MAX Values. TRIMMEAN function. 6 Formula Examples. EMT 1744 6:16 2021-07-13
236 11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745 10:15 2021-07-20
237 IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746 9:05 2021-07-28
238 Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747 16:31 2021-08-03
239 Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748 6:59 2021-08-10
240 7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749 16:30 2021-08-17
241 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750 3:04 2021-08-24
242 Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751 4:43 2021-08-31
243 Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752 9:14 2021-09-07
244 Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753 1:58 2021-09-13
245 Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754 4:46 2021-09-17
246 Import OneDrive File or Folder using Power Query. EMT 1755 4:29 2021-09-20
247 Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756 2:29 2021-09-23
248 VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758 5:26 2021-10-05
249 Excel Hack Video: Power Query to fix files in Windows Explorer? Excel Magic Trick 1759 4:14 2021-10-07
250 VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760 4:33 2021-10-11
251 INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2. 2:09 2021-10-12
252 Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761 3:46 2021-10-18
253 Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762 8:19 2021-10-22
254 Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763 12:37 2021-10-27
255 Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764 10:14 2021-11-01
256 Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765 5:24 2021-11-22
257 Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766 11:09 2021-12-15
258 Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767 9:49 2021-12-20
259 Excel Flashing Christmas Tree 2021- Happy Holidays Old School Formula Method. EMT 1768 2:18 2021-12-25
260 SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769 5:34 2021-12-28
261 Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770 6:35 2022-01-01
262 FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771 7:13 2022-01-13
263 Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772 2:07 2022-01-14
264 Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773 2:48 2022-01-28
265 Sum Top 3 Values When There Is Missing Data – 3 Unbelievable Solutions (LAMBDA too) EMT 1775 6:21 2022-03-02
266 Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method - EMT 1776 6:05 2022-03-04
267 COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777 10:51 2022-03-07
268 Power Query: Extract Records For Invoices 1 to 30 Days Past Due - EMT 1778 3:49 2022-03-09
269 3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779 11:33 2022-03-16
270 HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780 5:34 2022-03-16
271 HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781 11:30 2022-03-18
272 14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782 18:35 2022-03-19
273 Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783 8:29 2022-03-22
274 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784 3:38 2022-03-23
275 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
276 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786 6:29 2022-03-25
277 Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787 18:07 2022-03-28
278 DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788 12:14 2022-03-31
279 TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789 3:26 2022-04-04
280 Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790 4:07 2022-04-16
281 XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791 6:59 2022-04-21
282 Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792 12:05 2022-05-31
283 Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793 8:39 2022-06-14
284 Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795 3:02 2022-08-07
285 Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796 7:50 2022-08-09
286 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
287 Create Sequence of Time Values in Excel for Stock Market Price Data – Excel Magic Trick 1798 7:18 2022-08-15
288 FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799 4:41 2022-10-10
289 Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800 3:52 2022-10-13
290 FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801 3:24 2022-10-27
291 Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802 3:28 2022-10-30
292 XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804 3:29 2022-11-05
293 Spilled 2-Way Lookup Commission Report using LAMBDA and BYROW Functions. EMT 1803 5:22 2022-11-02
294 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805 8:06 2022-11-29
295 Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806 4:06 2022-12-07
296 Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807 7:37 2022-12-09
297 Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808 4:39 2022-12-12
298 Excel Sparkling Christmas Tree with Changeable Ornaments with LAMBDA function! EMT 1809 1:19 2022-12-24
299 Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810 4:00 2023-01-05
300 Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 9:47 2023-01-07
301 Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shorts 2:45 2023-01-16
302 Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts 3:38 2023-01-19
303 Remove All Excel Format to Help Fix Reports and Data Errors. Excel Magic Trick 1814 #Shorts 1:55 2023-01-22
304 Save Time in Excel: Copy Only Excel Format with Format Painter. Excel Magic Trick 1815 #Shorts 1:25 2023-01-26
305 Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts 0:59 2023-01-26
306 excelisfun @ YouTube for 15 Years! Birthday Party! 0:45 2023-02-15
307 Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817 5:38 2023-02-21
308 Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_ 1:34 2023-02-22
309 Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818 6:04 2023-02-24
310 Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819 16:06 2023-02-26
311 Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13 1:49:33 2023-03-02
312 Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14 3:38 2023-03-08
313 7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15 22:02 2023-03-12
314 Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16 33:49 2023-03-21
315 Word Replace Feature for Special Characters: Replace All Hard Returns with 2 Hard Returns. #Short 0:36 2023-03-22
316 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820 3:53 2023-04-25
317 Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822 2:54 2023-06-29
318 Excel Formula To Randomly Lookup Pictures or Any Item. Excel Magic Trick 1823 2:53 2023-07-04
319 Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824 7:33 2023-07-06
320 Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825 5:59 2023-07-09
321 Formula to Calculate Hours Worked in Excel & DAX: Day or Night Shift! Excel Magic Trick 1826 6:55 2023-07-11
322 3 Power Query Formulas: Hours Worked for Day & Night Shift from Time Values. Excel Magic Trick 1827 8:54 2023-07-16
323 LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828 2:49 2023-07-20
324 LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2 3:03 2023-07-21
325 Federal Income Tax Calculation: LOOKUP Function Beats VLOOKUP & XLOOKUP! EMT 1828 Part 3 3:05 2023-07-23
326 LOOKUP Beats XLOOKUP For Single Cell Revenue Calculation. SUMPRODUCT Too! EMT 1829 3:34 2023-07-26
327 LOOKUP Beats XLOOKUP For Horizontal / Vertical Lookup. Excel Magic Trick 1830 2:09 2023-07-29
328 Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831 3:27 2023-08-01
329 Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832 3:35 2023-08-04
330 XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833 4:36 2023-08-07
331 Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834 9:03 2023-08-11
332 Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835 3:30 2023-08-22
333 FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837 6:10 2023-09-03
334 Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function? 4:17 2023-08-25
335 Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836 5:42 2023-08-27
336 Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838. 5:15 2023-09-10
337 Excel Formula: Extract City Name from Description. Excel Magic Trick 1839 4:02 2023-10-04
338 Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840 7:46 2023-10-11
339 FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841 8:29 2023-10-18
340 FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842 3:33 2023-10-25
341 FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843 2:23 2023-11-01
342 GROUPBY Excel Worksheet Function. Single Cell Reports Made Easy! 11 Examples. EMT 1844 28:33 2023-11-18
343 2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2 3:07 2023-11-18
344 Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845 19:34 2023-11-20
345 ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846 2:29 2023-11-19
346 Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847 4:30 2024-01-19
347 Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848 5:50 2024-01-29
348 Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849 5:41 2024-02-05
349 Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850 3:02 2024-01-23
350 Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851 2:58 2024-02-12
351 Append Tables in Excel. Excel Magic Trick 1852 1:08 2024-02-19
352 Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853 2:14 2024-02-22
353 Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854 3:23 2024-02-26
354 Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856 5:52 2024-03-04
355 Generate Random Data Sets with Dates & Sales Numbers: RANDARRAY Function. Excel Magic Trick 1857 3:09 2024-03-11
356 PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859 2:48 2024-03-25
357 Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858 3:10 2024-03-18
358 GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855 5:59 2024-02-29
359 Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860 3:38 2024-07-12
360 UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861 1:56 2024-07-15
361 1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862 3:26 2024-07-28
362 GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863 6:00 2024-08-04
363 Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864 2:52 2024-08-09
364 Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865 13:32 2024-08-14
365 Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866 11:30 2024-09-19
366 GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870 5:45 2025-02-24
367 BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871 6:54 2025-02-26
368 Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872 13:36 2025-03-03
369 FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874 3:24 2025-03-06
370 No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875 4:42 2025-03-07
371 Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876 2:33 2025-03-08
372 PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877 2:21 2025-03-09
373 Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68 2:30 2025-03-10
374 Increase All Numbers by a Multiple of 10: Excel Paste Special Multiply Magic!! Short Excel Trick 69 0:42 2025-03-11
375 Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70 2:23 2025-03-12
376 Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71 0:46 2025-03-13
377 Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878 2:35 2025-03-14
378 PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879 1:22 2025-03-15
379 GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks? 2:11 2025-03-27
380 MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples! 51:23 2025-03-30
381 MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples. 1:28:49 2025-04-07
382 Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882 4:21 2025-04-14
383 GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883 2:46 2025-04-16
384 The Beauty Of Power Query! One Quick Example : ) 1:59 2025-04-21
385 File Explorer Skills To Be Good In Excel? 100% Yes! File Extensions & F2 Trick! EMT 1885 1:23 2025-04-25
386 Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886 3:00 2025-04-26
387 INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888 3:42 2025-05-01
388 Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889 3:56 2025-05-04
389 Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890 3:08 2025-05-02
390 COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891 6:09 2025-05-03
391 Excel Formula to UnPivot!? with Magic From the Functions: TOCOL, IFS, CHOOSEROWS & More! EMT 1887 17:12 2025-05-07
392 Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887 17:44 2025-05-08
393 Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892 2:51 2025-06-08
394 XLOOKUP, LEFT, TEXTBEFORE, & LOOKUP Functions & Math Tricks to Calculate Discounted Sales! EMT 1893 6:26 2025-06-11
395 Create Random Dates with Excel Functions. Excel Magic Trick 1894 3:22 2025-06-17
396 Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895. 1:51 2025-06-18
397 Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896 2:13 2025-06-19
398 Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897 4:40 2025-06-20
399 Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898 8:20 2025-06-22
400 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
401 PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900 13:29 2025-07-27
402 COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901 24:46 2025-08-15
403 Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902 24:47 2025-08-21
404 Excel TEXTSPLIT function to Split Values By Delimiter & More! Excel Magic Trick 1904 5:11 2025-09-09
405 Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905 2:34 2025-09-10
406 Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906 5:35 2025-09-11
407 Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907 3:40 2025-09-12
408 The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908 7:43 2025-09-16
409 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909 4:25 2025-09-29
410 Magic Data Validation List using Dynamic Range Reference or Spilled Range Operator!! EMT 1910 7:25 2025-10-01
411 Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911 8:45 2025-10-03
412 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
413 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13
414 PivotTable New Features (Spill Error & Auto Refresh) and PivotTable Basics Revealed. EMT 1914 7:54 2025-11-07
415 2 Excel Formulas to Add Sequential Numbers Each Time a New Row Is Added To a Table. EMT 1915 5:09 2025-11-11
416 Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916 10:10 2025-11-17
417 Part 2: Power Query Unpivot Cross Tab Table with 2 Column Variables. An Easier Way! EMT 1916 Part 02 9:41 2025-11-18
418 Build Power Query Custom Function: Convert Multiple Csv Cross Tab Tables into Single Table EMT 1917. 18:18 2025-11-23
419 Power Query Nested Functions in Custom Column: Convert Multiple Csv Files into One Table. EMT 1918 15:21 2025-12-02
420 Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919 13:18 2025-12-09
421 excelisfun Flashback Friday 6: Sparkling Christmas Tree in Excel! Build Conditional Formatting Tree 2:44 2025-12-20
422 Complete Lesson in Excel Text Formulas that use References to Dates, Money & Arrays. EMT 1920. 7:47 2025-12-23
423 Excel Formula for Accounting Bank Reconciliation with IF, ISNUMBER & SUM Functions. EMT 1921. 11:12 2026-01-07
424 Excel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation. EMT 1922. 10:54 2026-02-03
425 Last Video From Mike "excelisfun" Girvin on Feb 16, 2026, 18 years at YouTube!!! Go Team!!! 0:55 2026-02-16
426 Sort "City, State" Text by State Then City | SORTBY Array Function - EMT 1923 3:58 2026-08-06
427 Excel Sort Left To Right. Horizontal Sort. Excel Short 83 0:53 2026-08-05
428 Conditionally Format Row in Schedule for Today’s Date - Mixed Cell References | EMT 1924 5:59 2026-08-09
429 Formulas or Power Query or Regex: Why Do I Get Zero When I SUM? Excel Magic Trick 1923 13:45 2026-09-17

Embed a badge

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

Watch time: 3d 17h 55m · 428 videos

Markdown
[![Watch time: 3d 17h 55m · 428 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0ndqetqYG0ocKrr-3FvouJ-.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0ndqetqYG0ocKrr-3FvouJ-)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0ndqetqYG0ocKrr-3FvouJ-"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0ndqetqYG0ocKrr-3FvouJ-.svg" alt="Watch time: 3d 17h 55m · 428 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/PLrRPvpgDmw0ndqetqYG0ocKrr-3FvouJ- returns them as JSON — free, no key. API docs →

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