playlistduration

Excel Magic Tricks, #1191 and after : )

by excelisfun · 752 videos (1 unavailable)

Total watch time

4d 13h 32m

at 1× speed · exactly 4 days, 13 hours, 31 minutes, 48 seconds at 1×

1×4d 13h 31m 48s
1.25×3d 15h 37m 26s
1.5×3d 1h 1m 12s
1.75×2d 14h 35m 19s
2×2d 6h 45m 54s
Average video8m 44s
Longest1h 12m 7s
Shortest33s
Compare Open on YouTube JSON

Plan to finish

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

Videos (753)

4d 13h 32m in total · tick what you've watched

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

Videos to
Watched
1 Formulas or Power Query or Regex: Why Do I Get Zero When I SUM? Excel Magic Trick 1923 13:45 2026-09-17
2 Conditionally Format Row in Schedule for Today’s Date - Mixed Cell References | EMT 1924 5:59 2026-08-09
3 Sort "City, State" Text by State Then City | SORTBY Array Function - EMT 1923 3:58 2026-08-06
4 Last Video From Mike "excelisfun" Girvin on Feb 16, 2026, 18 years at YouTube!!! Go Team!!! 0:55 2026-02-16
5 Excel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation. EMT 1922. 10:54 2026-02-03
6 Excel Formula for Accounting Bank Reconciliation with IF, ISNUMBER & SUM Functions. EMT 1921. 11:12 2026-01-07
7 Complete Lesson in Excel Text Formulas that use References to Dates, Money & Arrays. EMT 1920. 7:47 2025-12-23
8 excelisfun Flashback Friday 6: Sparkling Christmas Tree in Excel! Build Conditional Formatting Tree 2:44 2025-12-20
9 Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919 13:18 2025-12-09
10 Power Query Nested Functions in Custom Column: Convert Multiple Csv Files into One Table. EMT 1918 15:21 2025-12-02
11 Build Power Query Custom Function: Convert Multiple Csv Cross Tab Tables into Single Table EMT 1917. 18:18 2025-11-23
12 Part 2: Power Query Unpivot Cross Tab Table with 2 Column Variables. An Easier Way! EMT 1916 Part 02 9:41 2025-11-18
13 Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916 10:10 2025-11-17
14 2 Excel Formulas to Add Sequential Numbers Each Time a New Row Is Added To a Table. EMT 1915 5:09 2025-11-11
15 PivotTable New Features (Spill Error & Auto Refresh) and PivotTable Basics Revealed. EMT 1914 7:54 2025-11-07
16 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13
17 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
18 Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911 8:45 2025-10-03
19 Magic Data Validation List using Dynamic Range Reference or Spilled Range Operator!! EMT 1910 7:25 2025-10-01
20 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909 4:25 2025-09-29
21 The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908 7:43 2025-09-16
22 Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907 3:40 2025-09-12
23 Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906 5:35 2025-09-11
24 Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905 2:34 2025-09-10
25 Excel TEXTSPLIT function to Split Values By Delimiter & More! Excel Magic Trick 1904 5:11 2025-09-09
26 Turn Off Excel Copilot Pop-up Button in Worksheet. Excel Magic Trick 1903 1:25 2025-09-04
27 Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902 24:47 2025-08-21
28 COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901 24:46 2025-08-15
29 PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900 13:29 2025-07-27
30 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
31 Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898 8:20 2025-06-22
32 Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897 4:40 2025-06-20
33 Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896 2:13 2025-06-19
34 Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895. 1:51 2025-06-18
35 Create Random Dates with Excel Functions. Excel Magic Trick 1894 3:22 2025-06-17
36 XLOOKUP, LEFT, TEXTBEFORE, & LOOKUP Functions & Math Tricks to Calculate Discounted Sales! EMT 1893 6:26 2025-06-11
37 Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892 2:51 2025-06-08
38 Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887 17:44 2025-05-08
39 Excel Formula to UnPivot!? with Magic From the Functions: TOCOL, IFS, CHOOSEROWS & More! EMT 1887 17:12 2025-05-07
40 COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891 6:09 2025-05-03
41 Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890 3:08 2025-05-02
42 Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889 3:56 2025-05-04
43 INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888 3:42 2025-05-01
44 Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886 3:00 2025-04-26
45 File Explorer Skills To Be Good In Excel? 100% Yes! File Extensions & F2 Trick! EMT 1885 1:23 2025-04-25
46 The Beauty Of Power Query! One Quick Example : ) 1:59 2025-04-21
47 GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883 2:46 2025-04-16
48 Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882 4:21 2025-04-14
49 PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879 1:22 2025-03-15
50 Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878 2:35 2025-03-14
51 PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877 2:21 2025-03-09
52 Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876 2:33 2025-03-08
53 FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874 3:24 2025-03-06
54 No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875 4:42 2025-03-07
55 Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872 13:36 2025-03-03
56 Add Secondary Series of Numbers To Excel Chart & Add Second X-Axis Labels to Chart: EMT 1873 3:01 2025-02-25
57 BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871 6:54 2025-02-26
58 GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870 5:45 2025-02-24
59 Dynamic PivotTable To Count SalesRep Monthly Sales & Visualize Trend. Excel Magic Trick 1869 7:49 2025-02-15
60 Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868 17:11 2025-01-04
61 2024 Christmas Tree with Excel Formula 1:29 2024-12-24
62 Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866 11:30 2024-09-19
63 Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865 13:32 2024-08-14
64 Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864 2:52 2024-08-09
65 GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863 6:00 2024-08-04
66 1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862 3:26 2024-07-28
67 UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861 1:56 2024-07-15
68 Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860 3:38 2024-07-12
69 GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855 5:59 2024-02-29
70 Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858 3:10 2024-03-18
71 PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859 2:48 2024-03-25
72 Generate Random Data Sets with Dates & Sales Numbers: RANDARRAY Function. Excel Magic Trick 1857 3:09 2024-03-11
73 Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856 5:52 2024-03-04
74 Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854 3:23 2024-02-26
75 Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853 2:14 2024-02-22
76 Append Tables in Excel. Excel Magic Trick 1852 1:08 2024-02-19
77 Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851 2:58 2024-02-12
78 Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850 3:02 2024-01-23
79 Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849 5:41 2024-02-05
80 Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848 5:50 2024-01-29
81 Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847 4:30 2024-01-19
82 ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846 2:29 2023-11-19
83 Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845 19:34 2023-11-20
84 2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2 3:07 2023-11-18
85 GROUPBY Excel Worksheet Function. Single Cell Reports Made Easy! 11 Examples. EMT 1844 28:33 2023-11-18
86 FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843 2:23 2023-11-01
87 FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842 3:33 2023-10-25
88 FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841 8:29 2023-10-18
89 Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840 7:46 2023-10-11
90 Excel Formula: Extract City Name from Description. Excel Magic Trick 1839 4:02 2023-10-04
91 Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838. 5:15 2023-09-10
92 Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836 5:42 2023-08-27
93 Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function? 4:17 2023-08-25
94 FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837 6:10 2023-09-03
95 Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835 3:30 2023-08-22
96 Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834 9:03 2023-08-11
97 XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833 4:36 2023-08-07
98 Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832 3:35 2023-08-04
99 Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831 3:27 2023-08-01
100 LOOKUP Beats XLOOKUP For Horizontal / Vertical Lookup. Excel Magic Trick 1830 2:09 2023-07-29
101 LOOKUP Beats XLOOKUP For Single Cell Revenue Calculation. SUMPRODUCT Too! EMT 1829 3:34 2023-07-26
102 Federal Income Tax Calculation: LOOKUP Function Beats VLOOKUP & XLOOKUP! EMT 1828 Part 3 3:05 2023-07-23
103 LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2 3:03 2023-07-21
104 LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828 2:49 2023-07-20
105 3 Power Query Formulas: Hours Worked for Day & Night Shift from Time Values. Excel Magic Trick 1827 8:54 2023-07-16
106 Formula to Calculate Hours Worked in Excel & DAX: Day or Night Shift! Excel Magic Trick 1826 6:55 2023-07-11
107 Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825 5:59 2023-07-09
108 Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824 7:33 2023-07-06
109 Excel Formula To Randomly Lookup Pictures or Any Item. Excel Magic Trick 1823 2:53 2023-07-04
110 Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822 2:54 2023-06-29
111 Conditional Format Row When Employee Is Listed More Than 1 Time For Date. Excel Magic Trick 1821. 3:09 2023-06-14
112 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820 3:53 2023-04-25
113 Word Replace Feature for Special Characters: Replace All Hard Returns with 2 Hard Returns. #Short 0:36 2023-03-22
114 Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819 16:06 2023-02-26
115 Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818 6:04 2023-02-24
116 Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_ 1:34 2023-02-22
117 Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817 5:38 2023-02-21
118 excelisfun @ YouTube for 15 Years! Birthday Party! 0:45 2023-02-15
119 Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts 0:59 2023-01-26
120 Save Time in Excel: Copy Only Excel Format with Format Painter. Excel Magic Trick 1815 #Shorts 1:25 2023-01-26
121 Remove All Excel Format to Help Fix Reports and Data Errors. Excel Magic Trick 1814 #Shorts 1:55 2023-01-22
122 Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts 3:38 2023-01-19
123 Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shorts 2:45 2023-01-16
124 Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 9:47 2023-01-07
125 Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810 4:00 2023-01-05
126 Excel Sparkling Christmas Tree with Changeable Ornaments with LAMBDA function! EMT 1809 1:19 2022-12-24
127 Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808 4:39 2022-12-12
128 Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807 7:37 2022-12-09
129 Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806 4:06 2022-12-07
130 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805 8:06 2022-11-29
131 Spilled 2-Way Lookup Commission Report using LAMBDA and BYROW Functions. EMT 1803 5:22 2022-11-02
132 XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804 3:29 2022-11-05
133 Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802 3:28 2022-10-30
134 FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801 3:24 2022-10-27
135 Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800 3:52 2022-10-13
136 FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799 4:41 2022-10-10
137 Create Sequence of Time Values in Excel for Stock Market Price Data – Excel Magic Trick 1798 7:18 2022-08-15
138 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
139 Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796 7:50 2022-08-09
140 Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795 3:02 2022-08-07
141 excelisfun’s new book The Only App That Matters Book is Released!!! Microsoft 365 Excel = The Best! 1:10 2022-08-02
142 Excel Formula to Lookup Cell Address Of Max Value: 12 Amazing Examples. Excel Magic Trick 1794 9:55 2022-07-05
143 Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793 8:39 2022-06-14
144 Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792 12:05 2022-05-31
145 XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791 6:59 2022-04-21
146 Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790 4:07 2022-04-16
147 TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789 3:26 2022-04-04
148 DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788 12:14 2022-03-31
149 Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787 18:07 2022-03-28
150 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786 6:29 2022-03-25
151 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
152 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784 3:38 2022-03-23
153 Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783 8:29 2022-03-22
154 14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782 18:35 2022-03-19
155 HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781 11:30 2022-03-18
156 HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780 5:34 2022-03-16
157 3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779 11:33 2022-03-16
158 Power Query: Extract Records For Invoices 1 to 30 Days Past Due - EMT 1778 3:49 2022-03-09
159 COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777 10:51 2022-03-07
160 Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method - EMT 1776 6:05 2022-03-04
161 Sum Top 3 Values When There Is Missing Data – 3 Unbelievable Solutions (LAMBDA too) EMT 1775 6:21 2022-03-02
162 Turn Off GETPIVOTDATA Function - EMT 1774 1:35 2022-02-25
163 Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773 2:48 2022-01-28
164 Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772 2:07 2022-01-14
165 FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771 7:13 2022-01-13
166 Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770 6:35 2022-01-01
167 SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769 5:34 2021-12-28
168 Excel Flashing Christmas Tree 2021- Happy Holidays Old School Formula Method. EMT 1768 2:18 2021-12-25
169 Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767 9:49 2021-12-20
170 Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766 11:09 2021-12-15
171 Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765 5:24 2021-11-22
172 Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764 10:14 2021-11-01
173 Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763 12:37 2021-10-27
174 Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762 8:19 2021-10-22
175 Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761 3:46 2021-10-18
176 INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2. 2:09 2021-10-12
177 VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760 4:33 2021-10-11
178 Excel Hack Video: Power Query to fix files in Windows Explorer? Excel Magic Trick 1759 4:14 2021-10-07
179 VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758 5:26 2021-10-05
180 Power Query From Sheet option Import Tables, Defined Names or Dynamic Arrays. Fast Keyboard EMT 1757 1:53 2021-09-27
181 Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756 2:29 2021-09-23
182 Import OneDrive File or Folder using Power Query. EMT 1755 4:29 2021-09-20
183 Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754 4:46 2021-09-17
184 Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753 1:58 2021-09-13
185 Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752 9:14 2021-09-07
186 Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751 4:43 2021-08-31
187 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750 3:04 2021-08-24
188 7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749 16:30 2021-08-17
189 Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748 6:59 2021-08-10
190 Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747 16:31 2021-08-03
191 IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746 9:05 2021-07-28
192 Excel Magic Trick 1745 Part 2: Create & Spill Random Normally Distributed Values 1:02 2021-07-26
193 11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745 10:15 2021-07-20
194 Average Excluding Min and MAX Values. TRIMMEAN function. 6 Formula Examples. EMT 1744 6:16 2021-07-13
195 OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743 10:33 2021-07-06
196 Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742 11:38 2021-06-29
197 Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741 2:43 2021-06-22
198 Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740 11:18 2021-06-14
199 SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739 5:56 2021-06-08
200 Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738. 11:44 2021-05-31
201 Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737. 9:45 2021-05-24
202 Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736. 6:21 2021-04-16
203 Organizational Data Types in Excel M365 & Power BI. Excel Magic Trick 1735 3:27 2021-04-09
204 Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734. 4:38 2021-04-07
205 Create PivotTable in Excel Online. Excel Magic Trick 1733. 3:00 2021-04-05
206 Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732 4:35 2021-04-02
207 Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731 6:10 2021-03-30
208 PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730 12:17 2021-03-23
209 4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729. 7:08 2021-03-16
210 Private video —
211 Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727. 5:34 2021-03-01
212 Moving Annual Total with DAX Measure. Excel Magic Trick 1726. 4:50 2021-02-23
213 Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725 15:43 2021-02-18
214 Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724 4:27 2021-02-15
215 Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723 4:12 2021-02-12
216 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
217 Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2 1:18 2021-02-04
218 Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721 5:04 2021-02-01
219 PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720 7:02 2021-01-25
220 Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719 7:19 2021-01-20
221 INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718 3:32 2021-01-18
222 Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717 6:57 2021-01-15
223 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716 4:52 2021-01-13
224 Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715 2:02 2021-01-11
225 Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714. 13:09 2021-01-08
226 Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713 9:24 2021-01-06
227 INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712. 14:09 2021-01-05
228 Excel Magic Flashing Christmas Tree. Plus, BIG LET Surprise!!! Excel Magic Trick 1711 1:56 2020-12-25
229 Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710 8:35 2020-12-22
230 Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709 6:56 2020-12-20
231 Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708. 5:15 2020-12-14
232 12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707 14:38 2020-12-09
233 LAMBDA Excel Function. LET & LAMBDA together to make Single Cell Reports. Excel Magic Trick 1706 5:26 2020-12-04
234 MOD function & Number.Mod Functions. Why They Give Different Answers. Excel Magic Trick 1705. 9:11 2020-12-01
235 Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704. 1:51 2020-11-27
236 Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703. 24:50 2020-11-23
237 Basics of Excel Spilled Array Formulas to create Monthly Sales Report. Excel Magic Trick 1702. 15:02 2020-11-19
238 Basics of SUMIFS & PivotTables for Monthly Sales Report. Excel Magic Trick 1701. 9:20 2020-11-16
239 Biggest Sale for Each Product: PivotTable, Formulas or Power Query? Excel Magic Trick 1700. 5:59 2020-11-13
240 Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699. 18:53 2020-11-10
241 How to Rank in Power Query. EMT 1698 by excelisfun. 3:44 2020-11-02
242 OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697. 6:11 2020-10-25
243 Excel FILTER based on list, not individual values? Easy! Excel Magic Trick 1696. 3:56 2020-10-18
244 Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695. 9:38 2020-10-13
245 XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694. 5:20 2020-10-09
246 FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693. 13:30 2020-10-05
247 Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691. 9:56 2020-09-21
248 Create Excel Database and Data Entry Form. Excel Magic Trick 1690. 8:08 2020-09-14
249 Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689. 6:59 2020-09-11
250 List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688. 4:47 2020-09-09
251 List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687. 7:07 2020-09-07
252 Dynamic Excel Amortization Table. Microsoft 365 Spilled Array Magic! Excel Magic Trick 1686. 11:21 2020-08-31
253 FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685. 5:08 2020-08-25
254 SPLIT, JOIN and ARRAYFORMULA Functions in Google Sheets to Split Text & Add Numbers. GS 1. EMT 1684. 2:01 2020-08-24
255 Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683. 7:59 2020-08-17
256 Append Two Number Columns and Sort. Excel Magic Trick 1682. 5:10 2020-08-10
257 LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681. 14:32 2020-08-03
258 Excel Conditional Formatting Weekend & Holiday Date for Row in Table. Excel Magic Trick 1680. 6:02 2020-07-27
259 Excel Table Column Formulas and Spilled Arrays? Excel Magic Trick 1679 3:38 2020-07-20
260 Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678. 11:50 2020-07-11
261 Replace & Text To Columns to Convert Text Dates to Real Dates. Excel Magic Trick 1677 1:51 2020-07-09
262 Convert SAP Dates to Real Dates in Excel. Excel Magic Trick 1676 4:52 2020-07-06
263 Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675. 6:01 2020-07-01
264 Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674 6:07 2020-06-29
265 LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673 7:01 2020-06-22
266 Lookup 2nd Smallest Number. 2nd Biggest too. UNIQUE or FREQUENCY function? Excel Magic Trick 1672 6:38 2020-06-15
267 SORTBY, UNIQUE, INDEX and SUMIFS Functions: Dynamic Spilled Array Reports. Excel Magic Trick 1671 7:28 2020-06-08
268 Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670 12:18 2020-06-01
269 Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669. 6:08 2020-05-16
270 Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667 8:26 2020-05-09
271 Show File Extensions (File Types). EMT 1666 1:11 2020-05-07
272 Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665. 8:49 2020-05-05
273 Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664 10:42 2020-05-01
274 Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663 6:49 2020-04-28
275 Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661 8:18 2020-04-23
276 Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660. 22:22 2020-04-17
277 Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662 0:57 2020-04-12
278 Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659 18:33 2020-04-10
279 Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658. 9:56 2020-04-03
280 PivotTables Are Easy: 6 Criteria Cross Tabulated Counting Report. Excel Magic Trick 1657. 5:35 2020-04-01
281 COUNTIFS 6 Criteria Counting Cross Tab Report. Change Cell Reference Every 3 Columns Too! EMT 1656 11:34 2020-03-29
282 Excel Music Video: UNSTOPPABLE Office 365 Excel. Old School Formulas v. New School Formulas EMT 1655 3:09 2020-03-27
283 INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654 4:31 2020-03-26
284 Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653 3:33 2020-03-25
285 Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652 5:42 2020-03-24
286 Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651 4:17 2020-03-23
287 Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650. 5:03 2020-03-22
288 Create a Dynamic Lookup Table using INDEX & LOOKUP Functions. Excel Magic Trick 1649 4:26 2020-03-21
289 Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648 5:28 2020-03-20
290 Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647 8:05 2020-03-17
291 Append Multiple Columns with Excel Dynamic Spilled Array Formula. Excel Magic Trick 1646. 8:28 2020-03-13
292 OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645 6:35 2020-03-11
293 Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644. 6:47 2020-03-07
294 Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643 8:55 2020-02-28
295 Excel FIXED Function Easier than TEXT Function! (DOLLAR Function too). Excel Magic Trick 1635 2:54 2020-01-11
296 excelisfun YouTube Birthday Party: 12 Years @ YouTube. Feb 15, 2008 – Feb 15, 2020. 1:11 2020-02-15
297 Flash Fill, Array Formula or Power Query? To Insert Dash Between Text & Number. EMT 1641 6:45 2020-02-03
298 REPLACE Function to Insert a Dash Into Text. Flash Fill Too. Excel Magic Trick 1639 2:36 2020-01-31
299 Which Lookup Formula is Fastest? Excel Magic Trick 1631 Part 02 2:51 2020-01-29
300 Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634 17:24 2020-01-23
301 Power Query to Insert Dashes into Text. Flash Fill too! Excel Magic Trick 1638 3:44 2020-01-19
302 TEXTJOIN & MID? LEFT, 2 MID, RIGHT? Excel Formulas to Insert Dashes into Text Excel Magic Trick 1637 3:32 2020-01-17
303 Excel Formula for Discounted Sales: Standard Formula or Spilled Arrays? Excel Magic Trick 1636 5:32 2020-01-14
304 Repeat Number Down Column with Excel Formula & Conditional Formatting - Excel Magic Trick 1633 5:14 2020-01-10
305 Dynamic Inventory Running Total Excel SUMIFS Formula Based on Transaction Records (EMT 1632) 4:03 2020-01-07
306 Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631. 9:00 2020-01-03
307 Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629. 10:46 2019-12-30
308 Spilled Array Christmas Tree in Excel. Conditional Formatting Christmas Tree. Excel Magic Trick 1628 1:18 2019-12-24
309 Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621 15:43 2019-12-20
310 VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627 4:23 2019-12-19
311 Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626) 18:34 2019-12-13
312 Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625 3:46 2019-12-08
313 Double The Records When I Refresh? Power Query Excel.CurrentWorkbook Recursion - EMT 1624 2:03 2019-12-06
314 Repeat Columns in my Power Query Append?? Too Many Columns? Extra Columns? EMT 1623 8:04 2019-12-05
315 Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622) 9:44 2019-11-30
316 Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620 9:32 2019-11-25
317 How To Import Text File into Excel (4 Examples, including Tab & CSV Files) – Excel Magic Trick 1619 3:23 2019-11-22
318 INDEX & MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes (EMT 1618) 12:25 2019-11-15
319 Split Text By Capital Letters in Excel using Power Query EMT 1617 7:58 2019-11-09
320 Split Text By Capital Letters in Excel using Power Query EMT 1617 7:58 2019-11-09
321 Bring Excel Sheet Variable Into a DAX Measure (Measure Input From Excel Sheet) EMT 1616 5:53 2019-11-03
322 Bring Excel Sheet Variable Into Power Query (Query Input from Excel Sheet) - EMT 1615 4:58 2019-11-01
323 TEXTJOIN & TEXT Functions working on Multiple Rows or Columns (DOLLAR Function too) EMT 1614 4:41 2019-10-29
324 Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613 3:47 2019-10-22
325 Excel Formula for Text Number Label with Lead Zeroes: 010-030, 030-050, 050-070 - EMT 1612 5:24 2019-10-19
326 XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611 1:50 2019-10-11
327 Extract Top 5 Values with Names with Dynamic Array Formulas & Conditional Formatting – EMT 1610 4:47 2019-10-08
328 Excel Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609 6:08 2019-09-29
329 Dynamic Array & Old Array Formulas to Create Student Classes Report - Excel Magic Trick 1608 7:48 2019-09-26
330 DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607 4:22 2019-09-24
331 List Student Classes in Single Cell – Power Query (From Text File & Parameter Query)- EMT 1606 10:59 2019-09-22
332 Sum Last Digits for All Numbers - Excel Magic Trick 1605 3:27 2019-09-20
333 Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604 3:29 2019-09-19
334 Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603 3:13 2019-09-18
335 3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602 3:56 2019-09-14
336 Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601 4:14 2019-09-14
337 Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600 25:02 2019-09-06
338 Advanced Filter: Filter Rows with List of Does NOT Contain Criteria - Excel Magic Trick 1594 4:01 2019-08-25
339 Extract Customer Names, Not in Master Lists with Advanced Filter - Excel Magic Trick 1598 5:06 2019-09-02
340 Excel Formula to Compare Two Lists - Excel Magic Trick 1596. Is Item in List? 4:33 2019-08-28
341 Array Formula: Filter Rows with List of Does NOT Contain Criteria - Excel Magic Trick 1595 5:52 2019-08-27
342 Power Query Filter Rows by NOT Contains Criteria - Single Formula Solution - Excel Magic Trick 1593 8:05 2019-08-23
343 One Lookup Value, Return Multiple Items – The Easy Way with FILTER - Excel Magic Trick 1591 1:44 2019-08-19
344 Power Query - Filter Table Based on Distinct NOT Conditions from List - Excel Magic Trick 1592 9:18 2019-08-21
345 Two Lookup Values for Excel Lookup? FILTER or INDEX? - Excel Magic Trick 1590 2:07 2019-08-17
346 Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589 4:39 2019-08-14
347 Power Query Running Count Based on Row Condition – Excel Magic Trick 1588 7:25 2019-08-13
348 Count Number of Saturdays in Month - 5 Different Formulas!- Excel Magic Trick 1587 8:51 2019-08-11
349 Dynamic Arrays to Increment 1-6, 7-12, 13-18 - SEQUENCE Array Function… - Excel Magic Trick 1586 2:30 2019-08-09
350 Excel Formula to Increment Numbers: 1-6, 7-12, 13-18 for Raffle Ticket - Excel Magic Trick 1585 4:23 2019-08-08
351 Extract Date from End of Description with Excel Worksheet Formula - Excel Magic Trick 1583 1:48 2019-08-04
352 Extract Data From Cell with Flash Fill - Excel Magic Trick 1582 1:29 2019-08-01
353 Excel Formula to Reverse First & Last Name. Better Than Power Query & Flash Fill? - EMT 1581 3:21 2019-07-31
354 Power Query - Group Suppliers, Join with Line Feed From Multiple Text Files - Excel Magic Trick 1580 9:30 2019-07-30
355 Array Formula - List All Suppliers by Material in Single Cell with Line Feed, Excel Magic Trick 1579 5:52 2019-07-29
356 Excel PivotTable Keyboard? Keyboard for PivotTable –Excel Magic Trick 1578 0:38 2019-07-29
357 Summarize Survey Results with PivotTable in One Minute - Excel Magic Trick 1577 1:01 2019-07-28
358 Power Query M Code Group By Formula to Transform Invoice Table - Excel Magic Trick 1576 7:25 2019-07-26
359 Unique Invoice / Vendor List with Items Listed Horizontally - Excel Dynamic Array Formula- EMT 1575 4:11 2019-07-25
360 OFFSET Function Dynamic Range inside COUNTIFS Function - Excel Magic Trick 1573 4:40 2019-07-24
361 INDEX Function To Lookup Column inside COUNTIFS Function - Excel Magic Trick 1574 2:52 2019-07-24
362 Excel Conditional Format Row, Column & Intersecting Cell - Excel Magic Trick 1572 4:39 2019-07-22
363 Excel’s # 1 Silliest Formula: INDEX or INDIRECT? Excel Magic Trick 1571 (Two Way Lookup Trick) 4:41 2019-07-21
364 Excel Intersection Operator, An Excel Party Trick? - Excel Magic Trick 1570 1:10 2019-07-19
365 Excel Union Operator For Aggregate, Statistical & Finance Functions - Excel Magic Trick 1569 2:40 2019-07-19
366 Excel Two Way Lookup with INDEX & MATCH Functions - Excel Magic Trick 1568 2:32 2019-07-18
367 Excel Two Way Lookup with VLOOKUP & MATCH Functions - Excel Magic Trick 1567 2:40 2019-07-18
368 Excel Keyboard Shortcut to Jump To Formula Bar. Excel Magic Trick 1566. 1:41 2019-07-17
369 Excel Keyboard Shortcut to Jump To Formula Bar. Excel Magic Trick 1566. 1:41 2019-07-17
370 Excel Keyboard to Insert Sheet & Rename Sheet. Excel Magic Trick 1565. (Sheet Tab or Worksheet) 0:33 2019-07-17
371 4 Types of Criteria for SUMIFS & COUNTIFS - Excel Magic Trick 1564, SUMIF & COUNTIF too 6:50 2019-07-16
372 Last Working Day Of Month – Excel Formula – Excel Magic Trick 1563 2:51 2019-07-15
373 Jump To Any Excel Sheet – 7 Methods in One Minute – Excel Magic Trick 1562 1:08 2019-07-10
374 DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561) 11:06 2019-07-09
375 Excel Magic Trick 1560: Half Year Running Totals in PivotTable 5:32 2019-07-08
376 Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales 4:20 2019-07-07
377 Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change 3:27 2019-07-05
378 Keyboard Shortcut to Open Smart Tags in Excel, Word & PowerPoint (Excel Magic Trick 1557) 1:10 2019-07-03
379 Create Column of Month End Dates in Excel - Excel Magic Trick 1556 0:54 2019-07-02
380 Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555 3:32 2019-07-01
381 Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553 31:16 2019-06-07
382 Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND 7:46 2019-05-19
383 COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550 3:11 2019-04-22
384 COUNTIFS in Power Query? Excel Magic Trick 1549 2:12 2019-04-19
385 Excel Table NOT Automatically Add New Column or Rows? Option Setting to Fix This. Magic Trick 1547 1:10 2019-04-15
386 Power Query Get Previous Row? Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546 12:44 2019-04-10
387 Create Random Data, Variable Height INDEX & RANDARRAY Dynamic Array Function: Excel Magic Trick 1545 6:46 2019-04-08
388 Excel Magic Trick 1544: FILTER Array Function to Filter Between Upper & Lower Text Number Limits 6:20 2019-04-06
389 Excel Magic Trick 1543: MAXIFS & MINIFS to Lookup Numbers on Either Side of Hurdle 3:20 2019-02-16
390 Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?! 7:09 2019-02-15
391 Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS 7:09 2019-02-14
392 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column 6:00 2019-02-13
393 Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array). 5:46 2019-02-12
394 Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue 4:39 2019-01-18
395 EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts 10:50 2019-01-15
396 EMT 1535: Average Daily Revenue: SUMIFS with INDIRECT? or SEQUENCE? Inside AVERAGE 8:08 2019-01-13
397 VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function? 7:56 2019-01-06
398 Count Products Report: Excel? DAX? Power Query? Office 365? Excel Magic Trick 1533 15:38 2018-12-23
399 VLOOKUP To Get Complete Record: ROWS, COLUMNS or SEQUENCE Function? EMT 1532 8:30 2018-12-15
400 Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531) 6:46 2018-11-11
401 Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530) 12:31 2018-11-09
402 Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529) 17:03 2018-11-07
403 Excel Dynamic Arrays & Charts: Spilled Arrays in Charts with Defined Names (Excel Magic Trick 1527) 5:12 2018-11-06
404 Excel Dynamic Arrays: Cross Tabulated Report, Totals Top & Left MMULT Array Function (EMT 1526) 7:29 2018-11-05
405 Excel Dynamic Arrays & Conditional Formatting for Spilled Arrays (Excel Magic Trick 1525) 5:14 2018-11-04
406 Excel Dynamic Arrays & Conditional Formatting for Spilled Arrays (Excel Magic Trick 1525) 5:14 2018-11-04
407 Dynamic Spilled Arrays: Show All Formulas For All Columns in Cells as Auditing Trail EMT 1524 4:51 2018-11-02
408 Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523 4:46 2018-11-01
409 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
410 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528 13:02 2018-10-28
411 Dynamic Array Discussions in excelisfun Community Tab: Charts?, Append Totals? Big Data? 3:16 2018-10-27
412 Excel Dynamic Array UNIQUE with INDIRECT To Extract Unique Lists for Each Column (EMT 1522) 4:05 2018-10-26
413 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520 9:16 2018-10-24
414 Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518 7:44 2018-10-23
415 Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518 7:44 2018-10-23
416 Excel Dynamic Arrays: Backward Compatibility? Forward Compatibility? What Happens? EMT 1519 6:18 2018-10-23
417 Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) 39:40 2018-10-20
418 Add 2nd Set of Points to Excel X – Y Scatter Chart (Excel Magic Trick 1517) 1:46 2018-10-19
419 Excel Magic Trick 1515: Yearly Income Statement Using SUMIFS Function, and NO Merge & Center 6:46 2018-10-08
420 Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514) 1:09:27 2018-09-14
421 Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula? 5:26 2018-08-25
422 Excel Magic Trick 1512: Count Workers Employed 1 to 6 Years Based on Hire Date? 9 Examples 14:36 2018-08-10
423 Excel Magic Trick 1510: Conditional Format Row With Duplicates Based on Product & Color 9:21 2018-08-05
424 Excel Magic Trick 1511: Array Formula: Get Low Bid From Supplier When Delivery Less Than 20 Weeks 13:28 2018-07-25
425 Excel Magic Trick 1509: Conditional Format Array Formula to Highlight Row With 2 Lookup Values 9:49 2018-07-20
426 Excel Magic Trick 1508: Lookup In Current Table? Self Join? VLOOKUP or Power Query? 8:43 2018-07-06
427 Excel Magic Trick 1507: Count Empty in Non-Adjacent Cells (5 Examples) AREAS Function? 9:35 2018-06-16
428 Excel Magic Trick 1506: Power Query to Extract All Numbers Listed in Single Cell and Add for Total 6:41 2018-06-13
429 Excel Magic Trick 1504: Lookup Cell Address: 4 Examples: MATCH, ADDRESS, CELL function? 6:23 2018-06-11
430 Excel Magic Trick 1502: Lookup Based On Row Number with Data Validation For Row Number 8:21 2018-06-09
431 Excel Magic Trick 1501 Pt 02: INDIRECT Lookup Items From Different Sheets Based on Row Number 6:11 2018-06-07
432 Excel Magic Trick 1505: Fill Data Automatically in Excel with Magic Fill Handle 1:12 2018-06-05
433 Excel Magic Trick 1501: INDIRECT Function: Pull Data from Different Sheet Based on Row Number 5:49 2018-06-04
434 Excel Magic Trick 1500: Lookup All Products For Supplier & Join in Single Cell TEXTJOIN & IF 5:54 2018-06-01
435 Excel Magic Trick 1503: Free Book Give Away EMT 1493 – 1496 RAND & VLOOKUP Functions 5:43 2018-05-31
436 Excel Magic Trick 1499: VLOOKUP or INDEX Joins to Create Transaction Description (3 Examples) 10:10 2018-05-29
437 Power Query Power BI: Transform 2 Fact Tables to Star Schema Data Model (Invoice Data) EMT 1498 26:10 2018-05-28
438 EMT 1497: Vote For Your Favorite “Allocate Invoice Header Amounts To Transaction Line Table” 1:49 2018-05-24
439 EMT 1495 Part 02: Power Query with Group By Rows: Allocate Invoice Amounts To Line Item Table 17:40 2018-05-22
440 EMT 1496: Power BI Desktop: Allocate Invoice Header Amounts To Transaction Line Item Table 18:47 2018-05-19
441 EMT 1495: Power Query: Allocate Invoice Header Amounts To Transaction Line Item Table 20:38 2018-05-16
442 EMT 1495: Power Query: Allocate Invoice Header Amounts To Transaction Line Item Table 20:38 2018-05-16
443 EMT 1494: DAX & Power Pivot: Allocate Invoice Header Amounts To Invoice Transaction Line Table 23:16 2018-05-14
444 EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Table 15:37 2018-05-12
445 EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Table 15:37 2018-05-12
446 EMT 1493: Excel Formulas PivotTable: Allocate Invoice Header Amounts To Transaction Line Table 21:40 2018-05-10
447 DAX Approximate Match Lookup Part 2: Foreign Key & Relationship or LOOKUPVALUE? EMT1492 13:03 2018-05-08
448 DAX Approximate Match Lookup & Exact Match Lookup Together for Discounted Product Price (EMT 1490) 20:02 2018-05-06
449 Excel Magic Trick 1491: “Lookup Latest Product Price” Survey Results, Winner of Free Book 4:03 2018-05-04
450 Excel Magic Trick 1489: 2 VLOOKUP in 1 Formula: Lookup Correct Volume Discount Product Price 8:56 2018-05-02
451 Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date 13:03 2018-04-27
452 Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date 8:09 2018-04-26
453 Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date 9:32 2018-04-22
454 Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date 8:45 2018-04-20
455 Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date 13:35 2018-04-18
456 Excel Magic Trick 1482: SUMPRODUCT, DCOUNTA or SUM & IF for Counting with OR Logical Test 20:12 2018-04-04
457 Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too 11:39 2018-03-25
458 Excel Magic Trick 1480: VLOOKUP & MATCH Two-Way Lookup Quantity & Product to Get Price 7:51 2018-03-22
459 Excel Magic Trick 1479: Lookup Bulk Quantity Discount Prices Using VLOOKUP Function 10:54 2018-03-16
460 Excel Magic Trick 1478: Conditional Format Row When Event Code is a Duplicate AND Task = "Special" 8:11 2018-02-19
461 Excel Magic Trick 1477: COUNTIFS & AND Functions for Duplicate Event Codes AND Task = "Special" 4:53 2018-02-17
462 Excel Magic Trick 1476: SUMIFS to Add Expenses for Any Time Period (Adding with Three Conditions) 8:42 2018-02-04
463 Excel Magic Trick 1475: Power Query, Formula, Flash Fill: "1-PSD/AFX-12" into "12-AFX/PSD-1" 10:59 2017-12-31
464 Excel Magic Trick 1473: Sequential Number Incrementor for Just The Middle Number: AA-0009-17 7:41 2017-12-27
465 Excel Magic Trick 1472: Count Between (or Above and Below) Upper & Lower Limits (7 Examples) 22:14 2017-12-22
466 Excel Magic Trick 1471: Array Formula: Add Daily Rainfall 5 AM to 5 AM Next Day: (Most Automatic) 37:16 2017-12-13
467 Excel Magic Trick 1470: Power Query (Get & Transform) Add Daily Rainfall 5 AM to 5 AM Next Day 20:38 2017-12-11
468 Excel Magic Trick 1469: Add Daily Rainfall 5 AM to 5 AM Next Day: Helper Column & PivotTable 9:24 2017-12-09
469 Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468) 50:06 2017-10-06
470 Excel Magic Trick 1467: COUNTIFS or SUMPRODUCT for Complex Counting Formula? (3 Examples) 27:03 2017-09-28
471 Excel Magic Trick 1466: Formulas For Start of Month & Number Days in Month From Any Date 3:16 2017-09-28
472 Excel Magic Trick 1465: Conditional Formatting Holiday Dates with Red Fill & Word "Holiday" 9:27 2017-09-20
473 Excel Magic Trick 1464: Is Item In List? Formula to Check if Item is in a List on Separate Sheet. 9:42 2017-09-14
474 Excel Magic Trick 1463: Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA 5:59 2017-09-12
475 Excel Magic Trick 1462: 5,000 Formulas in a Single Cell with SUMPRODUCT or Array Formula? 12:21 2017-09-09
476 Excel Magic Trick 1461: Ctrl + Enter or Ctrl + D, What is the Difference and When to Use Each? 4:08 2017-09-03
477 Excel Magic Trick 1460: List All Relative Positions in a Single Cell using TEXTJOIN Array Formula 12:24 2017-09-01
478 Excel Magic Trick 1459: Adding Food or Accessory Costs For Each Dog with SUMIFS & SUMPRODUCT 7:09 2017-08-30
479 Excel Magic Trick 1457 Part 2: Regional Settings & Text or Number Date / Times in SUMIFS Function 3:21 2017-08-29
480 Excel Magic Tick 1458: Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names 13:05 2017-08-28
481 Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Examples) 16:08 2017-08-23
482 Excel Magic Trick 1456: PivotTable & Slicer to Create 8 Year Sales Report by Product & Month 4:35 2017-08-21
483 Excel Magic Trick 1455: Convert Text Month Criteria to Upper & Lower Dates for SUMIFS Function 10:35 2017-08-15
484 Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month 10:30 2017-08-11
485 Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month 13:46 2017-08-09
486 Excel Magic Trick 1452: Max Monthly Customer Total for Year: Array Formula or PivotTable? 16:56 2017-08-06
487 Excel Magic Trick 1451: Hack Data Model, Date Table & DAX Measures WITHOUT buying Power Pivot 35:56 2017-08-03
488 Excel Magic Trick 1450: Replace VLOOKUP When Making PivotTables with Excel 2016 Relationships 10:20 2017-07-31
489 Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years 22:36 2017-07-24
490 Excel Magic Trick 1447: DAX DISTINCTCOUNT & CONCATENATEX to Count & List Stores Visited 6:20 2017-07-09
491 Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups 27:23 2017-07-06
492 Excel Magic Trick 1448: Conditional Formatting Formulas: Cell References To “Jump” To Next Template 15:43 2017-07-04
493 Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups 18:09 2017-07-02
494 Excel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups 7:44 2017-07-02
495 Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups 30:33 2017-07-01
496 Excel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop 21:12 2017-06-23
497 Excel Magic Trick 1442 DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In List 2 8:54 2017-06-21
498 Excel Magic Trick 1441 Power Query to Extract Items In List 1 That Are NOT In List 2: Left Anti Join 5:52 2017-06-19
499 excelisfun Posts 31 Videos in the Month of May, 2017! Vacation Time : ) 1:25 2017-06-02
500 Excel Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function 16:16 2017-05-31
501 Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total 6:52 2017-05-30
502 Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total 6:07 2017-05-29
503 Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet 8:00 2017-05-28
504 Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot 7:05 2017-05-27
505 Excel Magic Trick 1435: DAX Query to Export Data from Data Model to Excel Sheet & Much More! 17:49 2017-05-26
506 Excel Magic Trick 1434: SAMPLE DAX Function to Take Random Stratified Sample from Data Set. 12:12 2017-05-26
507 Excel Magic Trick 1433: Materialize DAX Table Functions: Existing Connections, DAX Studio, Power BI? 20:15 2017-05-24
508 Excel Magic Trick 1432: 9 DAX Formulas to Build Confidence Intervals CONFIDENCE.T, STDEV.S… 19:53 2017-05-23
509 Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR 9:45 2017-05-22
510 Excel Magic Trick 1431: XNPV, OFFSET & VLOOKUP to Get Dates & Cash Flows for NPV & IRR Calculations 13:37 2017-05-22
511 Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc 12:14 2017-05-20
512 Excel Magic Trick 1428: VLOOKUP, COUNTIFS & IF Helper Column to Calculate Asset Current Value 7:03 2017-05-20
513 Excel Magic Trick 1429: Power Query Ranking with Index, Grouping and MIN Function!!! 5:41 2017-05-19
514 Excel Magic Trick 1426: Lookup Row & Column Headers From 2-Way Lookup Table with Unique Values 12:09 2017-05-18
515 Excel Magic Trick 1425: Convert 2-Way Table to Single Column Table with INDEX & Number Incrementor 7:03 2017-05-18
516 Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas? 28:07 2017-05-17
517 Excel Magic Trick 1423: Power Query Number.ToText Function to Format Numbers as Text 9:15 2017-05-16
518 Excel Magic Trick 1422: Power Query M Code: Join all Items From Invoice into One Cell 4:33 2017-05-16
519 Excel Magic Trick 1421: Get Help for Power Query Functions 2:22 2017-05-16
520 Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns 12:51 2017-05-14
521 Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer 27:06 2017-05-12
522 Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer 14:28 2017-05-11
523 Excel Magic Trick 1417 Excel Functions Ranking Unit & Total Profit for Products within Manufacturer 12:10 2017-05-09
524 Excel Magic Trick 1416: Round Up to 15 or 30 Minute Increments for Hours Worked Time Calculations 11:17 2017-05-08
525 Excel Magic Trick 1414: Power Query Text.PadStart Function to Correctly Format Account Numbers 6:07 2017-05-06
526 Excel Magic Trick 1413: Set Default Layout in a PivotTable (New in Excel 2016, Office 365) 3:17 2017-05-03
527 Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report 6:56 2017-05-02
528 Excel Magic Trick 1411: Power Query Add Prefix to Account Numbers in Column 0:46 2017-05-01
529 Excel Magic Trick 1410: Calculate Closing Balance for Each Month from Balance Transaction Table 10:40 2017-04-30
530 Excel Magic Trick 1409: Build PivotTable From 2 Tables without Power Pivot or VLOOKUP 7:54 2017-04-29
531 Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too) 14:01 2017-04-22
532 Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables 12:46 2017-04-19
533 Excel Magic Trick 1406: Calculate Moving Average with AVEARGEIFS & EOMONTH Functions 7:05 2017-04-17
534 Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records 5:26 2017-04-15
535 Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report 13:34 2017-04-15
536 Excel Magic Trick 1402 Part 5: Conditional Formatting to Show Check Mark When Number Bigger Than 0 2:21 2017-04-11
537 Excel Magic Trick 1403: DAX Formulas: Explicit or Implicit Measures? Why Explicit is Better. 11:22 2017-04-08
538 Excel Magic Trick 1402 Part 4: UNICHAR & UNICODE Functions for Unicode Value 4:43 2017-04-07
539 Excel Magic Trick 1402 Part 3: Power Query to Put Check Mark In Cell If Number Greater Than 0 5:59 2017-04-06
540 Excel Magic Trick 1402 Part 2 Formula to Put Check Mark In Cell If Number Great than 0 without CHAR 3:41 2017-04-05
541 Excel Magic Trick 1402: Formula to Put Check Mark In Cell If Number Greater Than Zero 6:05 2017-04-04
542 Excel Magic Trick 1401: Conditionally Format Row For BOLD Date 7:27 2017-04-03
543 Excel Magic Trick 1400 Part 2: Conditionally Format Row with Complex Criteria (3 More Examples) 19:34 2017-04-02
544 Excel Magic Trick 1400: Conditionally Format Row in Class Enrollment Table with Complex Criteria 10:51 2017-03-31
545 Excel Magic Trick 1399: Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula 3:54 2017-03-29
546 Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks 41:14 2017-03-27
547 Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments 12:47 2017-03-26
548 Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart 19:28 2017-03-23
549 Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples) 11:08 2017-03-21
550 Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total 34:41 2017-03-18
551 Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item 5:13 2017-03-17
552 Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total 16:33 2017-03-16
553 Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total 7:34 2017-03-14
554 Excel Magic Trick 1392: Case Sensitive Unique Count: Power Query or Data Model PivotTable? 3:56 2017-03-12
555 Excel Magic Trick 1391: Case Sensitive VLOOKUP? 5 Examples of Excel Case Sensitive Lookup 14:35 2017-03-10
556 Excel Magic Trick 1390: Average Number of Days Between Dates in a Single Column 3 Examples 5:20 2017-03-09
557 Excel Magic Trick 1389: Average Number of Days Between Two Columns of Dates 2:42 2017-03-07
558 Excel Magic Trick 1388 Average Number of Days Between Order & Ship Date (Basic Array Formula Lesson) 12:03 2017-03-06
559 Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & Country 28:32 2017-03-02
560 Excel Magic Trick 1386: Power Query to Import & Append Large Text File in Power Pivot Data Model 6:15 2017-03-01
561 Excel Magic Trick 1385: Import Tables from SQL Server Database into Power Pivot or PBI Data Model 5:46 2017-02-28
562 Excel Magic Trick 1384: Import Excel Table or Sheet in Power Query or Power BI? 4:00 2017-02-27
563 Excel Magic Trick 1382: Extract Records With Multiple Contains (Partial Text) Criteria: 4 Examples 38:13 2017-02-22
564 Excel Magic Trick 1381: Power Query: Records In Column into Table then Two Different Top 3 Reports 20:43 2017-02-18
565 Excel Magic Trick 1380: Slicer Power Query Report To Show Incomplete Student Assignments 8:57 2017-02-16
566 Excel Magic Trick 1379: Power Query Combine Binary "Expand Button" Update January 2017 7:07 2017-02-14
567 Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula? 29:29 2017-02-11
568 Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & More 18:52 2017-02-09
569 Excel Magic Trick 1376: Complex VLOOKUP Formula To Create Transaction Description 16:54 2017-02-04
570 Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples) 55:04 2017-01-31
571 Excel Magic Trick 1374: Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function 7:05 2017-01-29
572 Excel Magic Trick 1373: Formula to Extract Every Nth Value & Conditionally Format Every Nth Value 12:54 2017-01-27
573 Excel Magic Trick 1372: Extract Only Total Row For Each Name: Formula or Power Query (6 Examples) 18:24 2017-01-25
574 Excel Magic Trick 1371: Excel Formula To Add Last Five Values in an Excel Table: INDEX Dynamic Range 7:28 2017-01-22
575 Excel Magic Trick 1370 INDEX Function & Number Incrementor Extract Items & Display In Every 3rd Cell 9:27 2017-01-19
576 Excel Magic Trick 1369: COUNTIFS To Count Not Empty Cells With 4 Criteria/Conditions 9:42 2017-01-09
577 Excel Magic Trick 1368: How To get SUMIFS to Calculate Sum Of Amazon And Google Under Each Region 7:54 2017-01-05
578 Power BI Desktop: DAX CALENDAR Function to Create Calendar / Date Table (Excel Magic Trick 1367) 17:40 2017-01-07
579 Power BI Desktop: Build Data Model, Get Data, DAX Formulas, Visualizations, Publish 2 Web (EMT 1366) 1:12:07 2016-12-31
580 Import Power Pivot Data Model into Power BI Desktop (Excel Magic Trick 1365) 3:36 2016-12-30
581 How to Use Images in a Power BI Desktop Report from Picture Web URL (Excel Magic Trick 1364) 4:51 2016-12-29
582 Excel Magic Trick 1363: Images in Power View Report from Web URL stored in Power Pivot Data Model 6:50 2016-12-28
583 Turn on Power View in Excel 2013 / 2016 for Windows (Excel Magic Trick 1362) 2:23 2016-12-28
584 Sparkling Christmas Tree in Excel! Build Conditional Format Christmas Tree: Excel Magic Trick 1361 2:24 2016-12-25
585 Comprehensive Power BI Desktop Example: Visualize Excel Data & Build Dynamic Dashboard (EMT 1360) 30:35 2016-12-23
586 Excel Magic Trick 1359: Split Times Values Into 8 Equal Zones: VLOOKUP, LOOKUP or INT/HOUR? 17:10 2016-12-21
587 Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Files 18:43 2016-12-10
588 Excel Magic Trick 1358: Query Dependencies View in Power Query (Get & Transform) 1:34 2016-12-08
589 Excel Magic Trick 1356: Lookup 3 Items & Return to Single Cell Helper Column or Power Query? 11:46 2016-12-08
590 Excel Magic Trick 1355 Extract Data at each Bold Font, Display Horizontally: GET.CELL Macro Function 25:26 2016-12-06
591 Excel Magic Trick 1354: Rank with Criteria: Rank Football Teams by Total Wins & Division Wins 6:15 2016-12-04
592 Excel Magic Trick 1353: Power Query: Extract Records w Merge Feature & Inner Join on Parameter Table 12:23 2016-12-02
593 Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions? 18:07 2016-11-30
594 Excel Magic Trick 1351: Power Query: Merge Text & Excel Files, Custom Columns, Total Row & Slicer 21:20 2016-11-29
595 Excel Magic Trick 1350: Formulas in PivotTables For Gross Profit & Percentage of Gross Profit 8:21 2016-11-26
596 Excel Magic Trick 1348: Lookup Adding: Exact Match or Approximate Match (SUM Many VLOOKUPs) 13:32 2016-11-23
597 Excel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each Product 21:05 2016-11-18
598 Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records 18:02 2016-11-21
599 Excel Magic Trick 1346: Array Formula: Split Master Table into Sub Tables, Each Product on New Sheet 22:05 2016-11-17
600 Excel Magic Trick 1345: Conditionally Format Product Name for No Items Entered in Row (4 Methods) 6:29 2016-11-15
601 Excel Magic Trick 1344: Conditional Formatting the Entire Row in an Excel Table: Totally Dynamic!! 6:02 2016-11-13
602 Excel Magic Trick 1342: Adding Column That Contains Errors SUMIF or AGGREGATE? 7:20 2016-11-10
603 Excel Magic Trick 1341: Standard Deviation with Criteria: Power Query, PivotTable, or Array Formula? 26:24 2016-11-07
604 Excel Magic Trick 1340: Create Expandable Range in an Excel Table (2 Methods) 6:38 2016-11-05
605 Excel Magic Trick 1339: Create Alphabet A – Z: Formula, Power Query, or Custom List? 10:31 2016-11-04
606 Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set 24:00 2016-10-31
607 Excel Magic Trick 1337: No X-Y Scatter Chart From PivotTable!?!? Use Power Query Instead!!! 7:59 2016-10-29
608 Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model? 11:35 2016-10-27
609 Excel Magic Trick 1335: Power Query We Couldn’t Refresh The Connection Data Source Not Found Error 1:43 2016-10-27
610 Excel Magic Trick 1334: Power Query or Formula: Lookup Name Based on Max Value and more… 14:14 2016-10-25
611 Excel Magic Trick 1333: Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding 10:31 2016-10-23
612 Excel Magic Trick 1332: Power BI Desktop: Import Multiple Excel Files & Build Dashboard 15:23 2016-10-19
613 Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform 29:48 2016-10-16
614 Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transform) 28:34 2016-10-13
615 Excel Magic Trick 1329: Clean Data Then Add w 2 Criteria: SUMIFS or Power Query (Get & Transform)? 12:33 2016-10-12
616 Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transform) 6:55 2016-10-09
617 Excel Magic Trick 1327: Formula to Count Words in Column with Mixed Data: COUNTIFS Function 4:21 2016-10-07
618 Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query? 24:51 2016-10-04
619 Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples) 31:55 2016-09-24
620 Excel Magic Trick 1324: ROWS or COUNTIFS Incrementor in Array Formula to Extracting Records? 19:21 2016-09-16
621 Excel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation 5:46 2016-09-14
622 Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL? 30:37 2016-09-13
623 Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods) 26:42 2016-09-11
624 Excel Magic Trick 1320: Distinct/Unique Count with 1 Condition using Power Query (Get & Transform) 6:13 2016-09-07
625 Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables. 5:07 2016-09-06
626 Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula? 12:38 2016-09-03
627 Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE? 15:52 2016-08-31
628 Excel Magic Trick 1315: Create A Unique Sorted List with Power Query 4:16 2016-08-22
629 Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data 15:51 2016-08-17
630 Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data 15:51 2016-08-17
631 Excel Magic Trick 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN. 20:54 2016-08-10
632 Excel Magic Trick 1312: Count The Number Of Mondays & Tuesdays Since Birth: NETWORKDAYS.INTL 8:25 2016-08-09
633 Excel Magic Trick 1311: Return Multiple Items from One Lookup Value & Show Total for Invoice Items 7:11 2016-07-25
634 Excel Magic Trick 1310: Minimum Value Greater Than Zero with: 1) SMALL & COUNTIFS, 2) LARGE? 3:23 2016-07-24
635 Excel Magic Trick 1308: Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN 2:26 2016-07-21
636 Excel Magic Trick 1307: Conditionally Format Multiple Non-Adjacent Cells in Cross Tabulated Table 9:00 2016-07-20
637 Excel Magic Trick 1306: Simulate VLOOKUP Helper Column In Array Formula using T(IF({1},Array) Trick 10:40 2016-07-17
638 Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trick 7:12 2016-07-17
639 Excel Magic Trick 1304: List Text Modes in Single Cell TEXTJOIN, INDEX, N, IF, MATCH & MODE.MULT 6:14 2016-07-15
640 Excel Magic Trick 1303: Minimum Value Greater Than Zero (3 Examples) 6:04 2016-07-15
641 Excel Magic Trick 1302: List Text Modes in Single Cell with TEXTJOIN, HLOOKUP, MATCH & MODE.MULT 6:36 2016-07-13
642 Excel Magic Trick 1301: Sorted List of Modes in Single Cell with TEXTJOIN Array Formula 7:35 2016-07-11
643 Excel Magic Trick 1300: List All Modes in Single Cell with TEXTJOIN & MODE.MULT 4:21 2016-07-10
644 Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New in Excel 2016 3:47 2016-07-01
645 Excel Magic Trick 1298: Group By Date in Power Pivot Data Model, New in Excel 2016 2:49 2016-07-01
646 Excel Magic Trick 1297: COUNTIFS & SUMPRODUCT & No Helper Column to Score Myers-Briggs Test 6:38 2016-03-24
647 Excel Magic Trick 1295: TEXTJOIN & INDEX Function to create Random Description Codes 3:46 2016-03-21
648 Excel Magic Trick 1296: COUNTIFS with OR Criteria & SUMPRODUCT to Score Myers-Briggs Test 4:04 2016-03-20
649 Excel Magic Trick 1294: Single Cell "Lookup Adding" w Improper Data Set to Score Myers-Briggs Test 7:10 2016-03-19
650 Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score 6:24 2016-03-18
651 Excel Magic Trick 1292: Power Query Unpivot into Proper Lookup Table to Score Myers-Briggs Test 7:17 2016-03-17
652 Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Test 9:16 2016-03-16
653 Excel Magic Trick 1290: VLOOKUP to Multiple Dynamic Lookup Tables Listed as Single Downloaded Table 14:45 2016-03-13
654 Excel Magic Trick 1289: Remove “USD” from CSV File Column of Numbers (6 Examples) 14:39 2016-03-11
655 Excel Magic Trick 1287: SWITCH Function: How to Lookup Formulas, References, or Anything Else 17:52 2016-03-05
656 Excel Magic Trick 1286: Excel 2016 IFS Functions (9 Examples: Compare & Contrast IF & IFS Functions) 28:21 2016-03-03
657 Excel Magic Trick 1285: OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) 19:49 2016-02-29
658 Excel Magic Trick 1284: History of Excel Max or Min with Conditions / Criteria (5 Examples) 14:38 2016-02-27
659 Excel Magic Trick 1283: MINIFS & MAXIFS Excel 2016 Functions: Max or Min with Conditions / Criteria 8:42 2016-02-25
660 Excel Magic Trick 1288: Why Doesn’t =ROW(1:LEN(A1)) Work? 5:42 2016-02-25
661 Excel Magic Trick 1282: Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function 5:12 2016-02-23
662 Excel Magic Trick 1281: TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items) 10:54 2016-02-20
663 Excel Magic Trick 1280: How To Get Latest Excel Updates for Insider Program: Office 365 2:40 2016-02-20
664 Excel Magic Trick 1277: Sort Logical Values Alphabetically: false, FALSE, False, true, TRUE, True 6:09 2016-02-18
665 Excel Magic Trick 1279: New Running Count Formula After Each Zero Value (Cumulative Count) 2:15 2016-02-14
666 Excel Magic Trick 1278: Extract Color From Description (Text String) 3:35 2016-02-14
667 Excel Magic Trick 1276: Impossible: Excel Online Absolute Cell References? 1:54 2016-02-11
668 Excel Magic Trick 1275: Excel Online Office 365 MAXIFS function 1:58 2016-02-11
669 Excel Magic Trick 1274: VLOOKUP Replaces Long IF Formula for Conversion Formula (LOOKUP too) 6:09 2016-02-10
670 Excel Magic Trick 1273: Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins 4:49 2016-02-08
671 Excel Magic Trick 1272: Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) 7:38 2016-02-07
672 Excel Magic Trick 1271: Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? 17:18 2016-02-05
673 Excel Magic Trick 1270: Calculate Retirement Date with EDATE and EOMONTH functions 3:27 2016-02-05
674 Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model 10:09 2016-02-03
675 Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List 6:27 2016-02-01
676 Excel Magic Trick 1267: PivotTable Automatic Date Grouping: New in Excel 2016 3:20 2016-01-31
677 Excel Magic Trick 1266: NETWORKDAYS.INTL: Each Employee has Different Weekend Schedule? 4:50 2016-01-30
678 Excel Magic Trick 1265: NETWORKDAYS.INTL Function: Calculate Net Workdays (8 examples) 7:53 2016-01-29
679 Excel Magic Trick 1264: Gross Pay From Start & End Date, Weekends Sun & Mon and Weekly Pay Scale 4:09 2016-01-28
680 Excel Magic Trick 1263: Power Query M Code: 10 Cross Tabulated Transformed into 1 Proper Data Set 11:21 2016-01-25
681 Excel Magic Trick 1262: Convert Times Values to HHMM Text or Text HHMM Values to Time Values 3:48 2016-01-24
682 Excel Magic Trick 1261: Flash Fill to Add Spaces to Credit Card Numbers 2:00 2016-01-23
683 Excel Magic Trick 1260 Re-Do: Prevent VLOOKUP from Returning Zero from Empty Cell in Lookup Table. 1:58 2016-01-22
684 Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes. 8:56 2016-01-22
685 Excel Magic Trick 1259: Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? 8:02 2016-01-20
686 Excel Magic Trick 1258: Add Spaces Between Digits: Custom Number Format & TEXT Function 2:19 2016-01-19
687 Excel Magic Trick 1257: Power Query to Create One Proper Table from 10 Cross Tabulated Tables 11:32 2016-01-18
688 Excel Magic Trick 1256: Grouped Dates in PivotTable With Becomes UnGrouped When I Refresh!!! 5:15 2016-01-17
689 Excel Magic Trick 1255: Formula to Convert Text Dates With Missing Year & Extra Spaces To Real Dates 5:10 2016-01-16
690 Excel Magic Trick 1254: Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula? 8:55 2016-01-13
691 Excel Magic Trick 1252: Power Query To Create Unique List of Invoice Numbers with Balances 4:03 2016-01-12
692 Excel Magic Trick 1251: SUMIFS & Table Formula Nomenclature (Structured References) to Add Invoices 4:24 2016-01-10
693 Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH! 4:58 2016-01-08
694 Excel Magic Trick 1250: Add Times to Get Total Minutes & Seconds From Downloaded Music Data 11:29 2016-01-07
695 Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail 25:46 2016-01-05
696 Excel Magic Trick 1248: Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT 5:16 2016-01-02
697 Excel Magic Trick 1247: Adding with Case Sensitive Criteria: EXACT & SUMPRODUCT 4:08 2016-01-01
698 Excel Magic Trick 1246: Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT 5:46 2015-12-30
699 Merry Christmas Tree Fun In Excel RAND Function and Conditional Formatting (Excel Magic Trick 1245) 1:54 2015-12-26
700 Excel Magic Trick 1244: Transform GDP Data Set: Advanced Filter with Formula Criteria wins! 7:33 2015-11-14
701 Excel Magic Trick 1243: Transform GDP Data Set: Power Query 2nd Method or Advanced Filter? 10:41 2015-11-07
702 Excel Magic Trick 1242: Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format 9:49 2015-11-06
703 Excel Magic Trick 1241: Keyboard To Copy Formula Next To Data Set Down A Column 1:51 2015-10-02
704 Excel Magic Trick 1240: Double Click To Copy Formula Down When Formula Is Not Next To Data Set 2:21 2015-10-01
705 Excel Magic Trick 1239: Formula To Indicate a Date is in Leap Year 4:02 2015-10-01
706 Excel Magic Trick 1238: Are All Cells Equal? Is The Content In Each Cell The Same? 4 Examples 9:36 2015-09-16
707 Excel Magic Trick 1237: Add with "Contains Criteria" or Partial Text Criteria: SUMIFS & Wildcard 3:56 2015-09-15
708 Excel Magic Trick 1236: Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT? 7:14 2015-09-13
709 Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP 10:45 2015-09-11
710 Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range 8:46 2015-08-30
711 Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function 5:38 2015-08-29
712 Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1 8:42 2015-08-27
713 Excel Magic Trick 1231: VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function? 14:21 2015-08-24
714 Excel Magic Trick 1230: Conditional Formatting: Highlight Table with Color When Name Selected 5:08 2015-08-23
715 Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color 2:37 2015-08-19
716 Excel Magic Trick 1224: Which Similar Array Formula? Compare Number of Array Operations 8:57 2015-08-12
717 Excel Magic Trick 1228: Hours Worked Formula For Date & Time Values & Time Custom Number Format 4:06 2015-08-18
718 Excel Magic Trick 1227: Conditional Format: Min, Max & Min Value Greater Than Zero 7:20 2015-08-17
719 Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) 22:32 2015-08-14
720 Excel Magic Trick 1225: Excel/Word Mail Merge for Customer Accounts Receivable Letter or E-mail 12:07 2015-08-14
721 Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data 5:44 2015-08-10
722 Excel Magic Trick 1222: Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format? 6:49 2015-08-08
723 Excel Magic Trick 1221: Dynamic Chart to Plot Daily Changes in Meter Readings 8:57 2015-08-07
724 Excel Magic Trick 1220: How To Put Double Quotes In Text Formula: Extra Double Quotes Or VLOOKUP 5:45 2015-08-05
725 Excel Magic Trick 1219: Paste Special Linked Picture so PivotTable is not Hidden When Filter Applied 4:17 2015-08-03
726 Excel Magic Trick 1218: PivotTable & Slicer To Show Historical Adj Stock Price by Year & Month 9:01 2015-08-01
727 Excel Magic Trick 1217: D Functions: Text Criteria: “Starts With”, “Exact” and “Contains” 5:07 2015-07-31
728 Excel Magic Trick 1216: Fraction Number Formatting To Show Only Significant Digits, Like: ####/#### 5:26 2015-07-30
729 Excel Magic Trick 1215: Filter Data Set & Chart Disappears: Change Chart Properties!!! 3:02 2015-07-29
730 Excel Magic Trick 1214: How To Enter Text Criteria Into Excel Database Functions 4:07 2015-07-28
731 Excel Magic Trick 1213: Fraction Number Formatting & Making Sure the Correct Number Is Displayed 4:31 2015-07-27
732 Excel Magic Trick 1212: What To Do If You Filter Data Set & Chart Disappears 3:21 2015-07-25
733 Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function 8:53 2015-07-24
734 Excel Magic Trick 1210: Power Query to Combine 4 Columns into 1 Table For PivotTable Report 8:13 2015-07-23
735 Excel Magic Trick 1209: BINOM.DIST.RANGE Function for Calculating Binomial Probabilities 6:12 2015-07-21
736 Excel Magic Trick 1208: Combine 4 Columns into 1 Table For PivotTable Report (without Power Query) 11:09 2015-07-20
737 Excel Magic Trick 1207: PERCENTILE.EXC, PERCENTILE.INC, QUARTILE.EXC, QUARTILE.INC Functions 12:52 2015-07-17
738 Excel Magic Trick 1206: Day & Night Shift Time Calculations: Add Total Hours Single Cell Formula 10:35 2015-07-16
739 Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers 11:27 2015-06-06
740 Excel Magic Trick 1204: Conditional Formatting For Day’s Change: Up & Down Icon Arrows 2:52 2015-05-31
741 Excel Magic Trick 1203: 2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change 9:09 2015-05-26
742 Excel Magic Trick 1202: Conditional Formatting For a Cross Tabulated PivotTable 4:06 2015-05-25
743 Excel Magic Trick 1201: Conditional Format Product With No Sales (5 Examples) 10:07 2015-05-24
744 Excel Magic Trick 1200: Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods) 6:59 2015-05-23
745 Excel Magic Trick 1199: Formula to Extract Everything After Last Space: Two Formula Solutions 6:37 2015-05-22
746 Excel Magic Trick 1198: Median for Each Quarter Using AGGREGATE Function 8:32 2015-05-21
747 Excel Magic Trick 1197: OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT? 12:28 2015-05-07
748 Excel Magic Trick 1196: YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips… 9:47 2015-05-03
749 Excel Magic Trick 1195: Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? 7:45 2015-05-02
750 Excel Magic Trick 1192: Match Lookup Value to Closest Number in 1st Column of Lookup Table 10:33 2015-04-24
751 Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table? 5:58 2015-04-24
752 Excel Magic Trick 1194: VLOOKUP: Data Mismatch Makes Yields #N/A, What To Do? 2:40 2015-04-24
753 Excel Magic Trick 1191: VLOOKUP: Lookup Temperature and Return to Bat Observation Table 4:44 2015-04-24

Embed a badge

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

Watch time: 4d 13h 32m · 752 videos

Markdown
[![Watch time: 4d 13h 32m · 752 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nh-KtsbVsPSTRi11mlD99P.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0nh-KtsbVsPSTRi11mlD99P)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0nh-KtsbVsPSTRi11mlD99P"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nh-KtsbVsPSTRi11mlD99P.svg" alt="Watch time: 4d 13h 32m · 752 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/PLrRPvpgDmw0nh-KtsbVsPSTRi11mlD99P 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.