Playlist · excelisfun

Uploads from excelisfun

by excelisfun · 2,550 videos · first 2,550 of 3,899

Total watch time

23d 16h 31m

at 1× speed · exactly 23 days, 16 hours, 31 minutes, 20 seconds at 1×

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

custom

Finish by

569 days

at an hour a day · pick your own pace

At each speed

1×	23d 16h 31m 20s
1.25×	18d 22h 49m 4s	−4d 17h 42m
1.5×	15d 19h 53s	−7d 21h 30m
1.75×	13d 12h 52m 11s	−10d 3h 39m
2×	11d 20h 15m 40s	−11d 20h 16m

Average video13m 23s

Longest3h 44m 8s

Shortest10s

The shape of the course

2,550 videos in blocks of 100 · each column is a block's total, to scale

1d 12h 1m

WatchedTo watch

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

Your plan

Plan to finish

About 569 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 569 days. Turn on JavaScript to plan around your week.

Videos (2,550)

23d 16h 31m in total · tick what you've watched

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



1	Power Query #11: Excel.CurrentWorkbook Power Query M Code Function	13:40	2026-10-18
2	Why Do YouTube Comments Disappear!?!?! EMT1937	0:39	2026-10-12
3	Power Query #10: Custom Function, Mega Custom Column Formula, or Parameter Query?	43:34	2026-10-05
4	HSTACK Inside XLOOKUP & Cell Lists. Excel Magic Trick 1936.	1:29	2026-10-04
5	COUNTA function and Cell Arrays. Excel Magic Trick 1935	1:12	2026-10-03
6	GROUPBY Reporting Function with Cell Lists. Excel Magic Trick 1933	2:20	2026-10-02
7	How To Hard Code Lists & Arrays into Cells: The Difference From Legacy Ctrl Shift Enter. EMT 1934	2:13	2026-10-01
8	XLOOKUP Function with Cell Lists and FLATTEN Function. EMT 1932	1:24	2026-09-30
9	The Missing Piece To Dynamic Spilled Array Formulas: Cell Lists & Arrays & FLATTEN. EMT 1931	3:22	2026-09-29
10	FLATTEN Function Arguments Explained. EMT1930	4:03	2026-09-28
11	FLATTEN Function & Cell Lists To Spill TEXTSPLIT Results Into Rectangular Range. EMT 1929	3:12	2026-09-28
12	Do COLUMNS & ROWS Functions Work on Cell Lists & Arrays? Excel Magic Trick 1928	3:03	2026-09-27
13	Naming Excel Tables Became Easy. Excel Magic Trick 1927	0:51	2026-09-27
14	New Excel Cell Lists & Arrays & FLATTEN Change Everything. Model Building’s New Frontier. EMT 1926	12:28	2026-09-26
15	Power Query #9: The Secrets of Power Query are in the M Code	1:53:08	2026-09-23
16	Formulas or Power Query or Regex: Why Do I Get Zero When I SUM? Excel Magic Trick 1925	13:45	2026-09-17
17	Power Query #8: Optimize Performance with SQL Server Database Connection	28:48	2026-09-13
18	PQ #6 Part 2: Multiple Excel Files, Different Sheet Names Into Table with Combine Button	4:31	2026-09-07
19	Power Query #7: Merge Join Feature: All Seven Examples	21:54	2026-09-01
20	Power Query #6: 12 Tables Into One Table With Just A Click: Combine Files Button	12:46	2026-08-25
21	Power Query #5: Append Tables with Table.Combine Function: Seven Examples	17:59	2026-08-18
22	Power Query #4: How to Unpivot Columns with Table.UnpivotOtherColumns function	20:05	2026-08-12
23	Conditionally Format Row in Schedule for Today’s Date - Mixed Cell References \| EMT 1924	5:59	2026-08-09
24	Sort "City, State" Text by State Then City \| SORTBY Array Function - EMT 1923	3:58	2026-08-06
25	Excel Sort Left To Right. Horizontal Sort. Excel Short 83	0:53	2026-08-05
26	PQ #3: Full Free Lesson in Power BI Desktop: Power Query, M, Data Model, DAX Formulas, Visualizing	42:20	2026-08-04
27	Excel Keyboard to Select Full Range & Remove Only The Formatting!!!! Excel Short 82	0:57	2026-08-03
28	Amazing Excel Selection Keyboard Shortcut. Do You Know It? Excel Short 81	0:46	2026-08-02
29	Power Query #2: Import, Clean, Transform & Load Data in Excel	52:01	2026-07-28
30	Power Query #1: Introduction to Power Query & Data Analysis in Excel & Power BI	22:24	2026-07-22
31	excelisfun Boomerangs Back to YouTube: Make More Excel & Power BI Videos & Classes in 2026 & Beyond!	1:59	2026-07-20
32	Last Video From Mike "excelisfun" Girvin on Feb 16, 2026, 18 years at YouTube!!! Go Team!!!	0:55	2026-02-16
33	Excel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation. EMT 1922.	10:54	2026-02-03
34	Excel Formula for Accounting Bank Reconciliation with IF, ISNUMBER & SUM Functions. EMT 1921.	11:12	2026-01-07
35	Complete Lesson in Excel Text Formulas that use References to Dates, Money & Arrays. EMT 1920.	7:47	2025-12-23
36	excelisfun Flashback Friday 6: Sparkling Christmas Tree in Excel! Build Conditional Formatting Tree	2:44	2025-12-20
37	Extend Excel Date Format To Other Dates: Fill Formatting Only Trick! Excel Short 80	1:02	2025-12-16
38	Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919	13:18	2025-12-09
39	Power Query Nested Functions in Custom Column: Convert Multiple Csv Files into One Table. EMT 1918	15:21	2025-12-02
40	Build Power Query Custom Function: Convert Multiple Csv Cross Tab Tables into Single Table EMT 1917.	18:18	2025-11-23
41	Part 2: Power Query Unpivot Cross Tab Table with 2 Column Variables. An Easier Way! EMT 1916 Part 02	9:41	2025-11-18
42	Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916	10:10	2025-11-17
43	2 Excel Formulas to Add Sequential Numbers Each Time a New Row Is Added To a Table. EMT 1915	5:09	2025-11-11
44	PivotTable New Features (Spill Error & Auto Refresh) and PivotTable Basics Revealed. EMT 1914	7:54	2025-11-07
45	FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912	12:11	2025-10-13
46	Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913	10:16	2025-10-13
47	Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911	8:45	2025-10-03
48	Magic Data Validation List using Dynamic Range Reference or Spilled Range Operator!! EMT 1910	7:25	2025-10-01
49	Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909	4:25	2025-09-29
50	The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908	7:43	2025-09-16
51	Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907	3:40	2025-09-12
52	Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906	5:35	2025-09-11
53	Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905	2:34	2025-09-10
54	Excel TEXTSPLIT function to Split Values By Delimiter & More! Excel Magic Trick 1904	5:11	2025-09-09
55	Turn Off Excel Copilot Pop-up Button in Worksheet. Excel Magic Trick 1903	1:25	2025-09-04
56	Dad & Son Skateboard & BMX West Coast Tour: 20 stops in 9 days	3:30	2025-08-24
57	Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902	24:47	2025-08-21
58	COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901	24:46	2025-08-15
59	PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900	13:29	2025-07-27
60	Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899	4:54	2025-06-24
61	Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898	8:20	2025-06-22
62	Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897	4:40	2025-06-20
63	Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896	2:13	2025-06-19
64	Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895.	1:51	2025-06-18
65	Create Random Dates with Excel Functions. Excel Magic Trick 1894	3:22	2025-06-17
66	XLOOKUP, LEFT, TEXTBEFORE, & LOOKUP Functions & Math Tricks to Calculate Discounted Sales! EMT 1893	6:26	2025-06-11
67	Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892	2:51	2025-06-08
68	3 Months of Seattle Skatepark Clips in 3 Minutes. excelisfun & Son Skateboard and BMX Action.	2:46	2025-05-14
69	Import Worksheet of Data From External Excel File into Current Excel File. Excel Short 79	1:15	2025-05-09
70	Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887	17:44	2025-05-08
71	Increase Excel Row Height for Multiple Columns Excel Short 78	0:32	2025-05-06
72	Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889	3:56	2025-05-04
73	COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891	6:09	2025-05-03
74	Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890	3:08	2025-05-02
75	INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888	3:42	2025-05-01
76	Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886	3:00	2025-04-26
77	File Explorer Skills To Be Good In Excel? 100% Yes! File Extensions & F2 Trick! EMT 1885	1:23	2025-04-25
78	The Beauty Of Power Query! One Quick Example : )	1:59	2025-04-21
79	MS 365 Excel Basics #13: Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas	46:46	2025-04-20
80	Opposite of TEXTJOIN? It's TEXTSPLIT used to Split Sub-text from Text String. Excel Short 76 Part 3	1:00	2025-04-19
81	Array of Delimiters in TEXTJOIN for the Perfect Join! Excel Magic Trick Short # 76 part 02	0:56	2025-04-18
82	MS 365 Excel Basics 12: Power BI Desktop & Interactive Visuals / Dashboards, Import Excel Data Model	25:17	2025-04-17
83	GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883	2:46	2025-04-16
84	MS 365 Excel Basics 11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context Too!	39:24	2025-04-15
85	Turn Off GETPIVOTDATA Function So I Can Refer To My PivotTable With A Cell Reference. Excel Short 77	1:25	2025-04-14
86	Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882	4:21	2025-04-14
87	MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total	3:28	2025-04-13
88	Excel TEXTJOIN Function Trick to Join Text from 2 Columns into 1 Cell! Excel Short Magic Trick 76	1:20	2025-04-12
89	MS 365 Excel Basics #10 Part 03: FILTER Array Function to Dynamically Filter!	4:41	2025-04-11
90	Introduction to excelisfun @ YouTube: Free Excel Classes, Videos & Practice Files & Power BI Too!	1:47	2025-04-10
91	MS 365 Excel Basics #10 Part 02: SORT Array Function & the Many Varied Tasks It Can Achieve!	6:14	2025-04-09
92	MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples.	1:28:49	2025-04-07
93	Mind-Blowing: GROUPBY Function Beats PivotTable, Hands-down. Beats COUNTIFS Too! Excel Short # 75	1:50	2025-03-30
94	MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!	51:23	2025-03-30
95	Temporary Fix for GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? EMT 1881	1:23	2025-03-28
96	GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks?	2:11	2025-03-27
97	Excel Revolution with PIVOTBY & GROUPBY Functions! #Short Preview of Upcoming Video	0:26	2025-03-26
98	How to Add Subtitles to YouTube Videos in Multiple Language March 25 2025 Update	2:33	2025-03-26
99	Add Slicer to PivotTable & Chart To Enable Quick Analysis Excel Short Magic Trick 74	1:00	2025-03-24
100	Fast Keyboard to Create Excel PivotTable Excel Short Magic Trick 73	1:15	2025-03-23

101	Why Excel Table Feature is Amazing & How To Create Them: Excel #Short Magic Trick 72	1:50	2025-03-23
102	MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!	35:54	2025-03-23
103	PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879	1:22	2025-03-15
104	Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878	2:35	2025-03-14
105	Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71	0:46	2025-03-13
106	Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70	2:23	2025-03-12
107	Increase All Numbers by a Multiple of 10: Excel Paste Special Multiply Magic!! Short Excel Trick 69	0:42	2025-03-11
108	Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68	2:30	2025-03-10
109	PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877	2:21	2025-03-09
110	Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876	2:33	2025-03-08
111	No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875	4:42	2025-03-07
112	FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874	3:24	2025-03-06
113	LET Function to Define LAMBDA as f, then Perform Column Iteration With Vertical Spill. #Short 67	2:29	2025-03-05
114	LET & BYCOL Functions to Spill Column Aggregate calculations Vertically. #Short 66	2:19	2025-03-04
115	Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872	13:36	2025-03-03
116	Spill Aggregate Totals with the AGGREAGATE Function. #Short 65	2:19	2025-03-02
117	Spill Aggregate Totals with BYCOL Function (GEOMEAN too), Across Bottom of Table! #Short 64	2:07	2025-03-01
118	AI Doesn't Know This: Best Solution for Excel Table Running Count Error! #Short Excel Trick 63	1:37	2025-02-27
119	BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871	6:54	2025-02-26
120	Excel's WRAPCOLS Array Function to Undo Table Into a Specified # of Columns. #Short Excel Trick #62	0:47	2025-02-25
121	Add Secondary Series of Numbers To Excel Chart & Add Second X-Axis Labels to Chart: EMT 1873	3:01	2025-02-25
122	GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870	5:45	2025-02-24
123	No More VBA! Amazing WRAPROWS Function Converts Column of Records to Table. #Short Excel Trick 61	1:36	2025-02-23
124	Best Formula for % Change (Daily Stock Returns). #Short Excel Trick 60	1:09	2025-02-22
125	Stock Portfolio Expected Return & Beta with single cell array formula. Bonus Trick Too! #Short 59	1:39	2025-02-21
126	Expected Return & Standard Deviation 4 Portfolio of Stocks Single Cell Excel Array Formula #Short 58	2:10	2025-02-20
127	Expected Return & Standard Deviation for 2 Stocks: Single Cell Excel Spilled Array Formula #Short 57	2:28	2025-02-19
128	excelisfun YouTube Channel is 17 Years Old!!!!!!!	0:35	2025-02-18
129	Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56	1:53	2025-02-18
130	Excel's Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55	2:10	2025-02-17
131	Dynamic PivotTable To Count SalesRep Monthly Sales & Visualize Trend. Excel Magic Trick 1869	7:49	2025-02-15
132	Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54. ACCTG 455 #68.4	2:30	2025-02-14
133	Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53. ACCTG 455 #68.3	1:27	2025-02-13
134	Net Present Value: Do We Buy Asset? PV or NPV Function? #Short 52. ACCTG 455 #68.2	2:20	2025-02-12
135	Build Text Formula for Dynamic Label For Financial Model. #Short 51. ACCTG 455 #68.1	1:41	2025-02-11
136	Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50. ACCTG 455 #63.2	1:56	2025-02-10
137	Visualize How Stock Values Changes as Dividend Growth Rate Changes. #Short 49. ACCTG 455 #63.1	1:11	2025-02-09
138	Bond Rate Risk: Lower Coupon Rate, The More YTM Affects Bond Price. #Short 48. ACCTG 455 #54.2	1:45	2025-02-08
139	Excelisfun Needs Your Help in Solving A Formula Number Formatting Mystery. #Short 52 Part 02	0:43	2025-02-07
140	Bond Rate Risk: Longer Maturity, More YTM Affects Bond Price. #Short 47. ACCTG 455 #54.1	2:05	2025-02-06
141	Visualize Inverse Relationship for Bond Price & YTM Rate. #Short Excel Trick 46. ACCTG 455 50.4	1:13	2025-02-05
142	Spill Bond Valuation PV Function Formula Across YTM Rates. #Short Excel Trick 45. ACCTG 455 #50.3	1:21	2025-02-04
143	IFS Function for Bond Value "Par", "Discount", or "Premium". #Short Excel Trick 44. ACCTG 455 # 50.2	1:23	2025-02-03
144	Conditional Formatting for Bond Sold at Discount or Premium. #Short Excel Trick 43. ACCTG 455 # 50.1	1:23	2025-02-02
145	Deep Discount Loan Spilled Amortization Table (Treasury Bonds) . #Short Excel Trick 42. ACCTG 455.	1:23	2025-02-01
146	Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41. ACCTG 455.	1:20	2025-01-31
147	Excel Spilled Loan Amortization Table. #Short Excel Trick 40. ACCTG 455.	1:39	2025-01-30
148	What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39	1:11	2025-01-25
149	CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38	1:08	2025-01-24
150	Excel Formulas: Arrow Keys or Mouse? Return on Assets & Return on Equity Show the Best! #Short ET 37	1:15	2025-01-24
151	I Can’t See All of My Excel Worksheet Tabs!?!?! #Short Excel Trick 36	0:23	2025-01-23
152	Subtle Excel Keyboard Awesomeness: Ctrl + Shift + Arrow, then, Shift + Arrow #Short Excel Trick 35	1:11	2025-01-22
153	MS 365 Excel Basics #3.5: Spill Rectangle Range of Weekly Commission Paid Amounts: #Short EMT 34	1:20	2025-01-21
154	ACCTG 455: Excel Finance Class 19.75: DuPont ROE Analysis. EMT Short #33.	1:51	2025-01-21
155	ACCTG 455: Excel Finance Class 19.5: Why DuPont ROE Analysis is So Clever!	1:50	2025-01-21
156	World’s Greatest Excel Keyboard Short Cut? It’s a Tie Between Two!!! #Short Excel Magic Trick 32	0:33	2025-01-20
157	Warning About Excel SUM Function Keyboard Shortcut: Alt + = #Short Excel Magic Trick 31	0:45	2025-01-19
158	ACCTG 455 Excel Finance Class 15.75: Three Common Sized Balance Sheet: Single Formula #Short EMT 30	1:00	2025-01-18
159	ACCTG 455, Excel Finance Class 13.5: Financial Statement Cash Flow Equation Algebra Hint for HW 19	3:16	2025-01-17
160	ACCTG 455 Excel Finance Class 15.5: Formula for Multiple Common Sized Income Statements #Short ET 29	1:00	2025-01-17
161	ACCTG 455 Excel Finance Class 14.5: Common Size Income Statement Spilled Array Formula #Short EMT 28	1:01	2025-01-16
162	How To Make Your Worksheet Formula Solution Better!	0:56	2025-01-15
163	Slicer Not Working With Second PivotTable? Here Is The Easy Fix! #Short Excel Magic Trick 26	0:37	2025-01-14
164	Create Excel PivotTable and Slicer is Less Than One Minute! #Short Excel Magic Trick 25	0:56	2025-01-13
165	Spill SUM Functions ? BYROW & BYCOL to Spill Any Aggregate Function! #Short Excel Magic Trick 24	1:00	2025-01-12
166	25 Formulas with a Single Keyboard Shortcut: Believe it! #Short Excel Magic Trick 23	0:44	2025-01-11
167	Excel Dynamic Range with TRIMRANGE Function #Short Excel Magic Trick 22	0:59	2025-01-10
168	Excel Dynamic Range Reference Operator .:. Trim Range Reference. #Short Excel Magic Trick 21	0:59	2025-01-09
169	Remove All Workbook References From Formulas Quickly with Excel Replace Feature #Short EMT 20	0:56	2025-01-08
170	Rad Is Rad: BMX or Skateboards or Excel: Old or Young: Having Fun Is It!!!	1:16	2025-01-07
171	Excel 365 Basics #7: Comprehensive Formula & Function Lesson To Become An Excel Formula Guru!	1:26:24	2025-01-06
172	Highline College Excel Corporate Finance ACCTG 455 Class 2025 Winter by Mike "excelisfun" Girvin	5:37	2025-01-06
173	Select All Empty Cells & Delete Them: Go To Dialog Box and F5 Key #Short Excel Magic Trick 19	0:41	2025-01-05
174	Select All Cells With Excel Formulas! Go To F5 Key. #Short Excel Magic Trick 18	0:43	2025-01-04
175	What is the Difference Between Excel Merge Across & Merge Cells? #Short Excel Magic Trick 17	0:46	2025-01-04
176	Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868	17:11	2025-01-04
177	Spreadsheet Construction Busn 218 Class @ Highline College, 2025 Winter by Mike "excelisfun" Girvin	9:15	2025-01-03
178	Highline College Statistical Analysis Busn 210 Class 2025 Winter taught by Mike "excelisfun" Girvin	12:41	2025-01-02
179	2024 Christmas Tree with Excel Formula	1:29	2024-12-24
180	Excel 365 Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task!	49:21	2024-12-22
181	Excel 365 Basics #5: IF Function & Logical Tests IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More	46:45	2024-12-12
182	Excel 365 Basics #4: Date & Time Formulas, Functions & Formatting: All The Basics You Need to Know	42:28	2024-11-24
183	Excel 365 Basics #3: Number Formatting as Façade & when you MUST use ROUND Function	21:46	2024-11-17
184	Excel 365 Basics #2: SUMIFS, COUNTIFS, COUNT, COUNTA, ROWS, SUM & IF Functions to Add & Count	52:01	2024-11-11
185	Excel 365 Basics #1: What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup	1:05:26	2024-10-31
186	Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables	51:58	2024-10-03
187	Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866	11:30	2024-09-19
188	Highline College Busn 218 Advanced Excel Fall, 2024 Introduction	8:54	2024-09-19
189	Highline College Busn 210 Excel Statistical Analysis Fall, 2024 Introduction	12:19	2024-09-19
190	Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865	13:32	2024-08-14
191	Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864	2:52	2024-08-09
192	Special Offer: New Power BI & Excel Power Query M Code Book from excelisfun!!!	1:15	2024-08-06
193	GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863	6:00	2024-08-04
194	1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862	3:26	2024-07-28
195	Poem about excelisfun and MVP by Hiran de Silva	2:37	2024-07-19
196	excelisfun online form to fill out to regain MVP from Celia Alves	0:46	2024-07-19
197	Introduction to the excelisfun Channel at YouTube: Free Videos, Files and Full Free Courses!!	1:41	2024-07-17
198	UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861	1:56	2024-07-15
199	Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860	3:38	2024-07-12
200	Microsoft Revokes excelisfun MVP Status!	0:37	2024-07-11

201	excelisfun Boomerangs Back With Gold Plaque!!! and more!!!!	1:47	2024-07-08
202	excelisfun One Million YouTube Subscribers!!!!	1:52	2024-06-07
203	DAME 07: How to Make Effective Dashboard. Three Examples in Power BI	31:56	2024-06-03
204	DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class	2:31:36	2024-05-27
205	DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)	1:50:07	2024-05-19
206	DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.	52:18	2024-05-05
207	DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.	44:29	2024-04-25
208	DAME 2 (Updated): MS Data Analysis Tools: Excel, Power Query, Power BI, Data Flow, DAX & M Code!	1:46:13	2024-04-24
209	DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!	23:33	2024-04-08
210	Why Are So Many Decimal Showing In Excel? Answer Student’s Question About Number Formatting	2:41	2024-04-06
211	Spring 2024 Data Analysis With Microsoft Power Tools - BI 348 at Highline College	3:23	2024-03-31
212	Spring 2024 Business Excel Statistical Analysis - Busn 210 at Highline College	7:48	2024-03-31
213	PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859	2:48	2024-03-25
214	Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858	3:10	2024-03-18
215	Generate Random Data Sets with Dates & Sales Numbers: RANDARRAY Function. Excel Magic Trick 1857	3:09	2024-03-11
216	Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856	5:52	2024-03-04
217	GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855	5:59	2024-02-29
218	Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854	3:23	2024-02-26
219	Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853	2:14	2024-02-22
220	Append Tables in Excel. Excel Magic Trick 1852	1:08	2024-02-19
221	Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851	2:58	2024-02-12
222	Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849	5:41	2024-02-05
223	Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848	5:50	2024-01-29
224	Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850	3:02	2024-01-23
225	Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847	4:30	2024-01-19
226	Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10	1:46:52	2024-01-03
227	Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845	19:34	2023-11-20
228	ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846	2:29	2023-11-19
229	2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2	3:07	2023-11-18
230	GROUPBY Excel Worksheet Function. Single Cell Reports Made Easy! 11 Examples. EMT 1844	28:33	2023-11-18
231	FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843	2:23	2023-11-01
232	FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842	3:33	2023-10-25
233	FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841	8:29	2023-10-18
234	Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840	7:46	2023-10-11
235	Excel Formula: Extract City Name from Description. Excel Magic Trick 1839	4:02	2023-10-04
236	Excelisfun's Mom	0:29	2023-10-02
237	Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838.	5:15	2023-09-10
238	FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837	6:10	2023-09-03
239	Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836	5:42	2023-08-27
240	Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function?	4:17	2023-08-25
241	Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835	3:30	2023-08-22
242	Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834	9:03	2023-08-11
243	XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833	4:36	2023-08-07
244	Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832	3:35	2023-08-04
245	Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831	3:27	2023-08-01
246	LOOKUP Beats XLOOKUP For Horizontal / Vertical Lookup. Excel Magic Trick 1830	2:09	2023-07-29
247	LOOKUP Beats XLOOKUP For Single Cell Revenue Calculation. SUMPRODUCT Too! EMT 1829	3:34	2023-07-26
248	Federal Income Tax Calculation: LOOKUP Function Beats VLOOKUP & XLOOKUP! EMT 1828 Part 3	3:05	2023-07-23
249	LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2	3:03	2023-07-21
250	LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828	2:49	2023-07-20
251	3 Power Query Formulas: Hours Worked for Day & Night Shift from Time Values. Excel Magic Trick 1827	8:54	2023-07-16
252	Formula to Calculate Hours Worked in Excel & DAX: Day or Night Shift! Excel Magic Trick 1826	6:55	2023-07-11
253	Sunday Old Guy BMX Bike Racing & Park Action, Port Angeles, WA	2:03	2023-07-10
254	Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825	5:59	2023-07-09
255	Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824	7:33	2023-07-06
256	Excel Formula To Randomly Lookup Pictures or Any Item. Excel Magic Trick 1823	2:53	2023-07-04
257	Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822	2:54	2023-06-29
258	Generate Letters A to Z in Excel #Short Excel Magic Trick 16	0:59	2023-06-27
259	Two Date Columns in Fact Table? How To Create Report? DAX, Power Query, Excel? 365 MECS Class 22	18:12	2023-06-22
260	Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21	15:49	2023-06-18
261	Excel Formulas Sort By Last Name, Names My Have Middle Name #Short Excel Magic Trick 15	0:57	2023-06-16
262	Conditional Format Row When Employee Is Listed More Than 1 Time For Date. Excel Magic Trick 1821.	3:09	2023-06-14
263	What Is My CD Worth? A Lesson in Finance & Worksheet Model Building. 365 MECS Class 20	18:25	2023-06-10
264	Budget Vs. Actual Variance Analysis: Data Modeling, DAX, or Worksheet Formulas? 365 MECS Class 19	15:01	2023-06-02
265	Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas? 365 MECS Class 18	37:30	2023-05-31
266	INDEX Function Beats XLOOKUP? #Short Excel Magic Trick 14	0:52	2023-05-28
267	Sort By Last Name using Excel Formula: Amazing Solution!! #Short Excel Magic Trick 13	0:42	2023-05-24
268	Full Free DAX Class: Fundamentals of DAX in Power BI & Power Pivot. 365 MECS Class 17	2:26:22	2023-05-18
269	Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820	3:53	2023-04-25
270	SUMIF Function Trick: Single Cell Dynamic Range! #Short Excel Magic Trick 12	0:39	2023-04-16
271	SUMIF Trick that Beats SUMIFS. #Short Excel Magic Trick 11	0:44	2023-04-13
272	Turn Off Excel Table Formulas and Use Cell References Instead. #Short Excel Magic Trick 10	0:26	2023-04-11
273	#1 Keyboard Shortcut in Excel. #Short Excel Magic Trick 09	0:33	2023-04-09
274	Auto Numbers in an Excel Table with a Formula. #Short Excel Magic Trick 08	0:33	2023-04-07
275	Convert ISO Dates to Dates with Power Query: Excel or Power BI. #Short Excel Magic Trick 07	0:28	2023-04-05
276	Automatic Sequential Numbers Just Pop Up! SEQUENCE & IF functions. #Short Excel Magic Trick 06	0:30	2023-04-03
277	BI 348: Data Analysis with Microsoft Power Tools- Spring - 2023 Quarter Introductory Video	3:32	2023-04-02
278	Excel Statistical Analysis for Business – Busn 210 - Spring 2023 Quarter Introductory Video	10:40	2023-04-02
279	List Products Sold in Cell for Each Sales Rep with Excel Formula. #Short Excel Magic Trick 05	0:55	2023-04-01
280	Excel’s #1 Most Hidden Trick: Insert Picture In Comment. #Short Excel Magic Trick 04	0:37	2023-03-29
281	Dad & Son Skate & BMX Rad in Seattle on Sunday	1:35	2023-03-27
282	Excel Array Formulas in 1 Minute. # Short Excel Magic Trick 03	0:59	2023-03-26
283	Word Replace Feature for Special Characters: Replace All Hard Returns with 2 Hard Returns. #Short	0:36	2023-03-22
284	Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16	33:49	2023-03-21
285	INDEX & RANDARRAY Functions to Create Table of Data. # Short Excel Magic Trick 03	0:58	2023-03-20
286	Format Total Row in Dynamic Spilled Array (Conditional Formatting) # Short Excel Magic Trick 02	0:59	2023-03-20
287	Count Files in Folder Using Excel? Power Query!!! Excel Magic Trick # Short 01	0:51	2023-03-19
288	7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15	22:02	2023-03-12
289	Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14	3:38	2023-03-08
290	Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13	1:49:33	2023-03-02
291	Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819	16:06	2023-02-26
292	Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818	6:04	2023-02-24
293	Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_	1:34	2023-02-22
294	Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817	5:38	2023-02-21
295	Help Delete FAKE excelisfun Account (How To Report Fake YouTube Account)	0:41	2023-02-17
296	excelisfun @ YouTube for 15 Years! Birthday Party!	0:45	2023-02-15
297	Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12	1:41:38	2023-02-03
298	Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts	0:59	2023-01-26
299	Save Time in Excel: Copy Only Excel Format with Format Painter. Excel Magic Trick 1815 #Shorts	1:25	2023-01-26
300	Remove All Excel Format to Help Fix Reports and Data Errors. Excel Magic Trick 1814 #Shorts	1:55	2023-01-22

301	Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts	3:38	2023-01-19
302	Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shorts	2:45	2023-01-16
303	Visualizing Data and Building Dashboards in Excel & Power BI - 365 MECS 11	1:42:27	2023-01-12
304	Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811	9:47	2023-01-07
305	Busn 218 – Advanced Excel – Winter 2023 Quarter Introductory Video	8:55	2023-01-07
306	Excel Statistical Analysis for Business – Busn 210 – Winter 2023 Quarter Introductory Video	10:41	2023-01-07
307	Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810	4:00	2023-01-05
308	Excel LAMBDA function – Every Single Things You Ever Wanted To Know - 2022 Version 365 MECS 10	1:45:05	2022-12-30
309	Excel Sparkling Christmas Tree with Changeable Ornaments with LAMBDA function! EMT 1809	1:19	2022-12-24
310	Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808	4:39	2022-12-12
311	Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807	7:37	2022-12-09
312	Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806	4:06	2022-12-07
313	UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805	8:06	2022-11-29
314	Excel Dynamic Spilled Array Formulas & Functions: 50 Examples to Become an Expert! - 365 MECS 09	1:10:10	2022-11-20
315	Mike excelisfun Girvin 60th Birthday Party: BMX Park and BMX Track: Rad Old Guy Fun!	0:57	2022-11-07
316	XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804	3:29	2022-11-05
317	Spilled 2-Way Lookup Commission Report using LAMBDA and BYROW Functions. EMT 1803	5:22	2022-11-02
318	Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802	3:28	2022-10-30
319	FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801	3:24	2022-10-27
320	All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX – 28 Examples! - 365 MECS 08	1:18:51	2022-10-20
321	Dad & Son Skatepark Sunday Seattle Rad, Oct. 16, 2022. Boneless-Ones Skate Music.	0:52	2022-10-16
322	Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800	3:52	2022-10-13
323	FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799	4:41	2022-10-10
324	Logical Tests: Excel Formulas, Conditional Formatting, PivotTables, Power Query, & More- 365 MECS 07	1:48:22	2022-10-02
325	Excel Statistical Analysis for Business – Busn 210 - Fall 2022 Quarter Introductory Video	11:43	2022-09-25
326	Busn 218 – Advanced Excel - Fall 2022 Quarter Introductory Video	9:01	2022-09-25
327	Text Formulas & Functions in Excel Worksheet and Power Query - 365 MECS 06	34:27	2022-09-14
328	Date & Time Formulas & Functions in Excel Worksheet and Power Query - 365 MECS 05	50:36	2022-09-05
329	Excel & Power BI Data Analysis Complete Class in One Video - 4 Hours - Download Files - 365 MECS 04	3:44:08	2022-08-21
330	Create Sequence of Time Values in Excel for Stock Market Price Data – Excel Magic Trick 1798	7:18	2022-08-15
331	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
332	Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796	7:50	2022-08-09
333	Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795	3:02	2022-08-07
334	excelisfun’s new book The Only App That Matters Book is Released!!! Microsoft 365 Excel = The Best!	1:10	2022-08-02
335	M 365 Excel Worksheet Formulas & Models – Everything You Ever Wanted To Know - 365 MECS 03	1:11:13	2022-07-24
336	Excel Formulas & Functions, PivotTables, Slicers & Charts - 365 MECS 02	1:13:45	2022-07-11
337	Excel Formula to Lookup Cell Address Of Max Value: 12 Amazing Examples. Excel Magic Trick 1794	9:55	2022-07-05
338	How To Access Excel F Keys on Laptop Computer – Huge List of Function Keys too - 365 MECS 01 Part 2	2:01	2022-07-03
339	Introduction to Microsoft 365 Excel & Conventions for Class - 365 MECS 01	27:38	2022-06-29
340	Microsoft 365 Excel Complete Class: free from excelisfun at YouTube - 365 MECS 00	1:47	2022-06-27
341	Excel Statistical Analysis for Business – Busn 210 - Summer 2022 Quarter Introductory Video	15:32	2022-06-26
342	excelisfun e-Book release: The Only App That Matters: Microsoft 365 Excel. Preview of Book!	2:32	2022-06-16
343	Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793	8:39	2022-06-14
344	Dad & Son Seattle Jefferson Sunday Skatepark Rad: Boneless-Ones Skate Music Pumps The Action!	2:44	2022-06-13
345	Linear Regression Made Easy! The Epic Full Story with all Details. Excel Statistical Analysis 50	1:12:11	2022-06-05
346	Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792	12:05	2022-05-31
347	Sunday Seattle Green Lake Old Guy BMX Park Fun, May 29, 2022. Boneless-Ones Skate Music	1:12	2022-05-30
348	Excel Statistical Analysis 49: Hypothesis Testing for Proportion (Binominal) using Normal Curve	7:27	2022-05-22
349	Excel Statistical Analysis 48: Hypothesis Testing with T Distribution, Two Tail Example	8:54	2022-05-21
350	Excel Statistical Analysis 47: Hypothesis Testing with T Distribution, 1 Tail Lower (Left) Test	7:48	2022-05-21
351	Excel Statistical Analysis 46: Hypothesis Testing with T Distribution, 1 Tail Upper (Right) Test	11:02	2022-05-21
352	Excel Statistical Analysis 45: Hypothesis Testing with Z Distribution, Two Tail Test Example	9:56	2022-05-20
353	Excel Statistical Analysis 44: Hypothesis Testing with Z Distribution, 1 Tail Lower (Left) Test	10:58	2022-05-20
354	Excel Statistical Analysis 43: Hypothesis Testing: P-value & Critical Value Methods: 1 Tail Upper	32:48	2022-05-19
355	Excel Statistical Analysis 42: Confidence Interval for Proportions (Binomial Experiments)	10:29	2022-05-18
356	Excel Statistical Analysis 41: Confidence Interval for t Distribution, use when Sigma NOT Known	18:43	2022-05-17
357	Excel Statistical Analysis 40: Confidence Interval for z Distribution, use when Sigma Known	8:54	2022-05-16
358	Excel Statistical Analysis 39: Confidence Intervals: Theory for Estimating Population Parameter	14:07	2022-05-15
359	Excel Statistical Analysis 38: Normal Bell Curve to Estimate Range of Sample Proportions	10:29	2022-05-13
360	Excel Statistical Analysis 37: Learn Central Limit Theorem by Building Sampling Distribution of Xbar	49:53	2022-05-09
361	Excel Statistical Analysis 36: Sampling & Sampling Distribution of Sample Means (Xbar)	24:47	2022-05-08
362	Excel Statistical Analysis 35: Exponential Probability Distribution & EXPON.DIST function	11:47	2022-05-05
363	Excel Statistical Analysis 34: Answering Probability Questions With NORM.DIST Function	8:56	2022-05-02
364	Excel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart	15:10	2022-04-29
365	Excel Statistical Analysis 32: Bell Curve Functions: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV	23:50	2022-04-27
366	Excel Statistical Analysis 31: Uniform Probability Distribution	15:11	2022-04-26
367	Excel Statistical Analysis 30: Introduction to Continuous Probability Distributions	9:14	2022-04-25
368	XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791	6:59	2022-04-21
369	Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials	16:57	2022-04-19
370	Dad/Son Rad Road Trip To Oakland Lower Bobs Skatepark	1:40	2022-04-17
371	Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790	4:07	2022-04-16
372	Excel Statistical Analysis 28: Poisson Distribution, POISSON.DIST function and Poisson Column Chart	21:55	2022-04-11
373	Excel Statistical Analysis 27: Binomial Probability Distributions. BINOM.DIST.RANGE Function & Chart	32:04	2022-04-07
374	Excel Statistical Analysis 26: Accounting & Finance Discrete Probability Distribution Examples	9:38	2022-04-05
375	TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789	3:26	2022-04-04
376	BI 348 - Microsoft Power Tools – Highline College Spring 2022: Introduction Video	4:51	2022-04-03
377	Excel Statistical Analysis for Business – Busn 210 - Spring 2022 Quarter Introductory Video	15:22	2022-04-03
378	Busn 135 - Business Math – Spring 2022 Introduction Video	12:28	2022-04-03
379	DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788	12:14	2022-03-31
380	Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787	18:07	2022-03-28
381	BMX & Skate Park Adventure #14: Lake Stevens, Sunday, Sunday, March 27, 2022	1:40	2022-03-28
382	VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786	6:29	2022-03-25
383	TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785	10:20	2022-03-24
384	WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784	3:38	2022-03-23
385	Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783	8:29	2022-03-22
386	14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782	18:35	2022-03-19
387	HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781	11:30	2022-03-18
388	HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780	5:34	2022-03-16
389	3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779	11:33	2022-03-16
390	Excel Statistical Analysis 25: Import Excel data: Build PivotTable Discrete Probability Distribution	12:50	2022-03-14
391	Excel Statistical Analysis 24: Build Discrete Probability Distributions with Worksheet Formulas	28:44	2022-03-12
392	Excel Statistical Analysis 23: Discrete Probability Distributions: Terms and Definitions	13:23	2022-03-12
393	Power Query: Extract Records For Invoices 1 to 30 Days Past Due - EMT 1778	3:49	2022-03-09
394	COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777	10:51	2022-03-07
395	Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method - EMT 1776	6:05	2022-03-04
396	Sum Top 3 Values When There Is Missing Data – 3 Unbelievable Solutions (LAMBDA too) EMT 1775	6:21	2022-03-02
397	Excel Statistical Analysis 22: Bayes’ Theorem, Tabular Method, Probability Tree, SUMPRODUCT function	21:49	2022-02-27
398	Excel Statistical Analysis 21: Multiplication Law of Probability, AND Logical Test, Probability Tree	11:26	2022-02-26
399	Turn Off GETPIVOTDATA Function - EMT 1774	1:35	2022-02-25
400	Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or PivotTable?	9:09	2022-02-25

401	Excel Statistical Analysis 19: Conditional Probability 5 Examples	15:20	2022-02-24
402	Excel Statistical Analysis 18: Addition Law of Probability, OR Logical Test: Formulas & PivotTables	17:23	2022-02-22
403	Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions	28:44	2022-02-20
404	Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too	43:44	2022-02-17
405	Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773	2:48	2022-01-28
406	Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas	26:23	2022-01-21
407	Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of Standard Deviations	23:56	2022-01-19
408	Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of Variation	26:07	2022-01-17
409	Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772	2:07	2022-01-14
410	FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771	7:13	2022-01-13
411	Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank Functions & Algorithms	19:07	2022-01-12
412	Excel Statistical Analysis 11: Geometric Mean to Calculate Average Compounding Rate per Period	15:52	2022-01-08
413	Excel Statistical Analysis 10: Weighted Mean. Awesome Accounting Example!!	11:22	2022-01-07
414	Excel Statistical Analysis for Business – Busn 210 - Winter 2022 Quarter Introductory Video	15:04	2022-01-05
415	Highline College Advanced Excel – Busn 218 - Winter 2022 Quarter Introductory Video	9:35	2022-01-05
416	Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More!	40:24	2022-01-03
417	Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770	6:35	2022-01-01
418	SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769	5:34	2021-12-28
419	Excel Flashing Christmas Tree 2021- Happy Holidays Old School Formula Method. EMT 1768	2:18	2021-12-25
420	Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767	9:49	2021-12-20
421	Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766	11:09	2021-12-15
422	Excel Statistical Analysis 08: X-Y Scatter Charts for Linear Data: Excel Chart? Analyze Data Button?	12:28	2021-12-13
423	Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s Paradox	33:11	2021-12-10
424	Excel Statistical Analysis 06: Frequency Distributions, Visualizations & Skew for Quantitative Data	28:45	2021-12-06
425	Excel Statistical Analysis 05: Frequency Distributions & Visualizations for Categorical Data	33:37	2021-12-01
426	Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions	36:25	2021-11-26
427	Flip Column in Excel? Formula, Sort, Power Query or LAMBDA? Dueling Excel #196 Mr Excel & Excelisfun	11:11	2021-11-25
428	Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765	5:24	2021-11-22
429	Old Guy BMX Park Adventure #13: Lake Stevens BMX Park, Sunday, November 21, 2021	2:41	2021-11-21
430	Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video	43:20	2021-11-14
431	Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more	19:57	2021-11-11
432	Excel Statistical Analysis 01: Data & Statistics	22:56	2021-11-08
433	Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764	10:14	2021-11-01
434	Old Guy BMX Racing, then Park Riding: SeaTac BMX Track and Burien Park BMX: Rad Fun!	2:12	2021-10-31
435	Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763	12:37	2021-10-27
436	Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762	8:19	2021-10-22
437	Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761	3:46	2021-10-18
438	Excel & Statistics Busn 210, Week 4, Day 1, Fall Quarter, 2021	3:56	2021-10-17
439	INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2.	2:09	2021-10-12
440	VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760	4:33	2021-10-11
441	Sunday Oct 10, 2021 Old Guy BMX Park Fun at Lower Woodland BMX Park	2:01	2021-10-10
442	Excel Hack Video: Power Query to fix files in Windows Explorer? Excel Magic Trick 1759	4:14	2021-10-07
443	VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758	5:26	2021-10-05
444	Power Query From Sheet option Import Tables, Defined Names or Dynamic Arrays. Fast Keyboard EMT 1757	1:53	2021-09-27
445	Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756	2:29	2021-09-23
446	Busn 210 – Statistical Analysis with Excel - Fall 2021 Introduction Video	13:50	2021-09-22
447	Busn 135 - Business Math - Fall 2021 Introduction Video	11:43	2021-09-22
448	Import OneDrive File or Folder using Power Query. EMT 1755	4:29	2021-09-20
449	Tulalip Skate-BMX Park Sunday Rad: Two Old Guys and a Kid!	1:53	2021-09-19
450	Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754	4:46	2021-09-17
451	Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753	1:58	2021-09-13
452	Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752	9:14	2021-09-07
453	Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751	4:43	2021-08-31
454	BMX Old Guy Sunday Fun: Lake Stevens Park. Old Guys Just Wanna Have Fun!	1:26	2021-08-30
455	Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750	3:04	2021-08-24
456	7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749	16:30	2021-08-17
457	BMX Park Old Guy Sunday Fun at Greenlake Lower Woodland Skate-BMX, Seattle, WA, Aug 15, 2021	1:28	2021-08-15
458	Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748	6:59	2021-08-10
459	Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747	16:31	2021-08-03
460	IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746	9:05	2021-07-28
461	Excel Magic Trick 1745 Part 2: Create & Spill Random Normally Distributed Values	1:02	2021-07-26
462	11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745	10:15	2021-07-20
463	Average Excluding Min and MAX Values. TRIMMEAN function. 6 Formula Examples. EMT 1744	6:16	2021-07-13
464	OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743	10:33	2021-07-06
465	Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742	11:38	2021-06-29
466	Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741	2:43	2021-06-22
467	Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740	11:18	2021-06-14
468	SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739	5:56	2021-06-08
469	Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738.	11:44	2021-05-31
470	Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737.	9:45	2021-05-24
471	Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas	58:02	2021-05-10
472	Excel Data Analysis Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals	1:16:13	2021-05-03
473	Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!	1:16:25	2021-04-26
474	Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts	36:04	2021-04-19
475	Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.	6:21	2021-04-16
476	New Excel & Business Instructor at Highline College, Here @ YouTube too!	0:33	2021-04-15
477	Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data	5:30	2021-04-12
478	Organizational Data Types in Excel M365 & Power BI. Excel Magic Trick 1735	3:27	2021-04-09
479	Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.	4:38	2021-04-07
480	Create PivotTable in Excel Online. Excel Magic Trick 1733.	3:00	2021-04-05
481	Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732	4:35	2021-04-02
482	Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731	6:10	2021-03-30
483	BI 348 - Microsoft Power Tools - Spring 2021: Introduction Video	4:31	2021-03-28
484	Busn 135 - Business Math - Spring 2021: Introduction Video	11:10	2021-03-26
485	PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730	12:17	2021-03-23
486	4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729.	7:08	2021-03-16
487	Old Guy BMX Park & Racing in Same Day = Rad!	1:25	2021-03-07
488	Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.	5:34	2021-03-01
489	Moving Annual Total with DAX Measure. Excel Magic Trick 1726.	4:50	2021-02-23
490	Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725	15:43	2021-02-18
491	Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724	4:27	2021-02-15
492	Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723	4:12	2021-02-12
493	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
494	Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2	1:18	2021-02-04
495	Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721	5:04	2021-02-01
496	PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720	7:02	2021-01-25
497	Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719	7:19	2021-01-20
498	INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718	3:32	2021-01-18
499	Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717	6:57	2021-01-15
500	Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716	4:52	2021-01-13

501	Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715	2:02	2021-01-11
502	BMX Saturday Seattle Park Adventure: 3 Parks, 2 Kids, 3 Old Guys!	2:38	2021-01-11
503	Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.	13:09	2021-01-08
504	Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713	9:24	2021-01-06
505	INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712.	14:09	2021-01-05
506	Old Guy BMX Park . Lower Woodland Skate Park, Seattle January 3, 2021.	1:58	2021-01-05
507	Excel Magic Flashing Christmas Tree. Plus, BIG LET Surprise!!! Excel Magic Trick 1711	1:56	2020-12-25
508	Christmas Eve 2020 Old Guy BMX Park Fun!	1:52	2020-12-25
509	Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710	8:35	2020-12-22
510	Highline College Busn 210 Statistical Analysis with Excel Intro Video, Winter & Spring 2021	8:27	2020-12-22
511	Highline College Busn 135 Winter 2021 Intro Video	11:11	2020-12-22
512	Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709	6:56	2020-12-20
513	Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708.	5:15	2020-12-14
514	12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707	14:38	2020-12-09
515	Getting BMX Rad at Jefferson Park, Seattle, WA, Sunday in the Rain!	1:50	2020-12-08
516	LAMBDA Excel Function. LET & LAMBDA together to make Single Cell Reports. Excel Magic Trick 1706	5:26	2020-12-04
517	MOD function & Number.Mod Functions. Why They Give Different Answers. Excel Magic Trick 1705.	9:11	2020-12-01
518	Old Guy Park Rad. Even When It Rains! Green Lake Lower Woodland Skatepark.	2:06	2020-11-29
519	Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.	1:51	2020-11-27
520	Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703.	24:50	2020-11-23
521	Old Guy BMX. 5 Parks in One Day: Walter E Hall, Snohomish, Lake Stevens, Kenmoore, Woddenville.	2:35	2020-11-22
522	Basics of Excel Spilled Array Formulas to create Monthly Sales Report. Excel Magic Trick 1702.	15:02	2020-11-19
523	Basics of SUMIFS & PivotTables for Monthly Sales Report. Excel Magic Trick 1701.	9:20	2020-11-16
524	Biggest Sale for Each Product: PivotTable, Formulas or Power Query? Excel Magic Trick 1700.	5:59	2020-11-13
525	Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699.	18:53	2020-11-10
526	How to Rank in Power Query. EMT 1698 by excelisfun.	3:44	2020-11-02
527	Free Excel Finance Course at YouTube	1:22	2020-10-26
528	Free YouTube Excel for Statistical Analysis in Business & Economics Course	1:08	2020-10-26
529	Free Excel Business Analytics (Statistics & Math) Course at YouTube	0:55	2020-10-26
530	Free Excel Business Math & Formulas Course at YouTube	1:10	2020-10-26
531	Free Advanced Data Analysis & BI Course at YouTube (MSPTDA)	1:48	2020-10-26
532	Free Excel Data Analysis Basics Course at YouTube (E-DAB)	1:33	2020-10-26
533	Free Advanced Excel Course at YouTube	1:04	2020-10-26
534	Free Excel Basics Course at YouTube	1:06	2020-10-26
535	OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697.	6:11	2020-10-25
536	Excel FILTER based on list, not individual values? Easy! Excel Magic Trick 1696.	3:56	2020-10-18
537	Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695.	9:38	2020-10-13
538	XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694.	5:20	2020-10-09
539	FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693.	13:30	2020-10-05
540	Dynamic Count Between Lower & Upper Limit Report! Excel Magic Trick 1692.	7:26	2020-09-28
541	Highline College Busn 210 Statistical Analysis with Excel Intro Video	8:26	2020-09-24
542	Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691.	9:56	2020-09-21
543	Highline College Busn 135 Fall 2020 Intro Video	11:44	2020-09-21
544	Expand Years to Rows: Power Query or VBA? Dueling Excel #195 with Mr Excel & Excelisfun	8:54	2020-09-18
545	Create Excel Database and Data Entry Form. Excel Magic Trick 1690.	8:08	2020-09-14
546	Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689.	6:59	2020-09-11
547	List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688.	4:47	2020-09-09
548	List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687.	7:07	2020-09-07
549	Compare Two Lists, Deliver Cell Address. Dueling Excel #194 with Mr Excel & Excelisfun	11:27	2020-09-04
550	Dynamic Excel Amortization Table. Microsoft 365 Spilled Array Magic! Excel Magic Trick 1686.	11:21	2020-08-31
551	Power Query Split, Add, Combine. Dueling Excel #193 with Mr Excel & Excelisfun	13:27	2020-08-28
552	FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685.	5:08	2020-08-25
553	SPLIT, JOIN and ARRAYFORMULA Functions in Google Sheets to Split Text & Add Numbers. GS 1. EMT 1684.	2:01	2020-08-24
554	Add 500 to All Numbers in Text String? LET or VBA? Dueling Excel #192 with Mr Excel & Excelisfun	11:51	2020-08-21
555	Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683.	7:59	2020-08-17
556	Dueling Excel #191: Net Working Hours Spanning Midnight & Weekend with Mr Excel & Excelisfun	17:11	2020-08-14
557	Append Two Number Columns and Sort. Excel Magic Trick 1682.	5:10	2020-08-10
558	LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681.	14:32	2020-08-03
559	Excel Conditional Formatting Weekend & Holiday Date for Row in Table. Excel Magic Trick 1680.	6:02	2020-07-27
560	Excel Table Column Formulas and Spilled Arrays? Excel Magic Trick 1679	3:38	2020-07-20
561	Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678.	11:50	2020-07-11
562	Replace & Text To Columns to Convert Text Dates to Real Dates. Excel Magic Trick 1677	1:51	2020-07-09
563	Convert SAP Dates to Real Dates in Excel. Excel Magic Trick 1676	4:52	2020-07-06
564	Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675.	6:01	2020-07-01
565	Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674	6:07	2020-06-29
566	LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673	7:01	2020-06-22
567	Lookup 2nd Smallest Number. 2nd Biggest too. UNIQUE or FREQUENCY function? Excel Magic Trick 1672	6:38	2020-06-15
568	SORTBY, UNIQUE, INDEX and SUMIFS Functions: Dynamic Spilled Array Reports. Excel Magic Trick 1671	7:28	2020-06-08
569	Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670	12:18	2020-06-01
570	Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.	6:08	2020-05-16
571	INDEX & MATCH or XLOOKUP for Lookup Formula in SUMIFS Criteria Argument. Excel Magic Trick 1668.	5:11	2020-05-13
572	Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667	8:26	2020-05-09
573	Show File Extensions (File Types). EMT 1666	1:11	2020-05-07
574	Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665.	8:49	2020-05-05
575	Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664	10:42	2020-05-01
576	Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663	6:49	2020-04-28
577	Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661	8:18	2020-04-23
578	Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660.	22:22	2020-04-17
579	Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662	0:57	2020-04-12
580	Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659	18:33	2020-04-10
581	Learn At Home With YouTube. Amazing Free Learning Resources for Kids, Families & The Rest of Us Too	1:13	2020-04-06
582	Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658.	9:56	2020-04-03
583	PivotTables Are Easy: 6 Criteria Cross Tabulated Counting Report. Excel Magic Trick 1657.	5:35	2020-04-01
584	Highline College BI 348, People & Canvas Web Sites Introduction	4:03	2020-03-31
585	COUNTIFS 6 Criteria Counting Cross Tab Report. Change Cell Reference Every 3 Columns Too! EMT 1656	11:34	2020-03-29
586	Excel Music Video: UNSTOPPABLE Office 365 Excel. Old School Formulas v. New School Formulas EMT 1655	3:09	2020-03-27
587	INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654	4:31	2020-03-26
588	Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653	3:33	2020-03-25
589	Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652	5:42	2020-03-24
590	Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651	4:17	2020-03-23
591	Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650.	5:03	2020-03-22
592	Create a Dynamic Lookup Table using INDEX & LOOKUP Functions. Excel Magic Trick 1649	4:26	2020-03-21
593	Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648	5:28	2020-03-20
594	Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647	8:05	2020-03-17
595	Welcome to the excelisfun Excel YouTube Channel!	1:42	2020-03-14
596	Append Multiple Columns with Excel Dynamic Spilled Array Formula. Excel Magic Trick 1646.	8:28	2020-03-13
597	OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645	6:35	2020-03-11
598	Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644.	6:47	2020-03-07
599	Free Excel Business Math & Formulas Course at YouTube	1:45	2020-03-05
600	Highline College Assessment by M. Girvin about Microsoft Big Data Tools in the Classroom	3:34	2020-03-02

601	Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643	8:55	2020-02-28
602	Free Excel Basics Course at YouTube	2:03	2020-02-26
603	Free Advanced Excel Course at YouTube	1:39	2020-02-24
604	Free Excel Finance Cash Flow Model Building Course at YouTube	3:11	2020-02-21
605	Free Excel Business Analytics (Statistics & Math) Course at YouTube	1:34	2020-02-19
606	excelisfun YouTube Birthday Party: 12 Years @ YouTube. Feb 15, 2008 – Feb 15, 2020.	1:11	2020-02-15
607	Free Excel for Statistical Analysis in Business & Economics Course at YouTube	1:57	2020-02-13
608	Free Advanced Data Analysis & BI Course at YouTube (MSPTDA)	2:49	2020-02-11
609	Free Excel Data Analysis Basics Course at YouTube (E-DAB)	2:28	2020-02-07
610	Flash Fill, Array Formula or Power Query? To Insert Dash Between Text & Number. EMT 1641	6:45	2020-02-03
611	REPLACE Function to Insert a Dash Into Text. Flash Fill Too. Excel Magic Trick 1639	2:36	2020-01-31
612	Which Lookup Formula is Fastest? Excel Magic Trick 1631 Part 02	2:51	2020-01-29
613	Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634	17:24	2020-01-23
614	Power Query to Insert Dashes into Text. Flash Fill too! Excel Magic Trick 1638	3:44	2020-01-19
615	TEXTJOIN & MID? LEFT, 2 MID, RIGHT? Excel Formulas to Insert Dashes into Text Excel Magic Trick 1637	3:32	2020-01-17
616	Excel Formula for Discounted Sales: Standard Formula or Spilled Arrays? Excel Magic Trick 1636	5:32	2020-01-14
617	Excel FIXED Function Easier than TEXT Function! (DOLLAR Function too). Excel Magic Trick 1635	2:54	2020-01-11
618	Repeat Number Down Column with Excel Formula & Conditional Formatting - Excel Magic Trick 1633	5:14	2020-01-10
619	Dynamic Inventory Running Total Excel SUMIFS Formula Based on Transaction Records (EMT 1632)	4:03	2020-01-07
620	Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631.	9:00	2020-01-03
621	Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629.	10:46	2019-12-30
622	Count NOT “Apple” with Excel Formula & Conditional Formatting - Excel Magic Trick 1630	2:37	2019-12-27
623	Spilled Array Christmas Tree in Excel. Conditional Formatting Christmas Tree. Excel Magic Trick 1628	1:18	2019-12-24
624	MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables	13:23	2019-12-22
625	Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621	15:43	2019-12-20
626	VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627	4:23	2019-12-19
627	Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626)	18:34	2019-12-13
628	Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625	3:46	2019-12-08
629	Double The Records When I Refresh? Power Query Excel.CurrentWorkbook Recursion - EMT 1624	2:03	2019-12-06
630	Repeat Columns in my Power Query Append?? Too Many Columns? Extra Columns? EMT 1623	8:04	2019-12-05
631	Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622)	9:44	2019-11-30
632	Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620	9:32	2019-11-25
633	How To Import Text File into Excel (4 Examples, including Tab & CSV Files) – Excel Magic Trick 1619	3:23	2019-11-22
634	INDEX & MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes (EMT 1618)	12:25	2019-11-15
635	Split Text By Capital Letters in Excel using Power Query EMT 1617	7:58	2019-11-09
636	Bring Excel Sheet Variable Into a DAX Measure (Measure Input From Excel Sheet) EMT 1616	5:53	2019-11-03
637	Bring Excel Sheet Variable Into Power Query (Query Input from Excel Sheet) - EMT 1615	4:58	2019-11-01
638	TEXTJOIN & TEXT Functions working on Multiple Rows or Columns (DOLLAR Function too) EMT 1614	4:41	2019-10-29
639	MSPTDA 35: Power BI & DAX Formula for Data Modeling with a Slowly Changing Dimensions	10:34	2019-10-26
640	MSPTDA 34: Data Modeling for Slowly Changing Dimensions with Power Query & Power Pivot	11:30	2019-10-25
641	Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613	3:47	2019-10-22
642	MSPTDA 33 Part 2: Power Query & Standard PivotTable To Show All Employees Sales Or Not	7:10	2019-10-21
643	Excel Formula for Text Number Label with Lead Zeroes: 010-030, 030-050, 050-070 - EMT 1612	5:24	2019-10-19
644	MSPTDA 33: Data Modeling for Slowly Changing Dimensions with Power Query & PivotTable	12:46	2019-10-17
645	MSPTDA 32: Slowly Changing Dimensions Team-Employee Report with Worksheet Formulas	8:34	2019-10-14
646	XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611	1:50	2019-10-11
647	Extract Top 5 Values with Names with Dynamic Array Formulas & Conditional Formatting – EMT 1610	4:47	2019-10-08
648	excelisfun Flashback Friday 05: Extract Top 5 Values & Names with Array Formula	18:16	2019-10-05
649	excelisfun Flashback Friday 04: Randomized Conditional Formatting Set to 80s Music!?!?!	1:31	2019-10-03
650	Excel Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609	6:08	2019-09-29
651	Dynamic Array & Old Array Formulas to Create Student Classes Report - Excel Magic Trick 1608	7:48	2019-09-26
652	DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607	4:22	2019-09-24
653	List Student Classes in Single Cell – Power Query (From Text File & Parameter Query)- EMT 1606	10:59	2019-09-22
654	Sum Last Digits for All Numbers - Excel Magic Trick 1605	3:27	2019-09-20
655	Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604	3:29	2019-09-19
656	Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603	3:13	2019-09-18
657	Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601	4:14	2019-09-14
658	3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602	3:56	2019-09-14
659	Highline College Busn 218 Class Introduction Video	6:29	2019-09-14
660	Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600	25:02	2019-09-06
661	Extract Customer Names, Not in Master Lists with Power Query - Excel Magic Trick 1599	3:53	2019-09-04
662	Extract Customer Names, Not in Master Lists with Advanced Filter - Excel Magic Trick 1598	5:06	2019-09-02
663	Excel Formula to Extract Items from Two Lists - Excel Magic Trick 1597. Is Item NOT in List?	3:40	2019-08-31
664	Excel Formula to Compare Two Lists - Excel Magic Trick 1596. Is Item in List?	4:33	2019-08-28
665	Array Formula: Filter Rows with List of Does NOT Contain Criteria - Excel Magic Trick 1595	5:52	2019-08-27
666	Advanced Filter: Filter Rows with List of Does NOT Contain Criteria - Excel Magic Trick 1594	4:01	2019-08-25
667	Power Query Filter Rows by NOT Contains Criteria - Single Formula Solution - Excel Magic Trick 1593	8:05	2019-08-23
668	Power Query - Filter Table Based on Distinct NOT Conditions from List - Excel Magic Trick 1592	9:18	2019-08-21
669	One Lookup Value, Return Multiple Items – The Easy Way with FILTER - Excel Magic Trick 1591	1:44	2019-08-19
670	Two Lookup Values for Excel Lookup? FILTER or INDEX? - Excel Magic Trick 1590	2:07	2019-08-17
671	excelisfun Flashback Friday 03: VLOOKUP & Data Validation	4:34	2019-08-16
672	Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589	4:39	2019-08-14
673	Power Query Running Count Based on Row Condition – Excel Magic Trick 1588	7:25	2019-08-13
674	Count Number of Saturdays in Month - 5 Different Formulas!- Excel Magic Trick 1587	8:51	2019-08-11
675	Dynamic Arrays to Increment 1-6, 7-12, 13-18 - SEQUENCE Array Function… - Excel Magic Trick 1586	2:30	2019-08-09
676	Excel Formula to Increment Numbers: 1-6, 7-12, 13-18 for Raffle Ticket - Excel Magic Trick 1585	4:23	2019-08-08
677	Show Formula & Cell Location with Excel Text Formula, Unicode Arrow too - Excel Magic Trick 1584	3:35	2019-08-06
678	Extract Date from End of Description with Excel Worksheet Formula - Excel Magic Trick 1583	1:48	2019-08-04
679	excelisfun Flashback Friday 02: AVERAGE with Zeroes or Blanks? Ctrl + Enter Keyboard	3:11	2019-08-02
680	Extract Data From Cell with Flash Fill - Excel Magic Trick 1582	1:29	2019-08-01
681	Excel Formula to Reverse First & Last Name. Better Than Power Query & Flash Fill? - EMT 1581	3:21	2019-07-31
682	Power Query - Group Suppliers, Join with Line Feed From Multiple Text Files - Excel Magic Trick 1580	9:30	2019-07-30
683	Array Formula - List All Suppliers by Material in Single Cell with Line Feed, Excel Magic Trick 1579	5:52	2019-07-29
684	Excel PivotTable Keyboard? Keyboard for PivotTable –Excel Magic Trick 1578	0:38	2019-07-29
685	Summarize Survey Results with PivotTable in One Minute - Excel Magic Trick 1577	1:01	2019-07-28
686	Power Query M Code Group By Formula to Transform Invoice Table - Excel Magic Trick 1576	7:25	2019-07-26
687	Unique Invoice / Vendor List with Items Listed Horizontally - Excel Dynamic Array Formula- EMT 1575	4:11	2019-07-25
688	OFFSET Function Dynamic Range inside COUNTIFS Function - Excel Magic Trick 1573	4:40	2019-07-24
689	INDEX Function To Lookup Column inside COUNTIFS Function - Excel Magic Trick 1574	2:52	2019-07-24
690	Excel Conditional Format Row, Column & Intersecting Cell - Excel Magic Trick 1572	4:39	2019-07-22
691	Excel’s # 1 Silliest Formula: INDEX or INDIRECT? Excel Magic Trick 1571 (Two Way Lookup Trick)	4:41	2019-07-21
692	Excel Intersection Operator, An Excel Party Trick? - Excel Magic Trick 1570	1:10	2019-07-19
693	Excel Union Operator For Aggregate, Statistical & Finance Functions - Excel Magic Trick 1569	2:40	2019-07-19
694	Excel Two Way Lookup with INDEX & MATCH Functions - Excel Magic Trick 1568	2:32	2019-07-18
695	Excel Two Way Lookup with VLOOKUP & MATCH Functions - Excel Magic Trick 1567	2:40	2019-07-18
696	Excel Keyboard Shortcut to Jump To Formula Bar. Excel Magic Trick 1566.	1:41	2019-07-17
697	Excel Keyboard to Insert Sheet & Rename Sheet. Excel Magic Trick 1565. (Sheet Tab or Worksheet)	0:33	2019-07-17
698	4 Types of Criteria for SUMIFS & COUNTIFS - Excel Magic Trick 1564, SUMIF & COUNTIF too	6:50	2019-07-16
699	Last Working Day Of Month – Excel Formula – Excel Magic Trick 1563	2:51	2019-07-15
700	Excel Formulas & Functions – excelisfun Flashback Friday 01 – Excel Basics	10:54	2019-07-12

701	YouTube Learning Playlists Announcement for excelisfun, July 11, 2019	1:45	2019-07-12
702	Jump To Any Excel Sheet – 7 Methods in One Minute – Excel Magic Trick 1562	1:08	2019-07-10
703	DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561)	11:06	2019-07-09
704	Excel Magic Trick 1560: Half Year Running Totals in PivotTable	5:32	2019-07-08
705	Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales	4:20	2019-07-07
706	Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change	3:27	2019-07-05
707	Keyboard Shortcut to Open Smart Tags in Excel, Word & PowerPoint (Excel Magic Trick 1557)	1:10	2019-07-03
708	Create Column of Month End Dates in Excel - Excel Magic Trick 1556	0:54	2019-07-02
709	Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555	3:32	2019-07-01
710	MSPTDA 31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT?	15:12	2019-06-28
711	Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554	21:48	2019-06-20
712	MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports	10:19	2019-06-14
713	MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas	10:20	2019-06-11
714	Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553	31:16	2019-06-07
715	MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship	17:28	2019-06-02
716	MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships	13:38	2019-05-31
717	Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula: Excel Magic Trick 1552	22:45	2019-05-28
718	MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model	10:51	2019-05-23
719	MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH	6:17	2019-05-23
720	Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND	7:46	2019-05-19
721	MSPTDA 24: DAX Multiply / Divide Data Types Discrepancies Solved!	6:29	2019-05-18
722	MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table	1:04:59	2019-05-15
723	MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations	20:08	2019-05-08
724	MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size	25:13	2019-05-04
725	MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query	11:07	2019-04-27
726	COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550	3:11	2019-04-22
727	COUNTIFS in Power Query? Excel Magic Trick 1549	2:12	2019-04-19
728	Excel Table NOT Automatically Copy Formula Down Column? Option Setting to Fix This. Magic Trick 1548	1:40	2019-04-17
729	Excel Table NOT Automatically Add New Column or Rows? Option Setting to Fix This. Magic Trick 1547	1:10	2019-04-15
730	Power Query Get Previous Row? Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546	12:44	2019-04-10
731	Create Random Data, Variable Height INDEX & RANDARRAY Dynamic Array Function: Excel Magic Trick 1545	6:46	2019-04-08
732	Excel Magic Trick 1544: FILTER Array Function to Filter Between Upper & Lower Text Number Limits	6:20	2019-04-06
733	E-DAB 00: Introduction to Excel Data Analysis & Business Intelligence Class: E-DAB YouTube Class!	1:35	2019-03-30
734	Introduction to People & Canvas Web Sites for Highline College BI 348 Class	6:27	2019-03-30
735	E-DAB-10: Excel & Power BI Together! Import, Publish and Share Reports & Visualizations	14:37	2019-03-27
736	E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations	37:37	2019-03-26
737	E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards	44:42	2019-03-22
738	E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?	45:21	2019-03-16
739	E-DAB 06: The Magic of Power Query to Import, Transform & Load Data	26:40	2019-03-10
740	E-DAB 05: Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards	54:41	2019-03-07
741	E-DAB 04: PivotTables & Slicers Create Dashboards & Summary Reports	28:55	2019-02-27
742	E-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?	29:53	2019-02-24
743	E-DAB 02: Data, Proper Data Sets, Excel Tables, Logical Tests, More	35:27	2019-02-21
744	E-DAB 01: What is Data Analysis & Business Intelligence?	12:42	2019-02-19
745	Excel Magic Trick 1543: MAXIFS & MINIFS to Lookup Numbers on Either Side of Hurdle	3:20	2019-02-16
746	Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?!	7:09	2019-02-15
747	Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS	7:09	2019-02-14
748	Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column	6:00	2019-02-13
749	Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array).	5:46	2019-02-12
750	Excel Magic Trick 1538: Sum Last Digit of Each Cell in Range with SUM or SUMPRODUCT?	5:05	2019-02-11
751	MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples)	1:48:28	2019-02-02
752	Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue	4:39	2019-01-18
753	EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts	10:50	2019-01-15
754	EMT 1535: Average Daily Revenue: SUMIFS with INDIRECT? or SEQUENCE? Inside AVERAGE	8:08	2019-01-13
755	Traditional Arrays or Office 365 Dynamic Arrays? Count Unique Dates Product Was Sold. EMT 1534	7:37	2019-01-09
756	VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function?	7:56	2019-01-06
757	MSPTDA 18: DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI	1:07:00	2018-12-30
758	Count Products Report: Excel? DAX? Power Query? Office 365? Excel Magic Trick 1533	15:38	2018-12-23
759	MSPTDA 17: Power BI Online: Dashboards, Reports, Excel Workbooks, Data Sets.	8:35	2018-12-18
760	VLOOKUP To Get Complete Record: ROWS, COLUMNS or SEQUENCE Function? EMT 1532	8:30	2018-12-15
761	MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing	1:19:35	2018-12-09
762	MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions	2:04:00	2018-11-17
763	Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531)	6:46	2018-11-11
764	Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530)	12:31	2018-11-09
765	Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529)	17:03	2018-11-07
766	Excel Dynamic Arrays & Charts: Spilled Arrays in Charts with Defined Names (Excel Magic Trick 1527)	5:12	2018-11-06
767	Excel Dynamic Arrays: Cross Tabulated Report, Totals Top & Left MMULT Array Function (EMT 1526)	7:29	2018-11-05
768	Excel Dynamic Arrays & Conditional Formatting for Spilled Arrays (Excel Magic Trick 1525)	5:14	2018-11-04
769	Dynamic Spilled Arrays: Show All Formulas For All Columns in Cells as Auditing Trail EMT 1524	4:51	2018-11-02
770	Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523	4:46	2018-11-01
771	VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521)	9:57	2018-10-30
772	Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528	13:02	2018-10-28
773	Dynamic Array Discussions in excelisfun Community Tab: Charts?, Append Totals? Big Data?	3:16	2018-10-27
774	Excel Dynamic Array UNIQUE with INDIRECT To Extract Unique Lists for Each Column (EMT 1522)	4:05	2018-10-26
775	Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520	9:16	2018-10-24
776	Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518	7:44	2018-10-23
777	Excel Dynamic Arrays: Backward Compatibility? Forward Compatibility? What Happens? EMT 1519	6:18	2018-10-23
778	Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)	39:40	2018-10-20
779	Add 2nd Set of Points to Excel X – Y Scatter Chart (Excel Magic Trick 1517)	1:46	2018-10-19
780	MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel	19:09	2018-10-12
781	Excel Magic Trick 1515: Yearly Income Statement Using SUMIFS Function, and NO Merge & Center	6:46	2018-10-08
782	MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report	15:24	2018-10-06
783	MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries	21:19	2018-09-22
784	Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)	1:09:27	2018-09-14
785	MSPTDA 11.5 Which Power Query Steps Are Used in SQL Query Folding? “View Native Query” feature!	3:17	2018-09-12
786	MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop	19:11	2018-09-10
787	Max Consecutive Wins for Best City: Array Formula, Lookup 3-D Model - Excel Hash Competition	16:55	2018-09-04
788	Formula.Firewall Error in Power Query & Power BI: Rebuild This Data Combination Solved (MSPTDA 9.5)	5:22	2018-08-30
789	MSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom Column	29:40	2018-08-28
790	Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula?	5:26	2018-08-25
791	MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More	1:07:27	2018-08-20
792	Excel Magic Trick 1512: Count Workers Employed 1 to 6 Years Based on Hire Date? 9 Examples	14:36	2018-08-10
793	MSPTDA 08.5: Power Query Group By Unique List or Consecutive Occurrences	8:34	2018-08-07
794	Excel Magic Trick 1510: Conditional Format Row With Duplicates Based on Product & Color	9:21	2018-08-05
795	excelisfun Store for Mugs & Shirts	1:44	2018-08-04
796	Excel Hash Iron Chef Tournament: Your Secret Ingredient for #ExcelHash ?	1:19	2018-08-01
797	MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)	30:43	2018-07-30
798	Excel Magic Trick 1511: Array Formula: Get Low Bid From Supplier When Delivery Less Than 20 Weeks	13:28	2018-07-25
799	MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples	37:39	2018-07-22
800	Excel Magic Trick 1509: Conditional Format Array Formula to Highlight Row With 2 Lookup Values	9:49	2018-07-20

801	MSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important Transformations	23:39	2018-07-14
802	MSPTDA 05: Power Query: Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook	27:44	2018-07-12
803	Excel Magic Trick 1508: Lookup In Current Table? Self Join? VLOOKUP or Power Query?	8:43	2018-07-06
804	MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set	32:04	2018-07-04
805	MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop	57:13	2018-06-28
806	MSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis Class	31:26	2018-06-24
807	Microsoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01.	12:13	2018-06-18
808	Excel Magic Trick 1507: Count Empty in Non-Adjacent Cells (5 Examples) AREAS Function?	9:35	2018-06-16
809	Excel Magic Trick 1506: Power Query to Extract All Numbers Listed in Single Cell and Add for Total	6:41	2018-06-13
810	Excel Magic Trick 1504: Lookup Cell Address: 4 Examples: MATCH, ADDRESS, CELL function?	6:23	2018-06-11
811	Excel Magic Trick 1502: Lookup Based On Row Number with Data Validation For Row Number	8:21	2018-06-09
812	Excel Magic Trick 1501 Pt 02: INDIRECT Lookup Items From Different Sheets Based on Row Number	6:11	2018-06-07
813	Excel Magic Trick 1505: Fill Data Automatically in Excel with Magic Fill Handle	1:12	2018-06-05
814	Excel Magic Trick 1501: INDIRECT Function: Pull Data from Different Sheet Based on Row Number	5:49	2018-06-04
815	Excel Magic Trick 1500: Lookup All Products For Supplier & Join in Single Cell TEXTJOIN & IF	5:54	2018-06-01
816	Excel Magic Trick 1503: Free Book Give Away EMT 1493 – 1496 RAND & VLOOKUP Functions	5:43	2018-05-31
817	Excel Magic Trick 1499: VLOOKUP or INDEX Joins to Create Transaction Description (3 Examples)	10:10	2018-05-29
818	Power Query Power BI: Transform 2 Fact Tables to Star Schema Data Model (Invoice Data) EMT 1498	26:10	2018-05-28
819	EMT 1497: Vote For Your Favorite “Allocate Invoice Header Amounts To Transaction Line Table”	1:49	2018-05-24
820	EMT 1495 Part 02: Power Query with Group By Rows: Allocate Invoice Amounts To Line Item Table	17:40	2018-05-22
821	EMT 1496: Power BI Desktop: Allocate Invoice Header Amounts To Transaction Line Item Table	18:47	2018-05-19
822	EMT 1495: Power Query: Allocate Invoice Header Amounts To Transaction Line Item Table	20:38	2018-05-16
823	EMT 1494: DAX & Power Pivot: Allocate Invoice Header Amounts To Invoice Transaction Line Table	23:16	2018-05-14
824	EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Table	15:37	2018-05-12
825	EMT 1493: Excel Formulas PivotTable: Allocate Invoice Header Amounts To Transaction Line Table	21:40	2018-05-10
826	DAX Approximate Match Lookup Part 2: Foreign Key & Relationship or LOOKUPVALUE? EMT1492	13:03	2018-05-08
827	DAX Approximate Match Lookup & Exact Match Lookup Together for Discounted Product Price (EMT 1490)	20:02	2018-05-06
828	Excel Magic Trick 1491: “Lookup Latest Product Price” Survey Results, Winner of Free Book	4:03	2018-05-04
829	Excel Magic Trick 1489: 2 VLOOKUP in 1 Formula: Lookup Correct Volume Discount Product Price	8:56	2018-05-02
830	Excel Magic Trick 1488: Vote For Favorite Formula to Lookup Correct Price Based on Effective Date	4:07	2018-04-30
831	Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date	13:03	2018-04-27
832	Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date	8:09	2018-04-26
833	Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date	9:32	2018-04-22
834	Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date	8:45	2018-04-20
835	Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date	13:35	2018-04-18
836	Excel & Business Math 45: Future Value, Present Value and Periodic Payments for Annuities	51:23	2018-04-13
837	Excel & Business Math 44: What is Present Value? Calculate Present Value Of Lump Sum Amount.	23:21	2018-04-10
838	Excel & Business Math 43: Compound Interest Calculating Future Value of a Lump Sum FV Excel Function	55:31	2018-04-07
839	Free Excel Education for the World at the excelisfun Channel at YouTube!	2:35	2018-04-06
840	Excel Magic Trick 1482: SUMPRODUCT, DCOUNTA or SUM & IF for Counting with OR Logical Test	20:12	2018-04-04
841	Excel & Business Math 42: Simple Interest Calculations & Short Term Loans	33:56	2018-04-01
842	Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too	11:39	2018-03-25
843	Excel Magic Trick 1480: VLOOKUP & MATCH Two-Way Lookup Quantity & Product to Get Price	7:51	2018-03-22
844	Welcome to the excelisfun Channel at YouTube	1:31	2018-03-20
845	Excel Magic Trick 1479: Lookup Bulk Quantity Discount Prices Using VLOOKUP Function	10:54	2018-03-16
846	Excel & Business Math 41: Markup On Cost or Markup On Sell Price? Calculate & How They Are Different	24:37	2018-03-16
847	Excel & Business Math 40: Partial Payment on Invoice with Cash Discount, Credit to Account Balance?	11:31	2018-03-15
848	Excel & Business Math 39: Create Excel Invoices, Data Validation Drop-down, VLOOKUP & IF Functions	30:32	2018-03-14
849	Excel & Business Math 38: Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions	1:04:44	2018-03-11
850	Excel & Business Math 37: Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost	36:30	2018-03-09
851	Excel & Business Math 36: Comprehensive Excel Payroll Example: SUMIFS, MROUND, MOD, VLOOKUP & More	28:44	2018-03-02
852	Excel & Business Math 35: VLOOKUP & MAX Functions for Percentage Method Federal Income Tax Deduction	29:36	2018-03-01
853	Excel & Business Math 34: MEDIAN Function for FICA Social Security & Medicare Payroll Deductions	38:58	2018-02-27
854	Excel & Business Math 33: VLOOKUP Function for Incentive Pay: Commissions & Piecework (15 Examples)	1:21:14	2018-02-25
855	Excel & Business Math 32: Rounding Time Calculations to Nearest 5 or 15 minutes using MROUND	15:31	2018-02-22
856	Excel & Business Math 31: Night Shift Hours Worked Formula for Payroll Time Sheet (3 Examples)	20:44	2018-02-22
857	Excel & Business Math 30: Payroll Time Sheets, IF Function, Sheet Reference for Overtime & Gross Pay	21:43	2018-02-21
858	Excel & Business Math 29: Time Number Formatting & Time Calculations in Excel for Payroll Table	19:59	2018-02-20
859	Excel Magic Trick 1478: Conditional Format Row When Event Code is a Duplicate AND Task = "Special"	8:11	2018-02-19
860	Excel Magic Trick 1477: COUNTIFS & AND Functions for Duplicate Event Codes AND Task = "Special"	4:53	2018-02-17
861	Excel & Business Math 28: IF Function, IS Functions & Building a Check Register Other IF Tricks too	31:42	2018-02-16
862	Excel & Business Math 27: Bank Reconciliation Made Easy	45:22	2018-02-15
863	Excel & Business Math 26: Is Rate of Change Same for Increase by $10 and Decrease by $10?	2:48	2018-02-13
864	Excel & Business Math 25: Percentage Formulas to Help Calculate a Budgeted Forecast for Next Year	8:52	2018-02-12
865	Excel & Business Math 24: COUNTIFS Function & Part/Base for Probabilities & Frequency Distributions	24:33	2018-02-10
866	Excel & Business Math 23: Important Formulas for Increase Decrease Problems (8 Awesome Examples)	1:00:11	2018-02-07
867	Excel Magic Trick 1476: SUMIFS to Add Expenses for Any Time Period (Adding with Three Conditions)	8:42	2018-02-04
868	Excel & Business Math 22: Rate Formula for Common Size Income Statement using Mixed Cell Reference	18:18	2018-02-04
869	Excel & Business Math 21: Percent Formulas & Business Math Word Problems	14:53	2018-02-03
870	Excel & Business Math 20: Percent Formulas for Part, Rate & Base (8 Example)	32:54	2018-02-02
871	Excel & Business Math 19: Round a Percent using ROUND Function & Rate of Change Formula	17:06	2018-01-30
872	Excel & Business Math 18 Percents & Percentage Number Formats (including Fractional Percents)	37:45	2018-01-29
873	Excel & Business Math 17: Solve Fractional Business Math Problems using Excel	12:40	2018-01-26
874	Excel & Business Math 16: Fun With Adding & Subtracting Fractions & Least Common Denominator	33:02	2018-01-26
875	Excel & Business Math 15: Multiplying and Dividing Fractions By Hand & In Excel	8:53	2018-01-25
876	Excel & Business Math 14: Convert Decimal To Fraction & Convert Fraction To Decimal	21:18	2018-01-25
877	Excel & Business Math 13: Mixed Number to Improper Fraction, Improper Fraction to Mixed Number	14:43	2018-01-24
878	Excel & Business Math 12: Reducing Fractions, Prime Factors and Understanding & Calculating Ratios	36:01	2018-01-24
879	Excel & Business Math 11: Types Of Fractions & Fraction Number Formatting	21:48	2018-01-22
880	Excel & Business Math 10: Division, Fractions, Decimals, Percentages: Number Formatting & Formulas	32:24	2018-01-18
881	Excel & Business Math 09: Five Steps to Solve Math Word Problems in Excel	52:40	2018-01-17
882	Excel & Business Math 08: Arithmetic Tips for Add, Subtract, Multiply, Divide, Exponents, Rounding	55:37	2018-01-13
883	Excel & Business Math 07: Style Formatting Format Painter, Mini Toolbar, Styles, Clear Format & More	24:11	2018-01-09
884	Busn 135: Business Math & Excel Introductory Video	17:57	2018-01-07
885	Excel & Business Math 06: All About Excel Formulas (17 Examples) for Business Math Class	47:07	2018-01-06
886	Excel & Business Math 05: Number Formatting & When You MUST Use ROUND Function	32:42	2018-01-04
887	Excel & Business Math 04: Excel Built-in Functions, Data Types and Keyboards are Fast!	34:06	2018-01-02
888	Excel Magic Trick 1475: Power Query, Formula, Flash Fill: "1-PSD/AFX-12" into "12-AFX/PSD-1"	10:59	2017-12-31
889	Excel & Business Math 03: Excel's Golden Rule: Formula Inputs, What If Analysis and Excel Models	30:10	2017-12-29
890	Excel & Business Math 02: Copying Formulas with Relative & Absolute Cell References	10:27	2017-12-28
891	Excel Magic Trick 1473: Sequential Number Incrementor for Just The Middle Number: AA-0009-17	7:41	2017-12-27
892	Excel Magic Trick 1474: Excel Twinkling Christmas Tree With Star & Formulas as Presents!	2:06	2017-12-25
893	Excel Magic Trick 1472: Count Between (or Above and Below) Upper & Lower Limits (7 Examples)	22:14	2017-12-22
894	Excel & Business Math 01: Introduction to Excel. Why We Use Excel for Math. First Formula.	39:00	2017-12-20
895	Excel Magic Trick 1471: Array Formula: Add Daily Rainfall 5 AM to 5 AM Next Day: (Most Automatic)	37:16	2017-12-13
896	Excel Magic Trick 1470: Power Query (Get & Transform) Add Daily Rainfall 5 AM to 5 AM Next Day	20:38	2017-12-11
897	Excel Magic Trick 1469: Add Daily Rainfall 5 AM to 5 AM Next Day: Helper Column & PivotTable	9:24	2017-12-09
898	Office 2016 Video #42: Access 2016: Export Tables, Queries & Reports to Excel, PDF or Text File	7:06	2017-12-07
899	Office 2016 Video #40: Access 2016: Building Queries in Access (15 Examples)	38:10	2017-12-05
900	Office 2016 Video #41: Access 2016: Report Wizard to Create Reports Based on Queries	13:07	2017-12-05

901	Office 2016 Video #39: Access 2016: Create Database, Tables & Relationships, Import Excel Table too	41:18	2017-12-02
902	Office 2016 Video #38: Introduction to Databases & Access	30:47	2017-11-30
903	Excel Basics 25: Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set	30:54	2017-11-26
904	Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!!	34:34	2017-11-23
905	Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data	30:08	2017-11-21
906	Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)	21:35	2017-11-20
907	Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later	4:26	2017-11-20
908	Mr Excel & excelisfun Trick 190 Inventory w Subtotal, MINIFS, Power Pivot, AGGREGATE, or Power Query	17:35	2017-11-19
909	Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As	39:50	2017-11-17
910	Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria	35:16	2017-11-16
911	Excel Basics 18: Defined Names in Excel Formulas & Functions & For Jump Go To!	10:45	2017-11-13
912	Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting	18:03	2017-11-13
913	Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!!	45:08	2017-11-12
914	Mr Excel & excelisfun Trick 189: VLOOKUP for Missing Values in Column	9:06	2017-11-11
915	Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more!	36:47	2017-11-09
916	Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier!	40:08	2017-11-08
917	Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!	54:08	2017-11-05
918	Mr Excel & excelisfun Trick 188: Sales Team Region Report: 5 Different Amazing Methods	16:02	2017-11-04
919	Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples	43:24	2017-11-02
920	Excel Basics 11: Search for Excel Functions & get help with Function Arguments	17:05	2017-10-31
921	Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations	39:54	2017-10-29
922	Mr Excel & excelisfun Trick 187: SUMIFS to add only Filtered Columns, NOT Hidden Rows	12:25	2017-10-27
923	Excel Basics 9: Number Formatting as Façade & the ROUND Function	28:50	2017-10-26
924	Excel Basics 8: Default Data Alignment In Excel & How it Can Help	9:25	2017-10-25
925	Excel Basics 6: Customize Quick Access Toolbar (QAT) and Show New Ribbon Tabs	10:18	2017-10-25
926	Excel Basics 7: Keyboard Shortcuts Are Fast!	8:16	2017-10-25
927	Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts	20:20	2017-10-24
928	Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)	33:26	2017-10-22
929	Mr Excel & excelisfun Trick 186: Does Text Contain Number Digits? Flash Fill, Formula or VBA?	12:23	2017-10-20
930	Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)	21:07	2017-10-19
931	Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts	37:50	2017-10-18
932	Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup	1:02:55	2017-10-14
933	Office 2016 Video #12: Create PowerPoint Presentation With Pictures, Links and Videos	34:09	2017-10-12
934	Office 2016 Video #11: Create Folders To Organize Your Files	5:54	2017-10-11
935	Office 2016 Video #10: Word Styles, Table of Contents & Send to PowerPoint (Intro To PowerPoint)	22:29	2017-10-11
936	Office 2016 Video #09: Bulleted, Numbered and Multileveled Lists, List Styles	12:26	2017-10-10
937	Office 2016 Video #05.5: Saving Files to Correct Folders in Busn 216	1:59	2017-10-10
938	Office 2016 Video #08: Create Research Paper in Word	38:56	2017-10-09
939	Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)	50:06	2017-10-06
940	Office 2016 Video #07: Create a Resume in Word	25:45	2017-10-05
941	Office 2016 Video #06: Business Letter, Letterhead, Save As Template (Much More)	24:41	2017-10-04
942	Office 2016 Video #05: Create Ad Flyer In Word, Create pdf and web page files with Save As	30:53	2017-10-01
943	Office 2016 Video #04: Introduction to Word 2016: 20 Important Tips for Efficiency	39:20	2017-09-30
944	Excel Magic Trick 1467: COUNTIFS or SUMPRODUCT for Complex Counting Formula? (3 Examples)	27:03	2017-09-28
945	Excel Magic Trick 1466: Formulas For Start of Month & Number Days in Month From Any Date	3:16	2017-09-28
946	Introduction to Busn 216 Computer Applications for Business People & Canvas Web Sites	21:44	2017-09-26
947	Office 2016 Video #03: Build Logical System of Folders to Manage Files	19:26	2017-09-26
948	Office 2016 Video #02: Windows Explorer for File Management	25:47	2017-09-23
949	Office 2016 Video #01: Introduction to Office 2016 & Windows Explorer	42:19	2017-09-22
950	Excel Magic Trick 1465: Conditional Formatting Holiday Dates with Red Fill & Word "Holiday"	9:27	2017-09-20
951	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
952	Excel Magic Trick 1463: Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA	5:59	2017-09-12
953	Excel Magic Trick 1462: 5,000 Formulas in a Single Cell with SUMPRODUCT or Array Formula?	12:21	2017-09-09
954	Excel Magic Trick 1461: Ctrl + Enter or Ctrl + D, What is the Difference and When to Use Each?	4:08	2017-09-03
955	Excel Magic Trick 1460: List All Relative Positions in a Single Cell using TEXTJOIN Array Formula	12:24	2017-09-01
956	Excel Magic Trick 1459: Adding Food or Accessory Costs For Each Dog with SUMIFS & SUMPRODUCT	7:09	2017-08-30
957	Excel Magic Trick 1457 Part 2: Regional Settings & Text or Number Date / Times in SUMIFS Function	3:21	2017-08-29
958	Excel Magic Tick 1458: Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names	13:05	2017-08-28
959	Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Examples)	16:08	2017-08-23
960	Excel Magic Trick 1456: PivotTable & Slicer to Create 8 Year Sales Report by Product & Month	4:35	2017-08-21
961	Excel Magic Trick 1455: Convert Text Month Criteria to Upper & Lower Dates for SUMIFS Function	10:35	2017-08-15
962	Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month	10:30	2017-08-11
963	Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month	13:46	2017-08-09
964	Excel Magic Trick 1452: Max Monthly Customer Total for Year: Array Formula or PivotTable?	16:56	2017-08-06
965	Excel Magic Trick 1451: Hack Data Model, Date Table & DAX Measures WITHOUT buying Power Pivot	35:56	2017-08-03
966	Excel Magic Trick 1450: Replace VLOOKUP When Making PivotTables with Excel 2016 Relationships	10:20	2017-07-31
967	Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years	22:36	2017-07-24
968	Power BI for Accountants: Complete Introduction to Power BI Desktop to Build Reports & Dashboards	40:45	2017-07-20
969	Excel for Accountants: Power Query & PivotTables to Import & Clean Data and Build Reports	51:24	2017-07-12
970	Excel for Accountants: Formulas, Functions & Formatting to Build Account Templates (37 Examples)	1:37:02	2017-07-10
971	Excel Magic Trick 1447: DAX DISTINCTCOUNT & CONCATENATEX to Count & List Stores Visited	6:20	2017-07-09
972	Mr Excel & excelisfun Trick 185: Get Text Between First & Last Dash: 4 Methods	14:25	2017-07-07
973	Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups	27:23	2017-07-06
974	Excel Magic Trick 1448: Conditional Formatting Formulas: Cell References To “Jump” To Next Template	15:43	2017-07-04
975	Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups	18:09	2017-07-02
976	Excel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups	7:44	2017-07-02
977	Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups	30:33	2017-07-01
978	The Magic of Excel: Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & more!!	1:01:43	2017-06-27
979	Excel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop	21:12	2017-06-23
980	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
981	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
982	excelisfun Posts 31 Videos in the Month of May, 2017! Vacation Time : )	1:25	2017-06-02
983	Excel Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function	16:16	2017-05-31
984	Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total	6:52	2017-05-30
985	Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total	6:07	2017-05-29
986	Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet	8:00	2017-05-28
987	Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot	7:05	2017-05-27
988	Excel Magic Trick 1435: DAX Query to Export Data from Data Model to Excel Sheet & Much More!	17:49	2017-05-26
989	Excel Magic Trick 1434: SAMPLE DAX Function to Take Random Stratified Sample from Data Set.	12:12	2017-05-26
990	Excel Magic Trick 1433: Materialize DAX Table Functions: Existing Connections, DAX Studio, Power BI?	20:15	2017-05-24
991	Excel Magic Trick 1432: 9 DAX Formulas to Build Confidence Intervals CONFIDENCE.T, STDEV.S…	19:53	2017-05-23
992	Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR	9:45	2017-05-22
993	Excel Magic Trick 1431: XNPV, OFFSET & VLOOKUP to Get Dates & Cash Flows for NPV & IRR Calculations	13:37	2017-05-22
994	Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc	12:14	2017-05-20
995	Excel Magic Trick 1428: VLOOKUP, COUNTIFS & IF Helper Column to Calculate Asset Current Value	7:03	2017-05-20
996	Excel Magic Trick 1429: Power Query Ranking with Index, Grouping and MIN Function!!!	5:41	2017-05-19
997	Excel Magic Trick 1426: Lookup Row & Column Headers From 2-Way Lookup Table with Unique Values	12:09	2017-05-18
998	Excel Magic Trick 1425: Convert 2-Way Table to Single Column Table with INDEX & Number Incrementor	7:03	2017-05-18
999	Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas?	28:07	2017-05-17
1000	Excel Magic Trick 1423: Power Query Number.ToText Function to Format Numbers as Text	9:15	2017-05-16

1001	Excel Magic Trick 1422: Power Query M Code: Join all Items From Invoice into One Cell	4:33	2017-05-16
1002	Excel Magic Trick 1421: Get Help for Power Query Functions	2:22	2017-05-16
1003	Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns	12:51	2017-05-14
1004	Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer	27:06	2017-05-12
1005	Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer	14:28	2017-05-11
1006	Excel Magic Trick 1417 Excel Functions Ranking Unit & Total Profit for Products within Manufacturer	12:10	2017-05-09
1007	Excel Magic Trick 1416: Round Up to 15 or 30 Minute Increments for Hours Worked Time Calculations	11:17	2017-05-08
1008	Excel Magic Trick 1415: Power Query Lookup and Return Multiple Items And Join Them In Single Cell	13:38	2017-05-07
1009	Excel Magic Trick 1414: Power Query Text.PadStart Function to Correctly Format Account Numbers	6:07	2017-05-06
1010	Mr Excel & excelisfun Trick 183: Lookup and Return Multiple Items And Join Them In Single Cell	11:00	2017-05-05
1011	Excel Magic Trick 1413: Set Default Layout in a PivotTable (New in Excel 2016, Office 365)	3:17	2017-05-03
1012	Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report	6:56	2017-05-02
1013	Excel Magic Trick 1411: Power Query Add Prefix to Account Numbers in Column	0:46	2017-05-01
1014	Excel Magic Trick 1410: Calculate Closing Balance for Each Month from Balance Transaction Table	10:40	2017-04-30
1015	Excel Magic Trick 1409: Build PivotTable From 2 Tables without Power Pivot or VLOOKUP	7:54	2017-04-29
1016	Mr Excel & excelisfun Trick 182: Split Text, But Only at First Space (4 Methods)	9:26	2017-04-28
1017	Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar	2:22:28	2017-04-24
1018	Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too)	14:01	2017-04-22
1019	Mr Excel & excelisfun Trick 181: Month To Date: PivotTable or Excel Formulas?	13:18	2017-04-21
1020	Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables	12:46	2017-04-19
1021	Excel Magic Trick 1406: Calculate Moving Average with AVEARGEIFS & EOMONTH Functions	7:05	2017-04-17
1022	Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report	13:34	2017-04-15
1023	Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records	5:26	2017-04-15
1024	Mr Excel & excelisfun Trick 180: Extract Varying Dates From Description	14:48	2017-04-14
1025	Excel Magic Trick 1402 Part 5: Conditional Formatting to Show Check Mark When Number Bigger Than 0	2:21	2017-04-11
1026	Excel Magic Trick 1403: DAX Formulas: Explicit or Implicit Measures? Why Explicit is Better.	11:22	2017-04-08
1027	Excel Magic Trick 1402 Part 4: UNICHAR & UNICODE Functions for Unicode Value	4:43	2017-04-07
1028	Excel Magic Trick 1402 Part 3: Power Query to Put Check Mark In Cell If Number Greater Than 0	5:59	2017-04-06
1029	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
1030	Excel Magic Trick 1402: Formula to Put Check Mark In Cell If Number Greater Than Zero	6:05	2017-04-04
1031	Excel Magic Trick 1401: Conditionally Format Row For BOLD Date	7:27	2017-04-03
1032	Excel Magic Trick 1400 Part 2: Conditionally Format Row with Complex Criteria (3 More Examples)	19:34	2017-04-02
1033	Excel Magic Trick 1400: Conditionally Format Row in Class Enrollment Table with Complex Criteria	10:51	2017-03-31
1034	Excel Magic Trick 1399: Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula	3:54	2017-03-29
1035	Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks	41:14	2017-03-27
1036	Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments	12:47	2017-03-26
1037	Excel Magic Trick 1397 Part 2: Formulas: Monthly Revenue, Running Total & % Running Total & Chart	12:12	2017-03-25
1038	Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart	19:28	2017-03-23
1039	Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)	11:08	2017-03-21
1040	Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total	34:41	2017-03-18
1041	Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item	5:13	2017-03-17
1042	Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total	16:33	2017-03-16
1043	Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total	7:34	2017-03-14
1044	Excel Magic Trick 1392: Case Sensitive Unique Count: Power Query or Data Model PivotTable?	3:56	2017-03-12
1045	Excel Magic Trick 1391: Case Sensitive VLOOKUP? 5 Examples of Excel Case Sensitive Lookup	14:35	2017-03-10
1046	Excel Magic Trick 1390: Average Number of Days Between Dates in a Single Column 3 Examples	5:20	2017-03-09
1047	Excel Magic Trick 1389: Average Number of Days Between Two Columns of Dates	2:42	2017-03-07
1048	Excel Magic Trick 1388 Average Number of Days Between Order & Ship Date (Basic Array Formula Lesson)	12:03	2017-03-06
1049	Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & Country	28:32	2017-03-02
1050	Excel Magic Trick 1386: Power Query to Import & Append Large Text File in Power Pivot Data Model	6:15	2017-03-01
1051	Excel Magic Trick 1385: Import Tables from SQL Server Database into Power Pivot or PBI Data Model	5:46	2017-02-28
1052	Excel Magic Trick 1384: Import Excel Table or Sheet in Power Query or Power BI?	4:00	2017-02-27
1053	Excel Magic Trick 1383: Conditional Format Row w OR Logical Test with Multiple Partial Text Criteria	14:10	2017-02-24
1054	Excel Magic Trick 1382: Extract Records With Multiple Contains (Partial Text) Criteria: 4 Examples	38:13	2017-02-22
1055	Excel Magic Trick 1381: Power Query: Records In Column into Table then Two Different Top 3 Reports	20:43	2017-02-18
1056	Excel Magic Trick 1380: Slicer Power Query Report To Show Incomplete Student Assignments	8:57	2017-02-16
1057	Excel Magic Trick 1379: Power Query Combine Binary "Expand Button" Update January 2017	7:07	2017-02-14
1058	Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?	29:29	2017-02-11
1059	Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & More	18:52	2017-02-09
1060	Excel Magic Trick 1376: Complex VLOOKUP Formula To Create Transaction Description	16:54	2017-02-04
1061	Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples)	55:04	2017-01-31
1062	Excel Magic Trick 1374: Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function	7:05	2017-01-29
1063	Excel Magic Trick 1373: Formula to Extract Every Nth Value & Conditionally Format Every Nth Value	12:54	2017-01-27
1064	Excel Magic Trick 1372: Extract Only Total Row For Each Name: Formula or Power Query (6 Examples)	18:24	2017-01-25
1065	Excel Magic Trick 1371: Excel Formula To Add Last Five Values in an Excel Table: INDEX Dynamic Range	7:28	2017-01-22
1066	Excel Magic Trick 1370 INDEX Function & Number Incrementor Extract Items & Display In Every 3rd Cell	9:27	2017-01-19
1067	Excel For Accountants: VLOOKUP & PivotTables Complete Lessons: Basic to Advanced: CWU Seminar	1:32:45	2017-01-12
1068	Excel Magic Trick 1369: COUNTIFS To Count Not Empty Cells With 4 Criteria/Conditions	9:42	2017-01-09
1069	Power BI Desktop: DAX CALENDAR Function to Create Calendar / Date Table (Excel Magic Trick 1367)	17:40	2017-01-07
1070	Excel Magic Trick 1368: How To get SUMIFS to Calculate Sum Of Amazon And Google Under Each Region	7:54	2017-01-05
1071	Power BI Desktop: Build Data Model, Get Data, DAX Formulas, Visualizations, Publish 2 Web (EMT 1366)	1:12:07	2016-12-31
1072	Import Power Pivot Data Model into Power BI Desktop (Excel Magic Trick 1365)	3:36	2016-12-30
1073	How to Use Images in a Power BI Desktop Report from Picture Web URL (Excel Magic Trick 1364)	4:51	2016-12-29
1074	Excel Magic Trick 1363: Images in Power View Report from Web URL stored in Power Pivot Data Model	6:50	2016-12-28
1075	Turn on Power View in Excel 2013 / 2016 for Windows (Excel Magic Trick 1362)	2:23	2016-12-28
1076	Sparkling Christmas Tree in Excel! Build Conditional Format Christmas Tree: Excel Magic Trick 1361	2:24	2016-12-25
1077	Comprehensive Power BI Desktop Example: Visualize Excel Data & Build Dynamic Dashboard (EMT 1360)	30:35	2016-12-23
1078	Excel Magic Trick 1359: Split Times Values Into 8 Equal Zones: VLOOKUP, LOOKUP or INT/HOUR?	17:10	2016-12-21
1079	Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Files	18:43	2016-12-10
1080	Excel Magic Trick 1358: Query Dependencies View in Power Query (Get & Transform)	1:34	2016-12-08
1081	Excel Magic Trick 1356: Lookup 3 Items & Return to Single Cell Helper Column or Power Query?	11:46	2016-12-08
1082	Excel Magic Trick 1355 Extract Data at each Bold Font, Display Horizontally: GET.CELL Macro Function	25:26	2016-12-06
1083	Excel Magic Trick 1354: Rank with Criteria: Rank Football Teams by Total Wins & Division Wins	6:15	2016-12-04
1084	Excel Magic Trick 1353: Power Query: Extract Records w Merge Feature & Inner Join on Parameter Table	12:23	2016-12-02
1085	Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?	18:07	2016-11-30
1086	Excel Magic Trick 1351: Power Query: Merge Text & Excel Files, Custom Columns, Total Row & Slicer	21:20	2016-11-29
1087	Excel Magic Trick 1350: Formulas in PivotTables For Gross Profit & Percentage of Gross Profit	8:21	2016-11-26
1088	Excel Magic Trick 1348: Lookup Adding: Exact Match or Approximate Match (SUM Many VLOOKUPs)	13:32	2016-11-23
1089	Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records	18:02	2016-11-21
1090	Excel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each Product	21:05	2016-11-18
1091	Excel Magic Trick 1346: Array Formula: Split Master Table into Sub Tables, Each Product on New Sheet	22:05	2016-11-17
1092	Excel Magic Trick 1345: Conditionally Format Product Name for No Items Entered in Row (4 Methods)	6:29	2016-11-15
1093	Excel Magic Trick 1344: Conditional Formatting the Entire Row in an Excel Table: Totally Dynamic!!	6:02	2016-11-13
1094	Excel Magic Trick 1343: Wrap Text in a Formula: Create Chart Labels with Two Lines	5:23	2016-11-12
1095	Excel Magic Trick 1342: Adding Column That Contains Errors SUMIF or AGGREGATE?	7:20	2016-11-10
1096	Excel Magic Trick 1341: Standard Deviation with Criteria: Power Query, PivotTable, or Array Formula?	26:24	2016-11-07
1097	Excel Magic Trick 1340: Create Expandable Range in an Excel Table (2 Methods)	6:38	2016-11-05
1098	Excel Magic Trick 1339: Create Alphabet A – Z: Formula, Power Query, or Custom List?	10:31	2016-11-04
1099	Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set	24:00	2016-10-31
1100	Excel Magic Trick 1337: No X-Y Scatter Chart From PivotTable!?!? Use Power Query Instead!!!	7:59	2016-10-29

1101	Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model?	11:35	2016-10-27
1102	Excel Magic Trick 1335: Power Query We Couldn’t Refresh The Connection Data Source Not Found Error	1:43	2016-10-27
1103	Excel Magic Trick 1334: Power Query or Formula: Lookup Name Based on Max Value and more…	14:14	2016-10-25
1104	Excel Magic Trick 1333: Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding	10:31	2016-10-23
1105	Excel Magic Trick 1332: Power BI Desktop: Import Multiple Excel Files & Build Dashboard	15:23	2016-10-19
1106	Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform	29:48	2016-10-16
1107	Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transform)	28:34	2016-10-13
1108	Excel Magic Trick 1329: Clean Data Then Add w 2 Criteria: SUMIFS or Power Query (Get & Transform)?	12:33	2016-10-12
1109	Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transform)	6:55	2016-10-09
1110	Excel Magic Trick 1327: Formula to Count Words in Column with Mixed Data: COUNTIFS Function	4:21	2016-10-07
1111	Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query?	24:51	2016-10-04
1112	Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples)	31:55	2016-09-24
1113	BI 348 Intro Video for our Canvas & People Web Sites	8:30	2016-09-22
1114	Busn 218 Intro Video for our Canvas & People Web Sites	6:46	2016-09-20
1115	Busn 135: Dont Watch Videos In Canvas	1:25	2016-09-20
1116	Excel Magic Trick 1324: ROWS or COUNTIFS Incrementor in Array Formula to Extracting Records?	19:21	2016-09-16
1117	Blue Cover (3rd Printing) Ctrl + Shift + Enter: Mastering Excel Array Formulas Book at mrexcel.com	1:11	2016-09-15
1118	Excel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation	5:46	2016-09-14
1119	Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL?	30:37	2016-09-13
1120	Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods)	26:42	2016-09-11
1121	Excel Magic Trick 1320: Distinct/Unique Count with 1 Condition using Power Query (Get & Transform)	6:13	2016-09-07
1122	Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables.	5:07	2016-09-06
1123	Excel Magic Trick 1317: Formulas for Total Insulin Units… And Excel’s Golden Rule & MAX Replaces IF	8:03	2016-09-05
1124	Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula?	12:38	2016-09-03
1125	Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE?	15:52	2016-08-31
1126	PivotTables & Slicers Made Easy! 4 Amazing Examples for WAAT Accounting Seminar August 26, 2016	35:38	2016-08-24
1127	10 Amazing Excel Lookup Formulas for WAAT Accounting Seminar August 26, 2016, VLOOKUP & More	1:01:03	2016-08-24
1128	Excel Magic Trick 1315: Create A Unique Sorted List with Power Query	4:16	2016-08-22
1129	Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data	15:51	2016-08-17
1130	Excel Magic Trick 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN.	20:54	2016-08-10
1131	Excel Magic Trick 1312: Count The Number Of Mondays & Tuesdays Since Birth: NETWORKDAYS.INTL	8:25	2016-08-09
1132	Excel Magic Trick 1311: Return Multiple Items from One Lookup Value & Show Total for Invoice Items	7:11	2016-07-25
1133	Excel Magic Trick 1310: Minimum Value Greater Than Zero with: 1) SMALL & COUNTIFS, 2) LARGE?	3:23	2016-07-24
1134	Excel Magic Trick 1309: Extract Unique List and List in Single Cell: TEXTJOIN Array Formula	9:42	2016-07-22
1135	Excel Magic Trick 1308: Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN	2:26	2016-07-21
1136	Excel Magic Trick 1307: Conditionally Format Multiple Non-Adjacent Cells in Cross Tabulated Table	9:00	2016-07-20
1137	Highline Excel 2016 Class 26: Macro Recorder Basics & Copying VBA Code From Internet	40:55	2016-07-18
1138	Excel Magic Trick 1306: Simulate VLOOKUP Helper Column In Array Formula using T(IF({1},Array) Trick	10:40	2016-07-17
1139	Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trick	7:12	2016-07-17
1140	Excel Magic Trick 1304: List Text Modes in Single Cell TEXTJOIN, INDEX, N, IF, MATCH & MODE.MULT	6:14	2016-07-15
1141	Excel Magic Trick 1303: Minimum Value Greater Than Zero (3 Examples)	6:04	2016-07-15
1142	Excel Magic Trick 1302: List Text Modes in Single Cell with TEXTJOIN, HLOOKUP, MATCH & MODE.MULT	6:36	2016-07-13
1143	Excel Magic Trick 1301: Sorted List of Modes in Single Cell with TEXTJOIN Array Formula	7:35	2016-07-11
1144	Excel Magic Trick 1300: List All Modes in Single Cell with TEXTJOIN & MODE.MULT	4:21	2016-07-10
1145	Highline Excel 2016 Class 24: Financial Functions: PMT, RATE, NPER and FV 12 Examples	41:06	2016-07-07
1146	Highline Excel 2016 Class 25: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more…	8:34	2016-07-07
1147	Highline Excel 2016 Class 23: Intro to Power BI Desktop to Create Data Model & Visualization	24:29	2016-07-01
1148	Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New in Excel 2016	3:47	2016-07-01
1149	Excel Magic Trick 1298: Group By Date in Power Pivot Data Model, New in Excel 2016	2:49	2016-07-01
1150	Highline Excel 2016 Class 22: How To Build Data Model & DAX Formulas in Power Pivot	1:04:43	2016-06-23
1151	Highline Excel 2016 Class 21: Power Query Import Multiple Excel Workbooks with Multiple Sheets	9:06	2016-06-10
1152	Highline Excel 2016 Class 20: Power Query Import Multiple Excel Files & PivotTable Show Values As	24:01	2016-06-08
1153	Highline Excel 2016 Class 19: Transform Data Sets using Advanced Filter (8 Examples)	33:42	2016-06-04
1154	Highline Excel 2016 Class 18: Clean & Transform Data: Replace, Flash Fill, Text To Columns, Formulas	24:14	2016-06-03
1155	Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting	36:16	2016-05-27
1156	Highline Excel 2016 Class 16: Conditional Formatting to Visualize Data: Built-in & Logical Formulas	44:21	2016-05-23
1157	Highline Excel 2016 Class 15: Excel Charts to Visualize Data: Comprehensive Lesson 11 Chart Examples	52:27	2016-05-20
1158	Highline Excel 2016 Class 14: VLOOKUP as Relationship in Power Pivot Data Model & Vice Versa	8:02	2016-05-17
1159	Highline Excel 2016 Class 13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE	9:03	2016-05-17
1160	Highline Excel 2016 Class 12: Two Lookup Values in VLOOKUP? Helper Column or Array Formula.	7:50	2016-05-16
1161	Highline Excel 2016 Class 11: Lookup Functions & Formulas, Comprehensive Lessons, 20 Examples	1:18:34	2016-05-14
1162	Highline Excel 2016 Class 10: Excel Data Validation (List, Custom & More), Comprehensive Lesson	23:46	2016-05-12
1163	Highline Excel 2016 Class 09: Date Formulas and Date Functions, including Fiscal Quarter & Year	22:04	2016-05-10
1164	Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data	29:41	2016-05-10
1165	Highline Excel 2016 Class 07 Excel 2016 MAXIFS, MINIFS & IFS Functions for Conditional Calculations	11:04	2016-05-10
1166	Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons	1:23:02	2016-05-07
1167	Highline Excel 2016 Class 05: Excel Array Formulas: Comprehensive Lessons: 12 Examples	52:01	2016-05-01
1168	Highline Excel 2016 Class 04: References: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table…	1:43:28	2016-04-26
1169	Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model	1:43:05	2016-04-17
1170	Highline Excel 2016 Class 02: Excel Fundamentals: Comprehensive Formula Lesson (15 Examples)	55:03	2016-04-09
1171	Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting	1:21:10	2016-04-06
1172	Mr Excel & excelisfun Trick 177: Add Numbers That Are Missing From List	5:58	2016-03-25
1173	Excel Magic Trick 1297: COUNTIFS & SUMPRODUCT & No Helper Column to Score Myers-Briggs Test	6:38	2016-03-24
1174	Excel Magic Trick 1295: TEXTJOIN & INDEX Function to create Random Description Codes	3:46	2016-03-21
1175	Excel Magic Trick 1296: COUNTIFS with OR Criteria & SUMPRODUCT to Score Myers-Briggs Test	4:04	2016-03-20
1176	Excel Magic Trick 1294: Single Cell "Lookup Adding" w Improper Data Set to Score Myers-Briggs Test	7:10	2016-03-19
1177	Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score	6:24	2016-03-18
1178	Excel Magic Trick 1292: Power Query Unpivot into Proper Lookup Table to Score Myers-Briggs Test	7:17	2016-03-17
1179	Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Test	9:16	2016-03-16
1180	Isaac’s Science Project: How the Shape of Boomerang Affects the Flight of a Boomerang	1:23	2016-03-15
1181	Excel Magic Trick 1290: VLOOKUP to Multiple Dynamic Lookup Tables Listed as Single Downloaded Table	14:45	2016-03-13
1182	Excel Magic Trick 1289: Remove “USD” from CSV File Column of Numbers (6 Examples)	14:39	2016-03-11
1183	Excel Magic Trick 1287: SWITCH Function: How to Lookup Formulas, References, or Anything Else	17:52	2016-03-05
1184	Excel Magic Trick 1286: Excel 2016 IFS Functions (9 Examples: Compare & Contrast IF & IFS Functions)	28:21	2016-03-03
1185	Excel Magic Trick 1285: OR Criteria & AND Criteria for Max & Min Calculations (5 Examples)	19:49	2016-02-29
1186	Excel Magic Trick 1284: History of Excel Max or Min with Conditions / Criteria (5 Examples)	14:38	2016-02-27
1187	Excel Magic Trick 1283: MINIFS & MAXIFS Excel 2016 Functions: Max or Min with Conditions / Criteria	8:42	2016-02-25
1188	Excel Magic Trick 1288: Why Doesn’t =ROW(1:LEN(A1)) Work?	5:42	2016-02-25
1189	Excel Magic Trick 1282: Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function	5:12	2016-02-23
1190	Excel Magic Trick 1281: TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items)	10:54	2016-02-20
1191	Excel Magic Trick 1280: How To Get Latest Excel Updates for Insider Program: Office 365	2:40	2016-02-20
1192	Excel Magic Trick 1277: Sort Logical Values Alphabetically: false, FALSE, False, true, TRUE, True	6:09	2016-02-18
1193	Excel Magic Trick 1279: New Running Count Formula After Each Zero Value (Cumulative Count)	2:15	2016-02-14
1194	Excel Magic Trick 1278: Extract Color From Description (Text String)	3:35	2016-02-14
1195	Mr Excel & excelisfun Trick 176.5: Start and Min Times With Two Conditions / Criteria	8:23	2016-02-13
1196	Mr Excel & excelisfun Trick 176: Complicated Start & End Time Lookup: Helper Column or Array Formula	11:33	2016-02-12
1197	Excel Magic Trick 1276: Impossible: Excel Online Absolute Cell References?	1:54	2016-02-11
1198	Excel Magic Trick 1275: Excel Online Office 365 MAXIFS function	1:58	2016-02-11
1199	Excel Magic Trick 1274: VLOOKUP Replaces Long IF Formula for Conversion Formula (LOOKUP too)	6:09	2016-02-10
1200	Excel Magic Trick 1273: Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins	4:49	2016-02-08

1201	Excel Magic Trick 1272: Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods)	7:38	2016-02-07
1202	Excel Magic Trick 1271: Extract Top 20 Values & Dates: Formula, Array Formula or Power Query?	17:18	2016-02-05
1203	Excel Magic Trick 1270: Calculate Retirement Date with EDATE and EOMONTH functions	3:27	2016-02-05
1204	Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model	10:09	2016-02-03
1205	Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List	6:27	2016-02-01
1206	Excel Magic Trick 1267: PivotTable Automatic Date Grouping: New in Excel 2016	3:20	2016-01-31
1207	Excel Magic Trick 1266: NETWORKDAYS.INTL: Each Employee has Different Weekend Schedule?	4:50	2016-01-30
1208	Excel Magic Trick 1265: NETWORKDAYS.INTL Function: Calculate Net Workdays (8 examples)	7:53	2016-01-29
1209	Excel Magic Trick 1264: Gross Pay From Start & End Date, Weekends Sun & Mon and Weekly Pay Scale	4:09	2016-01-28
1210	Excel Magic Trick 1263: Power Query M Code: 10 Cross Tabulated Transformed into 1 Proper Data Set	11:21	2016-01-25
1211	Excel Magic Trick 1262: Convert Times Values to HHMM Text or Text HHMM Values to Time Values	3:48	2016-01-24
1212	Excel Magic Trick 1261: Flash Fill to Add Spaces to Credit Card Numbers	2:00	2016-01-23
1213	Excel Magic Trick 1260 Re-Do: Prevent VLOOKUP from Returning Zero from Empty Cell in Lookup Table.	1:58	2016-01-22
1214	Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes.	8:56	2016-01-22
1215	Excel Magic Trick 1259: Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula?	8:02	2016-01-20
1216	Excel Magic Trick 1258: Add Spaces Between Digits: Custom Number Format & TEXT Function	2:19	2016-01-19
1217	Excel Magic Trick 1257: Power Query to Create One Proper Table from 10 Cross Tabulated Tables	11:32	2016-01-18
1218	Excel Magic Trick 1256: Grouped Dates in PivotTable With Becomes UnGrouped When I Refresh!!!	5:15	2016-01-17
1219	Excel Magic Trick 1255: Formula to Convert Text Dates With Missing Year & Extra Spaces To Real Dates	5:10	2016-01-16
1220	Excel Magic Trick 1254: Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula?	8:55	2016-01-13
1221	Excel Magic Trick 1252: Power Query To Create Unique List of Invoice Numbers with Balances	4:03	2016-01-12
1222	Excel Magic Trick 1251: SUMIFS & Table Formula Nomenclature (Structured References) to Add Invoices	4:24	2016-01-10
1223	Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!	4:58	2016-01-08
1224	Excel Magic Trick 1250: Add Times to Get Total Minutes & Seconds From Downloaded Music Data	11:29	2016-01-07
1225	Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail	25:46	2016-01-05
1226	Excel Magic Trick 1248: Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT	5:16	2016-01-02
1227	Excel Magic Trick 1247: Adding with Case Sensitive Criteria: EXACT & SUMPRODUCT	4:08	2016-01-01
1228	Excel Magic Trick 1246: Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT	5:46	2015-12-30
1229	Basic Excel Business Analytics #69: Monte Carlo Simulation for Baseball World Series	9:42	2015-12-30
1230	Basic Excel Business Analytics #68: Monte Carlo Simulation Histogram for Construction Project Length	15:56	2015-12-28
1231	Merry Christmas Tree Fun In Excel RAND Function and Conditional Formatting (Excel Magic Trick 1245)	1:54	2015-12-26
1232	Basic Excel Business Analytics #67: Monte Carlo Simulation for Marketing Analysis Binomial Variable	11:46	2015-12-26
1233	Basic Excel Business Analytics #66: Monte Carlo Simulation for New Product, 3 Uncertain Variables	18:33	2015-12-25
1234	Basic Excel Business Analytics #65: Create Random Variables: Custom, Binomial, Uniform, Normal	22:42	2015-12-24
1235	Basic Excel Business Analytics #64: Introduction To Monte Carlo Simulation In Excel	23:45	2015-12-23
1236	Basic Excel Business Analytics #57: Intro To Linear Programming using Algebra, Pencil & Paper	27:43	2015-12-12
1237	Basic Excel Business Analytics #58 Excel Solver to Maximize Contribution Margin	16:37	2015-12-12
1238	Basic Excel Business Analytics #60: Excel Solver: Minimize Transportation Costs, Integer Variable	12:55	2015-12-12
1239	Basic Excel Business Analytics #62: Excel Solver: Maximize Portfolio Returns	11:34	2015-12-12
1240	Basic Excel Business Analytics #59: Linear Program Special Cases: Infeasible, Unbound, Alternative	5:03	2015-12-12
1241	Basic Excel Business Analytics #61: Find Alternative Optimal Solution For Transportation Problem	5:33	2015-12-12
1242	Basic Excel Business Analytics #63: Excel Solver Binary Variable Choose Projects Limited Resources	7:26	2015-12-12
1243	Basic Excel Business Analytics #53: Line Charts for Time Series Data	12:27	2015-12-04
1244	Basic Excel Business Analytics #54: Basic Forecasting Methods & Measures of Forecast Error	32:13	2015-12-04
1245	Basic Excel Business Analytics #56: Forecasting with Linear Regression: Trend & Seasonal Pattern	25:22	2015-12-04
1246	Basic Excel Business Analytics #55: Summary of 4 Basic Forecasting Methods & Mean Square Error	8:13	2015-12-04
1247	Basic Excel Business Analytics #47: SST = SSR + SSE & R Squared & Standard Error of Estimate	30:24	2015-11-26
1248	Basic Excel Business Analytics #46: Slope & Intercept for Estimated Simple Liner Regression Equation	18:29	2015-11-26
1249	Basic Excel Business Analytics #45: Covariance and Correlation to Measure Linear Relationship	15:58	2015-11-26
1250	Basic Excel Business Analytics #44: Intro To Linear Regression & Scatter Chart	15:46	2015-11-26
1251	Basic Excel Business Analytics #48: Data Analysis Regression feature	6:37	2015-11-26
1252	Basic Excel Business Analytics #49: LINEST Array Function for Simple Linear Regression	4:45	2015-11-26
1253	Basic Excel Business Analytics #50: Introduction to Multiple Regression, Data Analysis Regression	13:34	2015-11-26
1254	Basic Excel Business Analytics #51: Testing Significance of Regression Relationship with p-value	20:45	2015-11-26
1255	Basic Excel Business Analytics 52: LINEST, F.DIST.RT, T.DIST.2T & ABS Functions Test of Significance	8:31	2015-11-26
1256	Excel Magic Trick 1244: Transform GDP Data Set: Advanced Filter with Formula Criteria wins!	7:33	2015-11-14
1257	Mr Excel & excelisfun Trick 175: Conditional Formatting to Highlight Cells with Formulas	5:32	2015-11-13
1258	Excel Magic Trick 1243: Transform GDP Data Set: Power Query 2nd Method or Advanced Filter?	10:41	2015-11-07
1259	Excelisfunner, Mr Excel & excelisfun Truel 06: Multiplication Table for 4th Grade Class	7:23	2015-11-06
1260	Mr Excel & excelisfun Trick 174: Clean & Transform GDP Data Set: Advanced Filter? Or Power Query?	9:21	2015-11-06
1261	Excel Magic Trick 1242: Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format	9:49	2015-11-06
1262	Basic Excel Business Analytics #43: Visualizing Data: Table & Chart Guidelines	41:39	2015-11-03
1263	Basic Excel Business Analytics #42: Comprehensive PowerPivot, Data Model, DAX & Reporting Example	1:01:05	2015-10-29
1264	Basic Excel Business Analytics #41: Excel 2016: Introduction to PowerPivot & Data Model	10:53	2015-10-28
1265	Basic Excel Business Analytics #40: Introduction to PowerPivot & Data Modeling	36:23	2015-10-26
1266	Excel Business Analytics #39: Import Related Tables: Power Query Merge? Data Model Relationships?	12:19	2015-10-22
1267	Basic Excel Business Analytics #38: PivotTable from 4 Million Records with Power Query & Data Model	10:56	2015-10-22
1268	Basic Excel Business Analytics #37: Excel 2016 Data Tab, Get & Transform: Unpivot feature	6:52	2015-10-21
1269	Basic Excel Business Analytics #36: Power Query to Unpivot Data (Multiple Columns to Single Column)	6:16	2015-10-21
1270	Basic Excel Business Analytics #35: Power Query to Get Data From Web Site & Import into Excel.	3:01	2015-10-21
1271	Basic Excel Business Analytics #34: Power Query: Import & Merge Multiple Sources Access, Text, Excel	5:01	2015-10-21
1272	Basic Excel Business Analytics #33: Power Query: Transform Many Bad Data Files into Proper Data Set	11:22	2015-10-21
1273	Basic Excel Business Analytics #32: Power Query Import Multiple Excel Files with Multiple Sheets	8:59	2015-10-20
1274	Basic Excel Business Analytics #31: Power Query: Import Multiple Excel Files with 1 Sheet Each	12:07	2015-10-20
1275	Basic Excel Business Analytics #30: Excel 2016 Power Query: Data Ribbon Tab, Get and Transform	5:14	2015-10-19
1276	Basic Excel Business Analytics #29: Power Query: Import Multiple Large CSV Files Into Data Model	11:20	2015-10-19
1277	Basic Excel Business Analytics #28: Power Query: Import Multiple Text Files & Build Grade Dashboard	21:54	2015-10-19
1278	Basic Excel Business Analytics #27: Clean & Transform Data: Formulas, Flash Fill, Power Query, TTC	29:49	2015-10-18
1279	Using Excel to Calculate Grades (14 Examples) for Highline College Professional Development Day 2015	48:28	2015-10-16
1280	Basic Excel Business Analytics #17: FREQUENCY Array Function for Frequency Distribution & Histogram	23:02	2015-10-10
1281	Basic Excel Business Analytics #18: Data Analysis Add-in for Frequency Distribution & Histogram	9:34	2015-10-10
1282	Basic Excel Business Analytics #19: Why PivotTables Rule for Frequency Distributions & Histograms	16:30	2015-10-10
1283	Basic Excel Business Analytics 22 Geometric Mean Average Compounding Rate GEOMEAN RRI Function	11:33	2015-10-10
1284	Basic Excel Business Analytics #23: Variability: Variance, Standard Deviation, Z-score and more	18:21	2015-10-10
1285	Basic Excel Business Analytics #21: AVERAGE, MEDIAN, MODE.MULT functions & PivotTable Mode	9:04	2015-10-10
1286	Basic Excel Business Analytics #24: Empirical Rule, Calculating Probability NORM.DIST & NORM.S.DIST	13:59	2015-10-10
1287	Basic Excel Business Analytics #25: Percentiles, Quartiles, 5 Number Summary using Excel Functions	13:17	2015-10-10
1288	Basic Excel Business Analytics #20: Skew: Shape of Histogram, Shape of Quantitative Data	3:19	2015-10-10
1289	Basic Excel Business Analytics #26: Box & Whisker Plot. Chart Example in Excel 2016.	5:22	2015-10-10
1290	Basic Excel Business Analytics #16: Count Transactions by Hour Report & Chart	7:30	2015-10-09
1291	Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart	11:52	2015-10-09
1292	Basic Excel Business Analytics #14: Logical Formulas & Conditional Formatting to Visualizing Data	13:30	2015-10-09
1293	Basic Excel Business Analytics #13: Excel Data Analysis Features: Sort, Filter, Pivot Tables	21:39	2015-10-09
1294	Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology	15:48	2015-10-09
1295	Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models	17:17	2015-10-02
1296	Basic Excel Business Analytics #11: Dynamic Grading Model: Excel Table feature & VLOOKUP	9:50	2015-10-02
1297	Excel Magic Trick 1241: Keyboard To Copy Formula Next To Data Set Down A Column	1:51	2015-10-02
1298	Excel Magic Trick 1240: Double Click To Copy Formula Down When Formula Is Not Next To Data Set	2:21	2015-10-01
1299	Excel Magic Trick 1239: Formula To Indicate a Date is in Leap Year	4:02	2015-10-01
1300	People and Canvas Web Site For Busn 218 - Class Intro Video	20:19	2015-09-27

1301	Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions	10:58	2015-09-26
1302	Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT?	19:52	2015-09-24
1303	Basic Excel Business Analytics #07: X-Y Scatter Chart: Fixed Cost Variable Cost Model	14:27	2015-09-23
1304	Basic Excel Business Analytics #06: 2 Variable Data Table For What-If Analysis	9:47	2015-09-22
1305	Basic Excel Business Analytics #05: 1 Variable Data Table For What-If Analysis	11:32	2015-09-22
1306	Basic Excel Business Analytics #04: Excel Formula for Units Break Even Point and a Unit Defect Rate	4:47	2015-09-21
1307	Basic Excel Business Analytics #03: Goal Seek For What-If Analysis	5:29	2015-09-21
1308	Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example	37:24	2015-09-17
1309	Basic Excel Business Analytics #01: Basic Business Analytics using Excel	5:04	2015-09-17
1310	Excel Magic Trick 1238: Are All Cells Equal? Is The Content In Each Cell The Same? 4 Examples	9:36	2015-09-16
1311	Excel Magic Trick 1237: Add with "Contains Criteria" or Partial Text Criteria: SUMIFS & Wildcard	3:56	2015-09-15
1312	Excel Magic Trick 1236: Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT?	7:14	2015-09-13
1313	Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP	10:45	2015-09-11
1314	Excel 2013 PivotTables from A to Z for the Northwest Accounting Educators 2015 Conference	1:04:47	2015-08-31
1315	Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range	8:46	2015-08-30
1316	Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function	5:38	2015-08-29
1317	Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1	8:42	2015-08-27
1318	Excel Magic Trick 1231: VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function?	14:21	2015-08-24
1319	Excel Magic Trick 1230: Conditional Formatting: Highlight Table with Color When Name Selected	5:08	2015-08-23
1320	Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color	2:37	2015-08-19
1321	Excel Magic Trick 1228: Hours Worked Formula For Date & Time Values & Time Custom Number Format	4:06	2015-08-18
1322	Excel Magic Trick 1227: Conditional Format: Min, Max & Min Value Greater Than Zero	7:20	2015-08-17
1323	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
1324	Excel Magic Trick 1225: Excel/Word Mail Merge for Customer Accounts Receivable Letter or E-mail	12:07	2015-08-14
1325	Excel Magic Trick 1224: Which Similar Array Formula? Compare Number of Array Operations	8:57	2015-08-12
1326	Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data	5:44	2015-08-10
1327	Excel Magic Trick 1222: Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format?	6:49	2015-08-08
1328	Excel Magic Trick 1221: Dynamic Chart to Plot Daily Changes in Meter Readings	8:57	2015-08-07
1329	Excel Magic Trick 1220: How To Put Double Quotes In Text Formula: Extra Double Quotes Or VLOOKUP	5:45	2015-08-05
1330	Excel Magic Trick 1219: Paste Special Linked Picture so PivotTable is not Hidden When Filter Applied	4:17	2015-08-03
1331	Excel Magic Trick 1218: PivotTable & Slicer To Show Historical Adj Stock Price by Year & Month	9:01	2015-08-01
1332	Excel Magic Trick 1217: D Functions: Text Criteria: “Starts With”, “Exact” and “Contains”	5:07	2015-07-31
1333	Excel Magic Trick 1216: Fraction Number Formatting To Show Only Significant Digits, Like: ####/####	5:26	2015-07-30
1334	Excel Magic Trick 1215: Filter Data Set & Chart Disappears: Change Chart Properties!!!	3:02	2015-07-29
1335	Excel Magic Trick 1214: How To Enter Text Criteria Into Excel Database Functions	4:07	2015-07-28
1336	Excel Magic Trick 1213: Fraction Number Formatting & Making Sure the Correct Number Is Displayed	4:31	2015-07-27
1337	Excel Magic Trick 1212: What To Do If You Filter Data Set & Chart Disappears	3:21	2015-07-25
1338	Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function	8:53	2015-07-24
1339	Excel Magic Trick 1210: Power Query to Combine 4 Columns into 1 Table For PivotTable Report	8:13	2015-07-23
1340	Excel Magic Trick 1209: BINOM.DIST.RANGE Function for Calculating Binomial Probabilities	6:12	2015-07-21
1341	Excel Magic Trick 1208: Combine 4 Columns into 1 Table For PivotTable Report (without Power Query)	11:09	2015-07-20
1342	Excel Magic Trick 1207: PERCENTILE.EXC, PERCENTILE.INC, QUARTILE.EXC, QUARTILE.INC Functions	12:52	2015-07-17
1343	Excel Magic Trick 1206: Day & Night Shift Time Calculations: Add Total Hours Single Cell Formula	10:35	2015-07-16
1344	Excel 2013 Statistical Analysis #73: Chi-Square Test Independence 2 Categorical Var. (PivotTables)	23:08	2015-06-27
1345	Excel 2013 Statistical Analysis #72: Chi-Square Test For 2 or More Population Proportions (Formulas)	30:11	2015-06-27
1346	Excel 2013 Statistical Analysis #71: Inference About Difference Between 2 Pop. Proportions Z Method	28:04	2015-06-27
1347	Excel 2013 Statistical Analysis #70: Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Error	24:16	2015-06-27
1348	Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers	11:27	2015-06-06
1349	Mr Excel & excelisfun Trick 173: Total Service Fee Over Life of Loan: Non-Array Formula is best!	19:01	2015-06-05
1350	Excel Magic Trick 1204: Conditional Formatting For Day’s Change: Up & Down Icon Arrows	2:52	2015-05-31
1351	Excel 2013 Statistical Analysis #63: Sampling Distribution of Xbar1 – Xbar2 & Standard Error	26:20	2015-05-30
1352	Excel 2013 Statistical Analysis #69: ANOVA Tables for Comparing More Than 2 Population Means	44:22	2015-05-30
1353	Excel 2013 Statistical Analysis #68: Matched/Paired Samples Population Differences Sigma NOT Known	20:48	2015-05-30
1354	Excel 2013 Statistical Analysis #65: Hypothesis Testing for Population Differences Sigma Known	16:48	2015-05-30
1355	Excel 2013 Statistical Analysis #66: Confidence Interval for Population Differences Sigma NOT Known	16:12	2015-05-30
1356	Excel 2013 Statistical Analysis #67: Hypothesis Testing for Population Differences Sigma NOT Known	17:29	2015-05-30
1357	Excel 2013 Statistical Analysis #64: Confidence Interval for Population Differences Sigma Known	9:52	2015-05-30
1358	Excel Magic Trick 1203: 2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change	9:09	2015-05-26
1359	Excel Magic Trick 1202: Conditional Formatting For a Cross Tabulated PivotTable	4:06	2015-05-25
1360	Excel Magic Trick 1201: Conditional Format Product With No Sales (5 Examples)	10:07	2015-05-24
1361	Excel Magic Trick 1200: Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods)	6:59	2015-05-23
1362	Excel Magic Trick 1199: Formula to Extract Everything After Last Space: Two Formula Solutions	6:37	2015-05-22
1363	Excel Magic Trick 1198: Median for Each Quarter Using AGGREGATE Function	8:32	2015-05-21
1364	Excel Magic Trick 1197: OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT?	12:28	2015-05-07
1365	Excel Magic Trick 1196: YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips…	9:47	2015-05-03
1366	Excel Magic Trick 1195: Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution?	7:45	2015-05-02
1367	Dad and Son Boomerang Throwing and Rad Catching! (Mike Gel & Isaac Gel)	0:16	2015-04-26
1368	Excel Magic Trick 1192: Match Lookup Value to Closest Number in 1st Column of Lookup Table	10:33	2015-04-24
1369	Excel Magic Trick 1191: VLOOKUP: Lookup Temperature and Return to Bat Observation Table	4:44	2015-04-24
1370	Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?	5:58	2015-04-24
1371	Excel Magic Trick 1194: VLOOKUP: Data Mismatch Makes Yields #N/A, What To Do?	2:40	2015-04-24
1372	Mr Excel & excelisfun Trick 172: VLOOKUP Update After Columns Inserted Into Lookup Table?	5:38	2015-04-24
1373	Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally	21:24	2015-04-22
1374	Excel 2013 Accounting Tricks for Excel CPE Credit at Poodle Dog Restaurant (50 Examples)	1:19:49	2015-04-17
1375	Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take	5:08	2015-04-12
1376	Excel Magic Trick 1188: SUMIFS with Wildcards to Do Approximate Criteria or “Fuzzy” Criteria	2:25	2015-04-12
1377	Excel 2013 PivotTables & Charts for Descriptive Statistics From Raw Data Sets (5 Examples) Math 146	41:11	2015-04-07
1378	Bubble Gun Fun on Easter Sunday!	0:35	2015-04-05
1379	Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable	5:23	2015-03-27
1380	Excel Magic Trick 1187: Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions	2:27	2015-03-27
1381	Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…	2:49	2015-03-26
1382	Excel Magic Trick 1185: Calculate Standard Deviation from Frequency Distribution in Excel	3:33	2015-03-26
1383	Tour of excelisfun YouTube Channel: Playlists, Downloadable Files and Search for Video Topic	3:25	2015-03-26
1384	Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula	4:23	2015-03-25
1385	Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters	4:59	2015-03-25
1386	Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT	6:57	2015-03-24
1387	People and Canvas Web Site For Busn 216 - Class Intro Video	21:06	2015-03-24
1388	Excel Magic Trick 1179: Calculate Mean, Median and Mode From Data Set	8:00	2015-03-20
1389	Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?	14:14	2015-03-13
1390	Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter	8:22	2015-03-09
1391	Excel 2013 Statistical Analysis #62: Calculate Slope and Intercept for Regression Line	14:29	2015-03-08
1392	Mr Excel & excelisfun Trick 171: Split First & Last Name Based on Second Capital Letter	9:47	2015-03-06
1393	Excel 2013 Statistical Analysis #54: 1 Tail Left Mean Hypothesis Z Test: P-value & Critical Value	12:17	2015-03-03
1394	Excel 2013 Statistical Analysis #55: 2 Tail Z Score Mean Hypothesis Testing P-value Critical Value	12:15	2015-03-03
1395	Excel 2013 Statistical Analysis #56: NORM.S.DIST = p-value, NORM.S.INV = Critical Value Sigma Known	8:55	2015-03-03
1396	Excel 2013 Statistical Analysis #59: 2 Tail Mean Hypothesis T Test: P-value & Critical Value	10:23	2015-03-03
1397	Excel 2013 Statistical Analysis #57: 1 Tail Right Mean Hypothesis T Test P-value & Critical Value	12:42	2015-03-03
1398	Excel 2013 Statistical Analysis #58: 1 Tail Left T Score Mean Hypothesis Test P-value Critical Value	9:09	2015-03-03
1399	Excel 2013 Statistical Analysis #60: T.DIST, T.DIST.RT, T.DIST.2T, T.INV, T.INV.2T functions	10:50	2015-03-03
1400	Excel 2013 Statistical Analysis #61: Hypothesis Test for Proportions using p-value or Critical Value	9:53	2015-03-03

1401	Excel 2013 Statistical Analysis #53: 5 Steps Hypothesis Testing: P-value & Critical Value Methods	38:09	2015-03-02
1402	Excel 2013 Statistical Analysis #46 Standard Error: Standard Deviation of Xbar Sampling Distribution	5:23	2015-03-01
1403	Excel 2013 Statistical Analysis #47: Central Limit Theorem To Compare Sample Mean To Normal Curve	10:03	2015-03-01
1404	Excel 2013 Statistical Analysis #48: Introduction to Confidence Intervals	14:02	2015-03-01
1405	Excel 2013 Statistical Analysis #49: Create Confidence Intervals Sigma Known Z-Score (3 Methods)	9:54	2015-03-01
1406	Excel 2013 Statistical Analysis #50: t Distribution Confidence Intervals Sigma NOT Known 3 Examples	20:15	2015-03-01
1407	Excel 2013 Statistical Analysis #51: Confidence Intervals for Pbar Sample Proportion	11:14	2015-03-01
1408	Excel 2013 Statistical Analysis #52: Determine Sample Size for Sample Mean & Sample Proportion	7:01	2015-03-01
1409	Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)	13:14	2015-02-27
1410	Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel	9:53	2015-02-27
1411	Excel Magic Trick 1176: CONVERT Function to convert units in Excel (Excel CONVERT Joke at 05:27)	7:08	2015-02-27
1412	Excel 2013 Statistical Analysis #43: Simple Random Sampling in Excel: Process & Theory	26:57	2015-02-24
1413	Excel 2013 Statistical Analysis #44: Sampling Distribution of Xbar and the Central Limit Theorem	45:39	2015-02-24
1414	Excel 2013 Statistical Analysis #45: Sampling Distribution of Pbar (Binomial Sample Proportion)	11:04	2015-02-24
1415	Excel 2013 Statistical Analysis #38: Uniform Probability Distribution	15:05	2015-02-18
1416	Excel 2013 Statistical Analysis #37: Introduction to Continuous Probability Distributions	9:01	2015-02-18
1417	Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution	24:08	2015-02-18
1418	Excel 2013 Statistical Analysis #40: Normal (Bell) Probability Distribution Area Chart, X & Z Values	15:13	2015-02-18
1419	Excel 2013 Statistical Analysis #41: Answering Probability Questions With NORM.DIST Function	8:39	2015-02-18
1420	Excel 2013 Statistical Analysis #42: Exponential Probability Distribution & EXPON.DIST function	11:28	2015-02-18
1421	Mr Excel & excelisfun Trick 170: Add Leading Apostrophe to Column of Data: VBA or Flash Fill	5:20	2015-02-13
1422	Excel 2013 Statistical Analysis #36: Dynamic Binomial Probability Charts (3 Examples)	19:41	2015-02-13
1423	Excel 2013 Statistical Analysis #34: POSSION Distribution and POISSON.DIST Function	23:45	2015-02-11
1424	Excel 2013 Statistical Analysis #35: Hypergeometric Distribution and HYPGEOM.DIST Function	7:51	2015-02-11
1425	Excel 2013 Statistical Analysis #32: Expected Value Standard & Deviation Discrete Prob. Distribution	9:41	2015-02-10
1426	Excel 2013 Statistical Analysis #33: Binomial Probability Distributions: Tables, Charts, Functions	37:51	2015-02-10
1427	Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD	32:08	2015-02-10
1428	Excel Magic Trick 1173: Conditional Format Dates When they are 90 Days of Set Expiration Date	6:58	2015-02-07
1429	Mr Excel & excelisfun Trick 169: Clean Data, Then Randomly Select 250 Names	9:12	2015-02-06
1430	Excel 2013 Statistical Analysis #30: Bayes’ Theorem to Calculate Posterior Probabilities	16:40	2015-02-06
1431	Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)	25:27	2015-02-03
1432	Excel 2013 Statistical Analysis #25: Probability Basics: Sample Points, Events & Event Probabilities	31:07	2015-02-03
1433	Excel 2013 Statistical Analysis #28: Multiplication Law of Probability AND Events (16 Examples)	33:18	2015-02-03
1434	Excel 2013 Statistical Analysis #26: Combinations & Permutations and Listing Sample Points	7:36	2015-02-03
1435	Excel 2013 Statistical Analysis #29: Create Joint Probability Table from Raw Data & Calc Event Probs	6:31	2015-02-03
1436	Excel 2013 Statistical Analysis #24: Numerical Measures: Covariance and Correlation Coefficient	19:23	2015-01-28
1437	Excel 2013 Statistical Analysis #20: Standard Deviation: How Fairly Does Mean Represent Data Points?	29:59	2015-01-24
1438	Excel 2013 Statistical Analysis #21: SKEW Function and Asymmetry in a Distribution of Data Points	5:01	2015-01-24
1439	Excel 2013 Statistical Analysis #22: Z-Score = # of Standard Deviations, Chebshev’s &Empirical Rule	31:54	2015-01-24
1440	Excel 2013 Statistical Analysis #18: Geometric Mean, Average Compounding Rate GEOMEAN & RRI	10:10	2015-01-24
1441	Excel 2013 Statistical Analysis #16: Location: Mean, Median, Mode for Central Location	24:15	2015-01-24
1442	Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank	20:55	2015-01-24
1443	Excel 2013 Statistical Analysis #17: Weighted Mean & SUMPRODUCT Function & Accounting Example	11:49	2015-01-24
1444	Excel 2013 Statistical Analysis #23: Five Number Summary, Outliers and Box Plots	11:45	2015-01-24
1445	Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT	5:48	2015-01-16
1446	Excel Magic Trick 1171: SUMIFS & SUMIF Treat 0500 & 00500 the Same! Use SUMPRODUCT Instead	3:06	2015-01-15
1447	Excel 2013 Statistical Analysis #15: Create Dot Plot in Excel Using COUNTIFS and REPT functions	7:02	2015-01-15
1448	Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions	4:33	2015-01-13
1449	Excel Magic Trick 1169: Are Items In Row In Master List? Filter & Conditionally Format To Highlight	7:11	2015-01-13
1450	Busn 135 Test Download and Upload Hint	3:42	2015-01-05
1451	Into To Busn 135, Canvas and People Web Site and more	25:07	2015-01-05
1452	Week 1 Video for Busn 135	2:18	2015-01-05
1453	Intro To Busn 210, Canvas and People Web Site and more	17:07	2015-01-03
1454	Excel 2013 Statistical Analysis #06: Frequency Distributions & Column Charts, Categorical Variables	33:32	2015-01-02
1455	Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable	41:36	2015-01-02
1456	Excel 2013 Statistical Analysis #07: Subtle Chart Junk	3:26	2015-01-02
1457	Excel 2013 Statistical Analysis #10: Description of Dot Plot and Stem and Leaf Charts	2:48	2015-01-02
1458	Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable & Formula	15:48	2015-01-02
1459	Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Paradox	18:37	2015-01-02
1460	Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year	9:02	2015-01-02
1461	Excel 2013 Statistical Analysis #13: Scatter Chart & Trendline, X Y Data, 2 Quantitative Variables	7:22	2015-01-02
1462	Excel 2013 Statistical Analysis #14: VLOOKUP to Add New Field To Table & Create Cross Tabulation	13:05	2015-01-02
1463	Excel 2013 Statistical Analysis #03: Download & Install Power Query for Data Transformation Tools	3:39	2014-12-23
1464	Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information	19:28	2014-12-23
1465	Excel 2013 Statistical Analysis #2: Install Data Analysis Add-in For Amazing Excel Statistical Tools	1:15	2014-12-23
1466	Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio	20:17	2014-12-23
1467	Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)	2:22:43	2014-12-19
1468	Excel 2013 Statistical Analysis #00: Excel Workbooks For This Class	2:08	2014-12-19
1469	Excel Power Query #12: Find & Replace, Group By 3 Columns, Load With Existing Connections	7:13	2014-12-09
1470	Excel Power Query #11: Each Row Has 3 Records, Unwind Table into Proper Data Set	6:00	2014-12-08
1471	Excel Power Query #09: Merge Multiple Worksheets in Workbook To New Table using Append Feature	5:06	2014-12-06
1472	Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples)	7:31	2014-12-06
1473	Excel Magic Trick 1167.5: Subtract Lowest Grade	0:56	2014-12-06
1474	Excel Magic Trick 1168: Get Time Value From Date Time Value (2 Formula Examples)	3:00	2014-12-05
1475	Excel Magic Trick 1166: Count Dates From Date-Time Values: COUNTIFS or PivotTable?	5:45	2014-12-05
1476	Excel Magic Trick 1167: Substitute Final Score If Greater Than Low Score: MAX, MIN & SUM Functions	2:43	2014-12-05
1477	Mr Excel & excelisfun Trick 168: Create List of Dates For Real Estate Transaction	12:34	2014-12-05
1478	Excel Magic Trick 1163: COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too.	6:04	2014-12-04
1479	Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF?	7:51	2014-12-04
1480	Excel Magic Trick 1165: Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Functions	4:47	2014-12-04
1481	Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks	9:35	2014-11-30
1482	Excel Power Query #07: Get Latest Update for Power Query	1:14	2014-11-29
1483	Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model	6:32	2014-11-29
1484	Excel Power Query #05: Create Dimension Table From Fact Table for PowerPivot During CSV File Import	9:01	2014-11-29
1485	Excel Power Query #04: Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically	7:15	2014-11-28
1486	Excel Magic Trick 1162: Cell Reference That Point To Empty Cells Evaluate To Zero, IF Function Trick	3:06	2014-11-28
1487	Excel Magic Trick 1161: F4 Key To Repeat Last Action	1:16	2014-11-28
1488	Excel Magic Trick 1160: Jump To Next Change In Column: Go To Special, Column Difference	1:43	2014-11-27
1489	Excel Magic Trick 1159: Extract Unique List For Data Validation List with Power Query	4:26	2014-11-27
1490	Excel Magic Trick 1158: Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013	4:25	2014-11-26
1491	Excel Magic Trick 1157: Running Total Jumps Over Hurdle & Gas Cost for Mileage is Reduced Formula	5:07	2014-11-24
1492	Excel Power Query #03: Import Multiple Text Files in 1 Step, and Amazing Pivot Chart For Grade Data	15:09	2014-11-23
1493	Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)	6:11	2014-11-22
1494	Excel Magic Trick 1155: IF Function: Checking For Empty Cells (5 Methods)	6:47	2014-11-22
1495	Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods)	6:09	2014-11-20
1496	Excel Magic Trick 1153: Unique Count For Name & Date: Array Formula, 2013 PivotTable, More…	10:25	2014-11-20
1497	Excel 2013 PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data	8:21	2014-11-15
1498	Excel Magic Trick 1151: Get Two Tables Into Pivot Table Field List using Excel 2013	5:34	2014-11-15
1499	Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match	7:30	2014-11-15
1500	Excel 2013 PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable	10:52	2014-11-15

1501	Excel 2013 PowerPivot Basics #12: Show Report Filter Pages Not Available In PowerPivot Pivot Table	2:49	2014-11-15
1502	Excel 2013 Power Query #02: Transform Data and Import Into PowerPivot or Excel Table	9:04	2014-11-11
1503	Excel 2013 Power Query #01: Append 3 Tables Into One in PowerPivot or Excel Table	5:31	2014-11-11
1504	Excel Magic Trick 1150: Power Query: Dynamically Sum by Category without VLOOKUP Helper Column	6:24	2014-11-11
1505	Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)	12:20	2014-11-08
1506	Excel Magic Trick 1148: Calculate Retirement Year Based On 80 Rule	5:20	2014-11-07
1507	Excel Magic Trick 1147: Incorrect Formula To Calculate Retirement Year	2:27	2014-11-06
1508	Excel 2013 PowerPivot Basics #10: CALCULATE function to Change Filter Context (14 Examples)	53:02	2014-11-05
1509	Mr Excel & excelisfun Trick 167: Are All the Numbers 1 to 99 in Range? Array Formula or VBA?	16:17	2014-10-31
1510	Excel Magic Trick 1146: Create ISO Dates using TEXT function and Custom Number Format	1:46	2014-10-29
1511	Excel 2013 PowerPivot Basics #09: Measures (Calculated Fields) & DAX Functions 9 Examples	29:50	2014-10-26
1512	Excel Magic Trick 1144 Top 3 TEXT Function uses ISO Date to Date , Text Time To Time , Date To Month	9:54	2014-10-24
1513	Excel Magic Trick 1145: Create Random Data Set with Formulas: 4 Unusual Formulas	14:02	2014-10-24
1514	Excel 2013 PowerPivot Basics #8: Edit Existing Connections, Import New Data, Existing Reports Update	7:29	2014-10-19
1515	Excel 2013 PowerPivot Basics 7: Calendar Table Calculated Columns: Month Year Quarter Fiscal Quarter	23:00	2014-10-17
1516	PivotTables Are Easy! 30 Examples for Highline College Professional Development Day 2014	44:09	2014-10-17
1517	Excel 2013 PowerPivot Basics 6: Import, Filter, Edit From Multiple Data Sources: Access, Excel, Text	20:26	2014-10-14
1518	Excel Magic Trick 1143: Extract Content From Non-Empty Cells: Filter or Array Formula?	11:09	2014-10-11
1519	Excel 2013 PowerPivot Basics #05: Import External Excel Tables, Build Data Model with SUMX function	16:53	2014-10-11
1520	Excel 2013 PowerPivot Basics #03: Replace VLOOKUP with Excel 2013 Data Model & Relationships	7:24	2014-10-10
1521	Excel 2013 PowerPivot Basics #02: Import Large Non-Normalized Data Set To Reduce File Size	5:03	2014-10-10
1522	Excel 2013 PowerPivot Basics #04: DAX Formulas Can Be Easier & Faster Than Array Formulas	9:19	2014-10-10
1523	Excel 2013 PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013	38:33	2014-10-08
1524	Mr Excel & excelisfun Trick 166: Conditionally Format Row Based On Upper And Lower Value	11:36	2014-10-02
1525	Mr Excel & excelisfun Trick 165: Lookup To Find Three Values In A Row	7:05	2014-09-26
1526	Excel Dueling Movie with Mr Excel and excelisfun and Szilvia Juhasz	0:35	2014-09-26
1527	Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2	2:52	2014-09-22
1528	Excel Magic Trick 1141: Link Access Table To Excel Data Source	3:48	2014-09-22
1529	Highline Excel 2013 Chemistry Video #1: Basic Excel: Data Entry, Formatting, Charting & Formulas	37:19	2014-09-21
1530	Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels	8:14	2014-09-18
1531	Excel Magic Trick 1139: Defined Names: 1) Create From Selection & 2) Apply Names	4:01	2014-09-18
1532	Excel Magic Trick 1138: Basic Future Value Calculation: FV Function or Math Formula	6:07	2014-09-18
1533	excelisfun back after Bad Health, but PowerPivot Series Postponed, Stats Series Next	0:50	2014-09-18
1534	Mr Excel & excelisfun Trick 164: Sometimes VBA Is The Only Way To Go: Formula Too Long	16:12	2014-08-24
1535	excelisfun Off The Air Due To Bad Health, More Excel videos soon...	0:10	2014-08-21
1536	Mr Excel & excelisfun Trick 163: Monthly Expense Given End Date & Expense Name: Formula or Pivot?	6:53	2014-08-08
1537	Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP	12:23	2014-08-04
1538	Mr Excel & excelisfun Trick 162 Count Between Upper Lower Time: Data Table COUNTIFS SUMPRODUCT	8:27	2014-08-01
1539	Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together	9:49	2014-07-30
1540	Excel Magic Trick 1134: IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples	29:49	2014-07-29
1541	Excel Magic Trick 1135: Rank Values From Two Columns: RANK.AVE, RANK.EQ & RANK Functions	7:43	2014-07-28
1542	Mr Excel & excelisfun Trick 161: Create Report From Three Tables: VLOOKUP and PowerPivot	7:42	2014-07-25
1543	Mr Excel & excelisfun Trick 160: Adding With Criteria From Ranges With Different Dimensions	7:06	2014-07-18
1544	Excel Magic Trick 1133: Aging Accounts Receivable Reports: PivotTable & Unique Identifier	9:37	2014-07-16
1545	Excel Magic Trick 1132: Extract and Sort Numbers Greater Than Zero with Formula	3:23	2014-07-16
1546	Excel Magic Trick 1129: Aging Accounts Receivable Reports Using Slicer, Excel Table, Page Setup	9:20	2014-07-15
1547	Excel Magic Trick 1130: Aging Accounts Receivable Reports Using Advanced Filter & Page Setup	6:51	2014-07-15
1548	Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable	6:55	2014-07-15
1549	Excel Magic Trick 1128: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula	26:34	2014-07-13
1550	Mr Excel & excelisfun Trick 159: Three Way Lookup: SUMIFS or DGET?	5:41	2014-07-10
1551	Excel Magic Trick 1127: Automatically Track Budget Start, Change & Ending Balances In Excel	18:14	2014-07-04
1552	Excel Magic Trick 1125: Data Validation Custom Formula: Workday Dates in Current Month	8:21	2014-06-26
1553	Excel Magic Trick 1126: Populate Calendar with "X" Based on Start, End, Weekend & Holiday Dates	8:30	2014-06-26
1554	Excel Magic Trick 1124: Conditional Format Sundays & Weekends: NETWORKDAYS.INTL & NOT functions	6:05	2014-06-26
1555	Excel Magic Trick 1123: Dynamic Formula To Create A List of Dates For Month	4:44	2014-06-26
1556	Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula	11:57	2014-06-12
1557	Excel Magic Trick 1121: Excel 2013 RRI Function: Calculate Compounding Rate/Geometric Mean	5:32	2014-05-30
1558	Excel Magic Trick 1120: Is Item in All Three Lists?	2:23	2014-05-30
1559	Excel Magic Trick 1119: Conditional Format Date when 44 Days Have Passed	5:21	2014-05-30
1560	Excel Magic Trick 1117: Calculate Average For Each Sample: AVERAGEIFS, PivotTable, or OFFSET	11:03	2014-05-23
1561	Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods	6:58	2014-05-23
1562	Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently	13:06	2014-05-23
1563	Excel Magic Trick 1113: Extract All Characters In Cell To Separate Cells: PPPP to P, P, P, P	4:31	2014-05-17
1564	Excel Magic Trick 1114: Formula For Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 2...	6:30	2014-05-17
1565	Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column	1:13	2014-05-17
1566	Excel Magic Trick 1112: Clean Transactional Data, Then Create PivotTable Monthly Cost Report	7:51	2014-05-15
1567	Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formula	5:11	2014-05-15
1568	Excel Magic Trick 1108: Compare 2 Lists and Extract Records: Filter Method	5:12	2014-05-13
1569	Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method	12:59	2014-05-13
1570	Excel Magic Trick 1109: Compare 2 Lists and Extract Records: Advanced Filter Method	5:17	2014-05-13
1571	Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?	9:01	2014-05-05
1572	Excel Magic Trick 1106: 3-D Gradient Conditional Formatting For Row with AND Criteria	4:35	2014-05-04
1573	Excel Magic Trick 1105: Minimum With Two Criteria: When NOT to use Array Formula: DMIN	3:04	2014-05-03
1574	Mr Excel & excelisfun Trick 158: Lookup Variable Shipping Rate For All Dates Between A Start & End	8:26	2014-05-02
1575	Excel Magic Trick 1104: Add with 6 Criteria (AND and OR Criteria) with Criteria/Data Mismatch	14:22	2014-05-01
1576	Excel TV: Interview with Mike excelisfun Girvin, Upcoming Event!	1:02	2014-04-25
1577	Excel Magic Trick 1103: Formulas for Quarters, Fiscal Quarters & Fiscal Years	8:51	2014-04-25
1578	Excel Magic Trick 1101: Calculate MEDIAN Based On Lower/Upper Date, Exclude Holidays & Weekends	16:10	2014-04-21
1579	Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR	2:52	2014-04-21
1580	Mr Excel & excelisfun Trick 157: If Project Finished, Mark All Related Records As Finished	5:26	2014-04-21
1581	Excel Magic Trick 1100: Cross Tabulated Lookup: 1) Lookup Row then match or 2) Array Multiplication?	14:11	2014-04-17
1582	Excel Magic Trick 1099: Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range	7:28	2014-04-17
1583	Excel Magic Trick 1098: Compare Two E-mail Lists with Formula: E-mail In List? Not In List?	5:14	2014-04-17
1584	Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting	8:38	2014-04-11
1585	Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formula	3:56	2014-04-11
1586	Excel Magic Trick 1095: Count Doubles & Triples Using FREQUENCY function (better than COUNTIF)	3:46	2014-04-10
1587	Excel Magic Trick 1094: Wildcards for Sheet References and INDIRECT function	3:39	2014-04-05
1588	Excel Magic Trick 1093: Extract Date from Middle of Description: Text To Columns or Formula?	5:33	2014-04-05
1589	Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel	6:00	2014-04-03
1590	Excel Magic Trick 1091: Count Number of Items In Row For First Occurrence of Each Group	9:07	2014-04-01
1591	Talk "Live" with Microsoft Excel Team on Reddit	0:32	2014-04-01
1592	Excel Magic Trick 1090: MEDIAN Function 3 Amazing Uses: OR Criteria, Payroll, Commissions	9:21	2014-03-29
1593	Excel Magic Trick 1086: 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch	10:33	2014-03-27
1594	Excel Magic Trick 1087: OR & IF Function & Conditional Format: Number Outside Lower & Upper Hurdle	9:41	2014-03-27
1595	Excel Magic Trick 1088: Show All B7 values From Across Sheets with Names 01, 02, 03, ...10, 11...	5:05	2014-03-27
1596	Excel Magic Trick 1089: Month, Year To Date and Variances with SUMIFS, PodCast 1873 Mr Excel	7:26	2014-03-27
1597	Mr Excel & excelisfun Trick 156: Find Unmatched Positive & Negative Numbers In A Column	11:23	2014-03-21
1598	Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text)	12:53	2014-03-16
1599	Excel Magic Trick 1084: ISODD or ISEVEN Functions to Help Add Every Other Column	3:20	2014-03-14
1600	Mr Excel & excelisfun Trick 155: List Names of People Who Have Not Signed	17:07	2014-03-14

1601	Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column)	7:57	2014-03-13
1602	Excel Magic Trick 1083: SUMIFS: Add Invoice Amounts Between Start & End Dates (Adding For Period)	3:46	2014-03-13
1603	Mr Excel & excelisfun & Bill Szysz Trick 154 Part 2: Totals by Product Codes like: 2871TBS	3:06	2014-03-10
1604	Mr Excel & excelisfun Trick 154: Totals by Product Code: Numbers & Code in Same Cell!?	10:39	2014-03-08
1605	Ctrl + Shift + Enter: Excel Array Formulas Video # 24: 26 Amazing Array Formulas	1:20:51	2014-03-04
1606	Excel Magic Trick 1080: Age From Alphanumeric Text String, Has Incomplete Date Year = 20?? or 19??	7:18	2014-03-03
1607	Excel Magic Trick 1079 IF Function 4 Letters To Start TextString = Underage, 6 Letters = 18 or Older	4:01	2014-03-03
1608	Excel Magic Trick 1077: Floating Cell In Excel? Watch Window to See Formula Anywhere in Workbook	3:21	2014-02-28
1609	Excel Magic Trick 1078: Total Cost Based On Per Minute Charge & Excel Time Values Nearest 15 Seconds	5:50	2014-02-28
1610	Mr Excel & excelisfun Trick 153: Show Day Numbers From Start & End Date: VBA or Formula?	7:33	2014-02-28
1611	Excel Magic Trick 1076: Convert Date-Time Values to Serial Numbers w TEXT & Custom Number Format	3:36	2014-02-26
1612	Excel Magic Trick 1075: Allocate Hours Across Workdays For Each Month Between Start & End Date	7:41	2014-02-26
1613	Excel Magic Trick 1074: Multiply Quantity Times Debit or Credit: 3 Formulas Examples.	3:47	2014-02-24
1614	Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL	22:03	2014-02-23
1615	Ctrl + Shift + Enter: Excel Array Formulas 23: LINEST Array Function	12:32	2014-02-23
1616	Mr Excel & excelisfun Trick 152: Allocate Yearly Cost Across a Different # of Months for Each Record	4:40	2014-02-21
1617	Ctrl + Shift + Enter: Excel Array Formulas 22: Excel 2010 Array Function: MODE.MULT	9:31	2014-02-21
1618	Ctrl + Shift + Enter: Excel Array Formulas 21: Conditional Formatting with Array Formulas	16:02	2014-02-19
1619	Excel Magic Trick 1072: Conditionally Format Partial Row Based On Start Month, End Month & Product	10:35	2014-02-19
1620	Excel Magic Trick 1071: Dynamic Range Based on Product and Start & End Month: OFFSET, INDEX or AF?	21:59	2014-02-15
1621	Excel Magic Trick 1069: Displaying Decimal and Fractional Inches in Excel: 1/3" or 2.5" or 2 1/3"	4:06	2014-02-15
1622	Excel Magic Trick 1070: 4 "Yes" Votes Out of 12 as "4/12" with COUNTIF and COUNTA Functions	3:15	2014-02-15
1623	Mr Excel & excelisfun Trick 151: Put 1 of 2 Formulas into Cell Based on 2 Conditions: IF or CHOOSE	5:28	2014-02-14
1624	Ctrl + Shift + Enter: Excel Array Formulas 20: Extract Unique Lists & Sorting Formulas	54:46	2014-02-13
1625	Ctrl + Shift + Enter: Excel Array Formulas 19: Array Function: MMULT	24:18	2014-02-10
1626	Seattle Snow Feb 9 2014: Snow Ball In Face Revenge. Kid Tries To Throw HUGE SnowBall	1:02	2014-02-09
1627	Excel Magic Trick 1068: TEXT and FIXED functions for Formatting Numbers in Text Formulas	3:37	2014-02-09
1628	Seattle Snow Feb 8 2014. at Night.	1:33	2014-02-09
1629	Excel Magic Trick 1067: Displaying Fractional Percent in Excel like: 33 1/3 % or 3/10%	3:56	2014-02-08
1630	Mr Excel & excelisfun Trick 150: Lookup First Item when Other Column Contains Greater Than 100	6:39	2014-02-07
1631	Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function?	41:18	2014-02-04
1632	Ctrl + Shift + Enter: Excel Array Formulas 17: FREQUENCY Array Function Basics	11:50	2014-02-04
1633	Ctrl + Shift + Enter: Excel Array Formulas 16: Formulas To Extract Records With Criteria 23 examples	1:14:12	2014-01-29
1634	Ctrl + Shift + Enter: Excel Array Formulas 15: General Guidelines For Array Formulas	2:02	2014-01-29
1635	Ctrl + Shift + Enter: Excel Array Formulas 14: Boolean Logic, AND & OR criteria, Convert TRUE FALSE	27:16	2014-01-28
1636	Ctrl + Shift + Enter: Excel Array Formulas 13: Dynamic Ranges: INDEX & OFFSET Functions	1:00:22	2014-01-23
1637	Ctrl + Shift + Enter: Excel Array Formulas 12: SUMIFS, COUNTIFS, SUMIF, COUNTIF, AVERAGEIF	12:27	2014-01-21
1638	Ctrl + Shift + Enter: Excel Array Formulas 11: AGGREGATE, INDEX, LOOKUP, SUMPRODUCT	19:46	2014-01-19
1639	Ctrl + Shift + Enter: Excel Array Formulas 10: LOOKUP Function: Array Operations wOut CtrlShiftEnter	17:02	2014-01-18
1640	Ctrl + Shift + Enter: Excel Array Formulas 09: SUMPRODUCT Function: 21 Examples, Including Timing	45:17	2014-01-16
1641	Ctrl + Shift + Enter: Excel Array Formulas 08: Array Formula: Multiple Values To Multiple Cells	6:47	2014-01-15
1642	Ctrl + Shift + Enter: Excel Array Formulas #07: Introduction To Array Functions. TRANSPOSE Function	9:10	2014-01-12
1643	Ctrl + Shift + Enter: Excel Array Formulas #06: Array Constants in Top 3 Formula, VLOOKUP, more	16:54	2014-01-11
1644	Mr Excel & excelisfun Trick 149: Add or Count With OR Criteria: Epic Dual 13 Example Video	11:58	2014-01-10
1645	Ctrl + Shift + Enter: Excel Array Formulas #05: Function Argument Array Operations	8:21	2014-01-09
1646	Excel Magic Trick 1065: SUMIFS: Month Over Month Sales Calculations From Transactional Data Set	6:51	2014-01-09
1647	Excel Magic Trick 1066: PivotTable: Month Over Month Sales Calculations From Transactional Data Set	2:23	2014-01-09
1648	Excel Magic Trick 1064: Copy Formulas Even More Quickly With F5 Key and Shift + Enter	1:30	2014-01-09
1649	Ctrl + Shift + Enter: Excel Array Formulas #04.5: Join Array Operation or SUMIFS Function?	4:18	2014-01-08
1650	Excel Magic Trick 1063: Pull Student Grades From Many Sheets onto Summary Table Excel Grade Book	18:38	2014-01-05
1651	Ctrl + Shift + Enter: Excel Array Formulas #04: Join Array Operation & Alternatives Such as DGET	14:43	2014-01-05
1652	Ctrl + Shift + Enter: Excel Array Formulas #03: Comparative Array Operations, & Alternatives	14:50	2014-01-04
1653	Excel Magic Trick 1062: SUMIFS: Year Over Year Sales Calculations From Transactional Data Set	7:23	2014-01-04
1654	Excel Magic Trick 1061: Copy Formulas Quickly With Name Box and Shift Key (Horizontal or Vertical)	1:32	2014-01-04
1655	Mr Excel & excelisfun Trick 148: Logical Formula: 3 Out Of 4 Tests Are Met, Deliver a TRUE	5:29	2014-01-03
1656	Excel Magic Trick 1060: Double Click To Copy Formulas Down Column, 5 Examples (Some Empty Cells)	2:33	2014-01-03
1657	Ctrl + Shift + Enter: Excel Array Formulas #02: Introduction Array Formulas & Math Array Operation	19:18	2014-01-01
1658	Ctrl + Shift + Enter: Excel Array Formulas #01: Review Formula Basics (15 Important Examples)	59:26	2013-12-30
1659	Ctrl + Shift + Enter: Excel Array Formulas #00: Intro To DVD and Video Series	7:34	2013-12-30
1660	Microsoft Virtual Academy: Free Classes From Microsoft: Amazing Free Computer School	0:56	2013-12-28
1661	Excel Magic Trick 1059: Conditionally Format Top 5 Numbers That Are Also Greater Than 65	5:11	2013-12-28
1662	Excel Magic Trick 1056: Excel 2013 Slicer Formulas	12:45	2013-12-27
1663	Excel Magic Trick 1057: Calculate Hours Worked From Text Time Values, Including Night Shift	6:43	2013-12-27
1664	Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00")	3:10	2013-12-27
1665	Mr Excel & excelisfun Trick 147: Avoid Sheet References From Current Sheet: View Or Arguments Dialog	3:42	2013-12-27
1666	Excelisfunner, Mr Excel & excelisfun Trick 146: For Kids Multiplying In Excel Is Amazing!	4:02	2013-12-26
1667	Highline Excel 2013 Class Video 51: Recorded Macro Basics, including Absolute & Relative References	33:16	2013-12-24
1668	Highline Excel 2013 Class Video 50: Financial Functions: PMT, RATE, NPER and FV 12 Examples	41:06	2013-12-24
1669	Highline Excel 2013 Class Video 49: Break Even Analysis Formulas & Chart, Plotting Break Even Point	13:26	2013-12-22
1670	Highline Excel 2013 Class Video 48: Conditional Formatting: Bar Chart with Data Labels	2:24	2013-12-22
1671	Highline Excel 2013 Class Video 47: Statistics: Dot Plot (Cell Chart)	2:38	2013-12-22
1672	Highline Excel 2013 Class Video 46: Statistics: Histogram Formulas & Chart in Excel 2013	12:35	2013-12-22
1673	Highline Excel 2013 Class Video 41: Review Of Chart Basics For Excel 2013	43:39	2013-12-22
1674	Highline Excel 2013 Class Video 45: Combining Chart Types and Secondary Axis in Excel 2013	3:59	2013-12-22
1675	Highline Excel 2013 Class Video 44: Pie within Pie Chart in Excel 2013	2:45	2013-12-22
1676	Highline Excel 2013 Class Video 43: Set Default Chart in Excel 2013, Keyboard Shortcuts Charts	2:03	2013-12-22
1677	Highline Excel 2013 Class Video 42: Save Chart As Template in Excel 2013	3:48	2013-12-22
1678	Mr Excel & excelisfun Trick 145: YYYYMMDD Numbers To Dates: TTC, Flash Fill, DATE or TEXT Functions?	6:23	2013-12-21
1679	Office 2013 Class #51: Fix Word 2013 Mail Merge Number Format Problem: Excel & Access Data Source	22:06	2013-12-21
1680	Office 2013 Class #48: Creating Queries In Access 2013 (15 Examples)	30:28	2013-12-18
1681	Office 2013 Class #50: Export Data From Access To Excel, PDF or Text File	4:54	2013-12-17
1682	Office 2013 Class #49: Create Report Based On A Query in Access 2013	8:18	2013-12-17
1683	Office 2013 Class 47: Access 2013: Create Database, Import Excel, Create Table, Forms, Relationships	31:39	2013-12-17
1684	Office 2013 Class #46: Introduction to Databases and Access 2013	29:20	2013-12-17
1685	Highline Excel 2013 Class Video 40: Conditional Formatting Basic To Advanced 50 Examples	1:28:15	2013-11-28
1686	Office 2013 Class #45, Excel Basics 27: VLOOKUP Function Made Easy 24 Examples - How To Use VLOOKUP	33:41	2013-11-25
1687	Office 2013 Class #44, Excel Basics 26: IF Function Made Easy 8 Examples	12:08	2013-11-23
1688	Highline Excel 2013 Class Video 37: Excel Advanced Filter Extract Data 26 Examples Basic - Advanced	30:26	2013-11-23
1689	Highline Excel 2013 Class Video 39: Excel Import Data: Text File, CSV File, Access, Excel File	10:04	2013-11-23
1690	Highline Excel 2013 Class Video 38: Excel Text To Columns To Split or Convert Data 7 Examples	10:14	2013-11-23
1691	Highline Excel 2013 Class Video 36: Excel Filter For Extracting Records with AND or OR Criteria	15:06	2013-11-23
1692	Excel Truel: Excelisfunner (Isaac 7 Years old), Mr Excel & excelisfun Trick 144: Excel Mirror Fun	5:28	2013-11-22
1693	Office 2013 Class 43, Excel Basics 25, Excel 2013 Charts: Chart Types, Chart Formatting, more	43:39	2013-11-19
1694	Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples	1:21:50	2013-11-16
1695	Highline Excel 2013 Class Video 34: Excel Subtotals, Add Subtotals based on One or Two Columns	12:48	2013-11-15
1696	Highline Excel 2013 Class Video 33: Sorting In Excel. Excel Sort (13 Examples)	18:11	2013-11-15
1697	Office 2013 Class #42: Excel Basics 24: Pivot Tables for Data Analysis (21 Examples)	32:40	2013-11-14
1698	Office 2013 Class #41: Excel Basics 23: Sort and Filter, Basic Data Analysis (24 Examples)	25:55	2013-11-14
1699	Highline Excel 2013 Class Video 32: Introduction To Array Formulas and Array Functions	34:06	2013-11-09
1700	Highline Excel 2013 Class Video 27: How To Track Down Excel Formula Errors (16 Examples)	21:36	2013-11-08

1701	Highline Excel 2013 Class Video 28: Excel Data Validation: List, Date, Time, Custom (22 Examples)	24:25	2013-11-08
1702	Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples)	30:48	2013-11-08
1703	Highline Excel 2013 Class Video 29: Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example)	12:22	2013-11-08
1704	Highline Excel 2013 Class Video 31: Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More	11:37	2013-11-08
1705	Office 2013 Class #39: Excel Basics 21: Orientate Formula Inputs To Allow Mixed Cell References	13:29	2013-11-06
1706	Office 2013 Class #38: Excel Basics 20: Relative, Absolute and Mixed Cell References	28:38	2013-11-06
1707	Office 2013 Class #40: Excel Basics 22: Don't Violate Excel's Golden Rule	8:22	2013-11-06
1708	Office 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/Conditions	24:31	2013-11-04
1709	Office 2013 Class #36: Excel Basics 18: Excel Defined Names & Built-in Functions	12:46	2013-11-04
1710	Office 2013 Class #35: Excel Basics 17: Search for Excel Functions: PMT & MEDIAN Functions	17:41	2013-11-04
1711	Office 2013 Class #29: Excel Basics 11: Number Formatting & Formulas Don't Get Tricked By The Façade	28:31	2013-10-31
1712	Office 2013 Class #28: Excel Basics 10: Style Formatting: By Hand, Cell, Table & Conditional Format	22:49	2013-10-31
1713	Office 2013 Class #31: Excel Basics 13: Examples of Excel Formulas & Formula Elements	12:23	2013-10-31
1714	Office 2013 Class #30: Excel Basics 12: ROUND function: When and How to use it in Business	10:10	2013-10-31
1715	Office 2013 Class #32: Excel Basics 14: Math and Order of Operations in Excel Formulas	2:41	2013-10-31
1716	Office 2013 Class #33: Excel Basics 15: Entering Cell References in Formulas & Edit Mode Status Bar	3:39	2013-10-31
1717	Office 2013 Class #34: Excel Basics 16: Flash Fill To Combine or Extract Text	4:00	2013-10-31
1718	YouTube Comments Not Showing? Help? Anyone know how to fix this?	0:37	2013-10-29
1719	Office 2013 Class #23: Excel Basics 05: Customize the Quick Access Toolbar and Ribbon	5:47	2013-10-29
1720	Office 2013 Class #24: Excel Basics 6: Excel Keyboard Shortcuts Are Fast! 10 Examples.	11:31	2013-10-29
1721	Office 2013 Class #25: Excel Basics 07: What Excel Does: Calculations and Data Analysis	6:23	2013-10-29
1722	Office 2013 Class #26: Excel Basics 08: Default Alignment In Excel. Numbers stored As Text Trouble	4:05	2013-10-29
1723	Office 2013 Class #27: Excel Basics 09: Keeping Data in Excel: Proper Data Set or Excel Table	13:18	2013-10-29
1724	Office 2013 Class #22: Excel Basics 04: PivotTables Are Easy! SUMIFS or PivotTable for Region Report	13:29	2013-10-26
1725	Highline Excel 2013 Class Video 26: Excel Compare Two Lists Formula: Item In List? Item Not In List?	6:15	2013-10-25
1726	Office 2013 Class #21: Excel Basics 03: Count & Add: COUNT, COUNTA, SUM, COUNTIFS, SUMIFS functions	12:28	2013-10-25
1727	Office 2013 Class #20: Excel Basics 02: Formula Inputs For Formulas and Charts & Excel's Golden Rule	31:17	2013-10-25
1728	Office 2013 Class #19: Excel Basics 1: Excel Grid, Formatting, Formulas, Cell References, Page Setup	50:48	2013-10-24
1729	Highline Excel 2013 Class Video 18: VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP	42:00	2013-10-19
1730	Highline Excel 2013 Class Video 19: Text Functions RIGHT, LEFT, MID, SEARCH for Partial Text VLOOKUP	11:13	2013-10-19
1731	Highline Excel 2013 Class Video 20: VLOOKUP, DGET & MATCH For Looking Up Records 7 Examples	20:56	2013-10-19
1732	Highline Excel 2013 Class Video 21: INDEX and MATCH Functions For Unusual Lookups 4 Examples	19:33	2013-10-19
1733	Highline Excel 2013 Class Video 22: CHOOSE function to lookup table for VLOOKUP With Multiple Tables	6:46	2013-10-19
1734	Highline Excel 2013 Class Video 24: Getting Top 5 Values With LARGE And Bottom 5 With SMALL	5:26	2013-10-19
1735	Highline Excel 2013 Class Video 23: VLOOKUP and IFNA for Commissions	2:24	2013-10-19
1736	Highline Excel 2013 Class Video 25: Goal Seek: Get Formula To Evaluate To Desired Result	3:38	2013-10-19
1737	Highline Excel 2013 Class Video 10: AND & BETWEEN Criteria: SUMIFS, DSUM, COUNTIFS, AVERAGEIFS	39:18	2013-10-17
1738	Office 2013 Class #18: Creating A PowerPoint Presentation	36:02	2013-10-17
1739	Highline Excel 2013 Class Video 09: Defined Names & Aggregate Functions	13:15	2013-10-17
1740	Office 2013 Class #17: Word 2013 Heading Styles To Create Automatic TOC & PowerPoint	14:11	2013-10-17
1741	Office 2013 Class #17.5: Word 2013 Basic PowerPoint Formatting	6:02	2013-10-17
1742	Office 2013 Class #16: Bulleted, Numbered and Multileveled Lists	8:59	2013-10-13
1743	Highline Excel 2013 Class Video 11: Calculations With OR Criteria: COUNTIFS, DCOUNTA, SUMIFS, DSUM	22:57	2013-10-12
1744	Highline Excel 2013 Class Video 12: AND & OR Criteria Calculations: D Functions like DSUM, DCOUNT	9:00	2013-10-12
1745	Highline Excel 2013 Class Video 15: IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs	26:17	2013-10-12
1746	Highline Excel 2013 Class Video 13: AND & OR Criteria Calculations: Table Feature	5:34	2013-10-12
1747	Highline Excel 2013 Class Video 14: AND, OR, IF Functions For AR Dept (Multiple Logical Tests)	13:37	2013-10-12
1748	Highline Excel 2013 Class Video 16: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more...	8:34	2013-10-12
1749	Highline Excel 2013 Class Video 17: Introduction To SUMPRODUCT Function	10:02	2013-10-12
1750	Office 2013 Class #15: Word 2013: Letterhead, Save As Template, Business Letter	9:16	2013-10-12
1751	Office 2013 Class #14: Word Set Tabs: Left, Center, Right, Decimal, Bar, Leader, and the Ruler	6:16	2013-10-12
1752	Mr Excel & excelisfun Trick 143: EBAY VLOOKUP: Percentage or Max Amount	8:11	2013-10-10
1753	Office 2013 Class #13: Word Tables and Excel Tables In Word With Paste Special Link	14:13	2013-10-10
1754	Office 2013 Class #12: Word Paste Special "Text Only" Keyboards: Right-Click key, Ctrl Smart Tag	2:18	2013-10-10
1755	Office 2013 Class #11: Word Nonbreaking Space & Nonbreaking Hyphen Keyboards	1:32	2013-10-10
1756	Office 2013 Class #10: AutoCorrect versus AutoText	3:23	2013-10-09
1757	Office 2013 Class #08: Three Levels Of Formatting In Word: Character, Paragraph & Section	15:34	2013-10-06
1758	Office 2013 Class #09: Word Research Paper Tricks	18:46	2013-10-06
1759	Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex.	25:47	2013-10-04
1760	Highline Excel 2013 Class Video 07: Worksheet & Workbook References, 3-D Cell References	11:21	2013-10-04
1761	Highline Excel 2013 Class Video 06: Scenarios To Save Sets Of Formula Inputs, Paste Special Trick	6:01	2013-10-04
1762	Mr Excel & excelisfun Trick 142: AVERAGE IF Before Excel 2003, Average with 1 Condition	8:45	2013-10-04
1763	Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)	37:12	2013-10-03
1764	Highline Excel 2013 Class Video 04: Percentage Increase or Decrease Formula	4:51	2013-10-02
1765	Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel	15:23	2013-10-02
1766	Highline Excel 2013 Class Video 02: Comprehensive Excel Formula Types & Elements Video 12 Examples	33:55	2013-10-02
1767	Office 2013 Class #06: Spell Check Task Pane in Word 2013 & Auto Correct To Create Shorthand	12:24	2013-09-28
1768	Office 2013 Class #07: Word Hyperlinks & Save As Web Page	9:40	2013-09-28
1769	Office 2013 Class #05: Word Flyer Project, Formatting Text, Insert Picture, Formatting Keyboards	18:50	2013-09-28
1770	Excel Magic Trick 1055: Grading: Calculate Current Percentage & Decimal Grade	9:19	2013-09-27
1771	Mr Excel & excelisfun Trick 141: Lookup 3 Items in 3 tables: VLOOKUP, LOOKUP, VBA, Array?	12:18	2013-09-27
1772	Office 2013 Class #04: Intro To Word: Non-Printing Characters, Navigation & Selection Tricks, More	25:13	2013-09-27
1773	Highline Excel 2013 Class Video 01: Back To Basics: Number Format, Keyboards, PivotTables, Formulas	1:42:38	2013-09-23
1774	Mr Excel & excelisfun Trick 140: Extract Text From Cell: Flash Fill, Formula or VBA?	11:38	2013-09-20
1775	Excelisfun Facebook Is No More.	0:32	2013-09-19
1776	Office 2013 Class #03: Windows Explorer: Build System Of Folders To Keep Track Of Files	9:22	2013-09-15
1777	Office 2013 Class #02: Windows Explorer For File Management	18:48	2013-09-15
1778	Mr Excel & excelisfun Trick 139: Formula To List Employees By Department	7:38	2013-09-13
1779	Office 2013 Class #01: Introduction To Windows Explorer, Folders, Files, Ribbon, QAT, Save As	32:45	2013-09-13
1780	Excel Magic Trick 1054: Change Absolute Cell Reference Each Time Column Has New Text Entry	3:28	2013-09-10
1781	Mr Excel excelisfun Trick 138: NETWORKDAYS.INTL Amazing New "Any Weekend" Argumnet	7:52	2013-09-09
1782	Excel Magic Trick 1053: Unique Count With Criteria: Excel 2013 PivotTable Distinct Count Function	7:17	2013-09-08
1783	Excel Magic Trick 1052: Best New Feature In Excel 2013: Recommended Charts & PivotTables	2:15	2013-09-06
1784	Excel Magic Trick 1051: Save Excel As PDF, Fast Method: F12 Key and Change File Extension	1:00	2013-09-06
1785	Excel Magic Trick 1050: Excel 2013 Sheet Navigation Arrows For Go To Last Or First Sheet Where?	1:21	2013-09-06
1786	Excel Magic Trick 1049: Copy Page Setup From One Sheet To Another	1:51	2013-09-06
1787	Excel Magic Trick 1048: Clear Page Setup In Excel, Trick To Do It Fast	1:39	2013-09-06
1788	What's New In Excel 2013: Flash Fill, Functions, Data Model, PowerPivot, New Charts, Table Slicers..	1:25:17	2013-09-04
1789	Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards	2:44:10	2013-08-29
1790	Excel Magic Trick 1047: "Number 225", & "Text 225.00" Same For COUNTIF, SUMIFS, DSUM, DCOUNT??	5:38	2013-08-23
1791	Mr Excel excelisfun Trick 137: Start and End Date, What is Total Pay Over Period Given Month Salary?	12:19	2013-08-23
1792	Excel Magic Trick 1044: Formula To Extract & Sort Unique List Of Numbers Contains Empty Cells & Text	8:30	2013-08-17
1793	Excel Magic Trick 1043: Count Unique Numbers in Column with Empty Cells and Text (Mixed Data)	7:00	2013-08-17
1794	Excel Magic Trick 1046: Linear Regression Estimate & Add Many Predicted Y-Values Single Cell Formula	1:53	2013-08-17
1795	Excel Magic Trick 1045: Conditionally Format Multiple Modes in a Column, Excel 2010 or Later	3:45	2013-08-17
1796	Mr Excel & excelisfun Trick 136: Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP?	7:26	2013-08-17
1797	Excel Magic Trick 1042 Array Functions Housed In Other Functions Usually Don't Need Ctrl Shift Enter	7:37	2013-08-14
1798	Excel Magic Trick 1041: Expandable Range In An Excel Table For Running Total (Zack Barresse's Trick)	3:03	2013-08-14
1799	Excel Magic Trick 1039: Turn Off Animation In Excel 2013	1:21	2013-08-12
1800	Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text	8:58	2013-08-12

1801	Excel Magic Trick 1038: Make Table Reference Absolute With Colon and Double Square Brackets	4:26	2013-08-09
1802	Excel Magic Trick 1037: Make Table Reference Absolute by Copying And Pasting Instead Of Dragging	3:16	2013-08-09
1803	Mr Excel & excelisfun Trick 135: From Text to Math: VBA or Excel 4 Macro Function: EVALUATION	7:49	2013-08-09
1804	Excel Magic Trick 1036: SUM Rectangular Table, 1 condition Row Headers & Or Criteria Column Headers	6:02	2013-08-05
1805	Excel Magic Trick 1035: Calculate Median with 1 condition with AGGREGATE & PERCENTILE.INC function	5:56	2013-08-05
1806	Excel Magic Trick 1034: Convert Summarized Table To Proper Data Set With PivotTable Trick	3:19	2013-08-05
1807	Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable	6:16	2013-08-05
1808	Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables	10:08	2013-08-03
1809	Excel Magic Trick 1032: Add Record Count Column To Filtered Table (Fix SUBTOTAL Filter bug)	4:48	2013-08-03
1810	Learn Excel PowerPivot From Chandoo and Rob	0:50	2013-08-02
1811	Mr Excel & excelisfun Trick 134: Merge Product and Sub-Product Text; VBA or Wild INDEX Formula	9:51	2013-08-02
1812	Excel Magic Trick 1030: Round To The Nearest $50 For Pricing or To The Nearest Second For Times	4:28	2013-08-01
1813	Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible...	5:13	2013-07-31
1814	Excel Magic Trick 1028: Create Hyperlinks to Duplicate Text Titles In Column A On Different Sheet	9:50	2013-07-30
1815	Mr Excel & excelisfun Trick 133: Add Nth Largest Values With Three Criteria Dynamic Formulas	8:21	2013-07-26
1816	Excel Magic Trick 1027: Array Formula To Count Unique Yes Votes For A Given First & Last Name	9:41	2013-07-26
1817	Excel Magic Trick 1026: Conditionally Format 1st Occurrence of Yes Vote For Given First & Last Name	6:16	2013-07-26
1818	Excel Magic Trick 1025: Remove Asterisk From All Text Items In Column: SUBSTITUTE & TRIM	2:48	2013-07-26
1819	Excel Accounting Schedule of Expected Cash Collections Using A Set Of Assumptions / Formula Inputs	40:00	2013-07-25
1820	Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List	14:42	2013-07-24
1821	Excel Magic Trick 1024: SUMIF & SUMIFS function & Mixed Cell References & Dynamic Table Range	10:26	2013-07-23
1822	Excel Magic Trick 1022: Sample Chapters of Ctrl + Shift + Enter Book & SUMPRODUCT example	2:52	2013-07-22
1823	Mr Excel & excelisfun Trick 132: Baseball and Stock Statistics with DOLLARDE and DOLLARFR functions	6:31	2013-07-21
1824	Excel Magic Trick 1021: Implicit Intersection or #VALUE Error: No Ctrl + Shift + Enter	7:26	2013-07-17
1825	Excel Magic Trick 1017: BMX State Point Calculation Worksheet: VLOOKUP and Data Validation List	23:26	2013-07-16
1826	Excel Magic Trick 1020: What Lens Do You Look Through When Solving Excel Problems	9:55	2013-07-16
1827	Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment	2:28	2013-07-16
1828	Excel Magic Trick 1019: Formula For Text Month Labels From Serial Date: EDATE, TEXT & COLUMNS	4:01	2013-07-16
1829	Excel Magic Trick 1015: Counting With OR Criteria: SUMPRODUCT & COUNTIF Formula from pmsocho	5:55	2013-07-13
1830	Excel Magic Trick 1013: MIN IF, MAX IF, MINIF, MAXIF (6 Examples) MAX MIN calculation w 1 criteria	11:08	2013-07-13
1831	Excel Magic Trick 1014: Text To Columns to Split Data From A Cell and Avoid Extra Spaces	1:54	2013-07-13
1832	Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN	4:03	2013-07-13
1833	Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)	7:23	2013-07-12
1834	Excel Magic Trick 1011: Conditionally Format Row Above Matched Text Criteria "Subtotal"	9:05	2013-07-12
1835	Mr Excel & excelisfun Trick 131: Prevent VLOOKUP from Returning a Zero (4 Methods)	6:18	2013-07-11
1836	Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows	12:42	2013-07-08
1837	Mr Excel & excelisfun Trick 130: Text Formula To Show Calculation (Not Formula) From A Cell	7:32	2013-06-29
1838	Excel Magic Trick 1009: Lookup 3 Different Arrays From 3 Different Tables: VLOOKUP, CHOOSE, INDEX	15:08	2013-06-27
1839	Excel Magic Trick 1008: CUMIPMT Function: Compare Interest Paid On Semimonthly & Monthly Loan	3:08	2013-06-27
1840	Excel Magic Trick 1007: Loan PMT Semi-Monthly Schedule: A Few Finance and Date Tricks	10:37	2013-06-26
1841	Excel Magic Trick 1006: Insurance Calculation: MMULT Function to add from rows in a 2-Way Array	11:01	2013-06-25
1842	Excel Magic Trick 1005: Lookup nth Duplicate When Column With Lookup Value Is Not Sorted	7:50	2013-06-24
1843	Excel Magic Trick 1004: Conditionally Format Row With nth Duplicate, Column Sorted or Not Sorted	6:53	2013-06-24
1844	Excel Magic Trick 1003: Lookup nth Duplicate When Column With Lookup Value Is Sorted	2:30	2013-06-24
1845	Mr Excel & excelisfun Trick 129: Dynamic Range Last Ten Numbers Column: OFFSET or INDEX Formula?	11:17	2013-06-21
1846	Mr Excel and excelisfun Excel Videos Play In Excel!?!? Free Workbook with List of All Videos!	1:39	2013-06-18
1847	Mr Excel & excelisfun Trick 128: Count Occurrences Of Items: PivotTable Or Advanced Filter & COUNTIF	4:35	2013-06-18
1848	Excel Magic Trick 1000: Lookup Last Partial Text Item using SEARCH and LOOKUP functions	4:09	2013-06-13
1849	Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates	5:58	2013-06-13
1850	Excel Magic Trick 1002: Replace "11" With "13", But Only After Third Dash	6:15	2013-06-13
1851	excelisfun YouTube Channel: How To Search For Videos & Download Excel Workbooks	2:34	2013-06-10
1852	Google and YouTube New Channel Confusion	0:49	2013-06-09
1853	Mr Excel & excelisfun Trick 127: Adding After & Before Dash: Array Formula or VBA?	10:38	2013-06-06
1854	Excel Magic Trick 997: Add Daily Sales with Text Day Criteria: 3 or 4 Day Abbreviation Convention	11:36	2013-05-31
1855	Excel Magic Trick 998: Conditionally Format Products As They Expire 6 Months From Creation Date	4:23	2013-05-31
1856	Excel Magic Trick 999: MATCH Rather Than OR function to Conditionally Format Row With OR Criteria	5:10	2013-05-31
1857	Mr Excel & excelisfun Trick 126: SUM Daily Totals from Text Dates with Text Day Criteria	8:01	2013-05-30
1858	Mr Excel & excelisfun Trick 125: Conditional Formatting Date Four Days Old & Not Paid	7:03	2013-05-28
1859	Excel Magic Trick 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula?	7:35	2013-05-23
1860	Excel Magic Trick 995: Formula: Amount To Increase Sales By To Get To Next Commission Bracket.	4:12	2013-05-23
1861	Excel Magic Trick 996: Highlight All Empty Cells: Go To Special Blanks, And A Few Other Tricks	2:51	2013-05-23
1862	Mr Excel & excelisfun Trick 124: Dynamic Stacked Line Chart	8:56	2013-05-17
1863	Top Ten Library Excel Questions for Highline Community College Library Quarterly Staff Meeting	41:47	2013-05-15
1864	Mr Excel & excelisfun Trick 123: Lookup Column and then Add With Criteria	5:26	2013-05-09
1865	Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123	3:36	2013-05-08
1866	Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work	4:20	2013-05-07
1867	Excel Magic Trick 991: Formula To Create Sequential Numbers 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, ...	6:06	2013-05-06
1868	Excel Magic Trick 990: VLOOKUP returns Zero and #N/A, What To Do?	7:41	2013-05-05
1869	Excel Magic Trick 989: Conditional Formatting For Values above 90% Percentile Mark	3:51	2013-05-04
1870	Mr Excel & excelisfun Trick 122: Entering Credit Card Numbers With More Than 15 Digits	4:23	2013-05-03
1871	Mr Excel & excelisfun Trick 121: MIN and MAX Between Two Dates For Each Region	9:12	2013-04-26
1872	Mr Excel & excelisfun Trick 120: Summarize By Week and Month, Monthly Totals, Weekly Totals	9:22	2013-04-19
1873	Slaying Excel Dragons Book #53: Defined Name Formula Dynamic Ranges For Charts and Array Formulas	45:19	2013-04-10
1874	Slaying Excel Dragons Book #52: Recorded Macros	28:06	2013-04-08
1875	Slaying Excel Dragons Book #51: Find and Replace & Go To Special	5:52	2013-04-05
1876	Mr Excel & excelisfun Trick 119: Sorting For Plant List, Sort by Month and Day Only	9:45	2013-04-05
1877	Slaying Excel Dragons Book #50: Conditional Formatting (12 Examples)	28:30	2013-04-02
1878	Slaying Excel Dragons Book #49: Complete Lessons On Excel Charts (26 Examples)	46:09	2013-03-29
1879	Slaying Excel Dragons Book # 48: Importing Data Into Excel From Excel, Text File, Access, Web Query	12:24	2013-03-29
1880	Mr Excel & excelisfun Trick 118: Formula To Calculate Commissions for Four Scenarios	6:24	2013-03-29
1881	Slaying Excel Dragons Book # 47: Text To Columns Last Name First Name & Address	10:41	2013-03-29
1882	Slaying Excel Dragons Book # 46: Advanced Filter For Extracting Records From Data Set (12 Examples)	33:26	2013-03-27
1883	Slaying Excel Dragons Book #45: PivotTables Treat Integer & Decimal Numbers Differently inGrouping	7:48	2013-03-26
1884	Slaying Excel Dragons Book #44; Data Analysis Filter Feature: Extract Data Based on Criteria	17:55	2013-03-24
1885	Mr Excel & excelisfun Trick 117: Extract Top Five Numbers	6:51	2013-03-22
1886	Slaying Excel Dragons Book #43: 5 Special PivotTables -- Changing Functions and Calculations	15:55	2013-03-21
1887	Slaying Excel Dragons Book #42: PivotTable Slicers, Report Filter & Show Report Filter Pages	11:44	2013-03-19
1888	Slaying Excel Dragons Book #41: Blanks (Empty Cells) or Text in Number Fields PivotTable Trouble	5:08	2013-03-18
1889	Slaying Excel Dragons Book #40: Grouping Dates in PivotTables: Years, Months or Weeks, and more	11:46	2013-03-14
1890	Mr Excel & excelisfun Trick 116: Extract Individual Letters From Cell and do Lookup Adding, then...	8:29	2013-03-14
1891	Slaying Excel Dragons Book #39: Data Analysis Pivot Tables & Pivot Charts, PivotTables & PivotCharts	19:34	2013-03-12
1892	Slaying Excel Dragons Book #38: Data Analysis Subtotal Feature (9 Examples)	17:46	2013-03-11
1893	Slaying Excel Dragons Book #37: Sort Sorting in Excel, Data Analysis (Sorting 20 Examples)	23:31	2013-03-09
1894	Mr Excel & excelisfun Trick 115: Plot Chart, Show Only Selected Employee Name Is Axis	6:20	2013-03-08
1895	Slaying Excel Dragons Book #36: Custom Number Format & the TEXT function	29:17	2013-03-06
1896	Slaying Excel Dragons Book #35: Basic Array Formulas & Functions	29:24	2013-03-06
1897	Slaying Excel Dragons Book #34: Goal Seek What If Analysis	2:24	2013-03-05
1898	Slaying Excel Dragons Book #33: RANK Functions & Excel 2010 Compatibility Functions RANK.AVE RANK.EQ	5:27	2013-03-04
1899	Slaying Excel Dragons Book #32: 3 Types Of Averages AVERAGE, MEDIAN, MODE, COUNTIF Functions	9:04	2013-03-03
1900	Slaying Excel Dragons Book #31: ROUND Function -- When & How To Use ROUND	8:15	2013-03-03

1901	Mr Excel & excelisfun Trick 114: Cross Tabulated AVERAGING 3 Criteria: PivotTable or AVERAGEIFS	6:37	2013-03-01
1902	Slaying Excel Dragons Book #30: INDEX & MATCH Function For Unusual Lookup Situations (10 Examples)	36:32	2013-02-28
1903	Slaying Excel Dragons Book #29: MATCH Function To Compare Two Lists, Tables or Databases	7:40	2013-02-27
1904	Slaying Excel Dragons Book #28: VLOOKUP Function & Data Validation Dropdown List (11 Examples)	36:13	2013-02-26
1905	Slaying Excel Dragons Book #26: SUMPRODUCT Function (12 Examples)	43:08	2013-02-24
1906	Slaying Excel Dragons Book #27 IF function (12 Examples), AND OR functions, Nesting IFs	33:55	2013-02-24
1907	Excel Truel: VLOOKUP Fun With Excelisfunner (Isaac 6 Years Old) Mr Excel & excelisfun Trick 113:	7:48	2013-02-21
1908	Slaying Excel Dragons Book #25: AND and OR Criteria For Adding, Counting, and Averaging Formulas	24:46	2013-02-20
1909	Slaying Excel Dragons Book #24: Defined Names, Create Names From Selection & Name Manager	9:09	2013-02-20
1910	Slaying Excel Dragons Book #23: PMT Function For Loan Payment	5:55	2013-02-20
1911	Slaying Excel Dragons Book #22: Averaging without Zeros AVERAGEIF function or Replace Feature	7:29	2013-02-20
1912	Slaying Excel Dragons Book #19: Worksheet, Workbook 3-D Cell References, Arrange All Feature	21:45	2013-02-15
1913	Slaying Excel Dragons Book #20: Efficient Use Of Cell Ranges in Formulas. Insert Row, Range Updates.	4:12	2013-02-15
1914	Slaying Excel Dragons Book #21: Benefits of Insert Function Dialog Box. FV Function Example	10:22	2013-02-15
1915	Slaying Excel Dragons Book #18: What If and Scenario Analysis in Excel	6:55	2013-02-14
1916	Slaying Excel Dragons Book #17: Mixed Cell References & Orientation of Formula Inputs	9:01	2013-02-13
1917	Slaying Excel Dragons Book # 16: Relative, Absolute, Mixed Cell Ranges & Adding With Two Criteria	12:42	2013-02-12
1918	Slaying Excel Dragons Book #15: Cell References in Formulas: Relative, Absolute, Mixed	40:12	2013-02-11
1919	Slaying Excel Dragons Book #13: Putting Cell References In Formulas (3 Methods)	7:29	2013-02-09
1920	Slaying Excel Dragons Book #14 Percentage Increase Or Decrease Formulas	6:31	2013-02-09
1921	Slaying Excel Dragons Book #12: How Excel Formulas Are Evaluated Order of Operations Excel Formulas	17:11	2013-02-09
1922	Mr Excel & excelisfun Trick 112: Two Way Lookup Cell Address to Create Dynamic Range: Formula or VBA	8:40	2013-02-08
1923	Slaying Excel Dragons Book #11: Comprehensive Excel Formula Creation Guide (Formula Types, Elements)	38:54	2013-02-06
1924	Slaying Excel Dragons Book #10: Excel Cell Styles and Table Styles	8:29	2013-02-06
1925	Slaying Excel Dragons Book #9: Excel Page Setup For Reports Large or Small	20:42	2013-02-05
1926	Slaying Excel Dragons Book #8: Excel Stylistic Formatting	21:06	2013-02-04
1927	Slaying Excel Dragons Book #7: Excel Data Alignment: Pitfalls & Advantageous Tricks	15:01	2013-02-02
1928	Slaying Excel Dragons Book #6: Number Formatting As Façade: Decimal, Date, Time, Percentage	32:56	2013-02-02
1929	Slaying Excel Dragons Book #5: Excel Table Feature (Excel as Database)	18:28	2013-02-01
1930	Mr Excel & excelisfun Trick 111: Slowest Time That Is Within 2 Seconds Of The Fastest	9:41	2013-02-01
1931	Slaying Excel Dragons Book #4: Table Format Structure For Raw Data & Data Analysis	5:54	2013-01-31
1932	Slaying Excel Dragons Book #3: Data Into Information: SUMIFS, PivotTable, Verifying Formulas & Data	20:27	2013-01-30
1933	Slaying Excel Dragons Book #2: Excel 2010 Keyboard Shortcuts Are Fast!	21:53	2013-01-29
1934	Slaying Excel Dragons Book #1: How Excel Is Set Up, Customize Ribbon and Toolbar	7:55	2013-01-28
1935	Mr Excel & excelisfun Trick 110: 3 VLOOKUPS Calculate Cost Based on Product, Packaging, Discount	8:03	2013-01-25
1936	Excel Magic Trick 988: What is Actual Return on my Art Investment from Antiques Roadshow?	3:42	2013-01-22
1937	Excel Magic Trick 987: LOOKUP Last Number In Column, Excluding Zeroes	3:21	2013-01-22
1938	Excel Magic Trick 986 One Lookup Value, Extract Multiple Items, Display Horizontally (A Closer Look)	14:46	2013-01-15
1939	Excel Magic Trick 985: Filter by Decimal: Helper Column or Advanced Filter w Formula Criteria	5:42	2013-01-14
1940	Excel Magic Trick 984: Lookup Penultimate: Get Second To Last Item From Column Of Mixed Data	6:44	2013-01-10
1941	Excel Magic Trick 983: Get Last Data For Employee From Across Many Sheets	8:09	2013-01-08
1942	Excel Magic Trick 982: Add w One Condition, Use SUMIF Instead of SUMPRODUCT or DSUM	8:26	2012-12-25
1943	Excel Magic Trick 981: 123.45M From Text To Number, 123,450,000 From Number to 123.45M	3:38	2012-12-20
1944	Excel Magic Trick 980: OR and AND Counting Criteria In One Formula, Boolean or MATCH?	8:38	2012-12-15
1945	Excel Magic Trick 979: 2 Lookup Values in Lookup, Can't Have Helper Column.	7:27	2012-12-15
1946	SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function, Excel Magic Trick 978	1:09:15	2012-11-29
1947	Excel Magic Trick 976: Excel Two Way Lookup - 11 Examples (2 Way Lookup)	18:30	2012-11-08
1948	Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range	6:50	2012-11-08
1949	Excel Magic Trick 975: 7 Keystrokes to Enter an Excel Formula, including Array Formulas.	7:44	2012-11-06
1950	Excel Magic Trick 974: Formula to Join First & Last Name & Title: Ampersand or CONCATENATE?	3:31	2012-11-06
1951	Excel Magic Trick 973: List Multiple MODEs in Excel 2007 or earlier: COUNTIF or PivotTable	8:31	2012-11-06
1952	Excel Magic Trick 972: Empty Cell or Null Text String in Formulas: Counting Formulas	5:56	2012-11-06
1953	Excel Magic Trick 971: Which Answer Was Selected 1, 2, 3, 4? MATCH function to Find "Y".	1:35	2012-11-06
1954	Excel Magic Trick 970: Extract Records Where Number is Divisible by 5 (5 Examples)	22:34	2012-11-02
1955	Excel Magic Trick 969: VLOOKUP 2 Items From One Cell & Return 2 Items To Different Cell	7:10	2012-10-25
1956	Excel Magic Trick 968: Highlight Formula Element with Screen Tip	1:19	2012-10-25
1957	Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012	55:13	2012-10-19
1958	Excel for Accounting and Finance - Northwest Accounting Educators Conference 2012 - NAE 2012	1:47:41	2012-09-03
1959	Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicates	17:34	2012-08-24
1960	Excel Magic Trick 966: Conditional Format Row When Item Is In List	5:27	2012-08-22
1961	Excel Magic Trick 964: Custom Number Format Show Positive With Plus and Negative With Minus	1:39	2012-08-22
1962	Excel Magic Trick 965: Conditional Formatting Green For Correct Multiplication Table Answer	4:03	2012-08-22
1963	Excel Magic Trick 960: Add Noncontiguous ranges that have #N/A Errors	8:30	2012-08-06
1964	Excel Magic Trick 961: Calculate Total Savings: Old Price, New Price & Quantity IFNA 2013 Function	8:30	2012-08-06
1965	Excel Magic Trick 962: Convert Numbers w Comma to Number w Decimal: Formula or Text To Columns	3:45	2012-08-06
1966	Excel Magic Trick 963: Lookup Product Price Based On Quantity: Two Way Lookup	11:09	2012-08-06
1967	Excel Magic Trick 959: Start Position Of Most Consecutive Ones, Single Cell Array Formula Method	15:54	2012-08-03
1968	Excel Magic Trick 958: Start Position Of Most Consecutive Ones, Helper Column Method	7:04	2012-08-03
1969	Excel 2013 Preview #8: SHEET Function (Excel Magic Trick 956)	5:24	2012-08-01
1970	Word & Excel 2013 Preview #9: Spell Check Is Amazing (In Word)! (Excel Magic Trick 957)	4:43	2012-08-01
1971	Excel 2013 Flash Fill : 23 Amazing Examples (Preview #7) (Excel Magic Trick 955)	9:17	2012-07-25
1972	Excel 2013 Preview #2: Flash Fill To Extract First & Last Names From Column (Excel Magic Trick 950)	2:11	2012-07-23
1973	Excel 2013 Preview #3: FLOOR.MATH & CEILING.MATH: Round To Significance Excel Magic Trick 951	3:09	2012-07-23
1974	Excel 2013 Preview #4: FORMULATEXT Function: Show Formula From A Cell (Excel Magic Trick 952)	1:28	2012-07-23
1975	Excel 2013 Preview 5 IFNA & VLOOKUP Functions: Show Message When #N/A (Excel Magic Trick 953)	1:59	2012-07-23
1976	Excel 2013 Preview #6: ISFORMULA Function (Excel Magic Trick 954)	1:54	2012-07-23
1977	Excel 2013 Preview #1: Smooth and Improved Excel 2013, Office 15 (Excel Magic Trick 949)	5:38	2012-07-19
1978	Excel Magic Trick 947: Defined Name 3-D Cell Reference For Making Calculations Across Sheets	2:43	2012-07-19
1979	Excel Magic Trick 948: Lookup Insurance Name from within Parenthesis (Extract Text From Text String)	3:30	2012-07-19
1980	Excel Magic Trick 946: Is Item In List NOT In Any Other List? (Check Against 3 Other Columns)	11:36	2012-07-16
1981	Excel Magic Trick 944.5: Formula For Total Interest Over Life Of Business Amortization Loan	2:10	2012-07-16
1982	Excel Magic Trick 944: How To Create Your Own Original Array Formula From Scratch	15:06	2012-07-13
1983	Excel Magic Trick 945: Import External Excel File Into Open Excel Workbook & Alt Keyboards Tips	4:42	2012-07-13
1984	Excel Magic Trick 943: Conditional Format First Three & Conditional Format After 3rd Occurrence	4:39	2012-07-06
1985	Excel Magic Trick 942: Lookup Last Shipment Date For Customer, Sorted & Not Sorted Date Column	6:51	2012-07-06
1986	Excel Magic Trick 941: Running Totals That Adjust At Each Change In Sku Number In First Column	1:54	2012-07-06
1987	Mr Excel & excelisfun Trick 109: Electoral College: PivotTable or Formulas	10:09	2012-07-06
1988	Excel Magic Trick 940: Conditionally Format Row "At Each Change In" Grouped Items	3:05	2012-07-05
1989	Excel Magic Trick 939: Use OR and AND Functions In IF Function For Logical Tests	16:31	2012-07-03
1990	Excel Magic Trick 938: Lookup Row Associated With Employee And Get Last In That Row	10:26	2012-07-02
1991	Mr Excel & excelisfun Trick 108: SUM, AVERAGE, STDEV.S, MIN, MAX: Three Methods	6:46	2012-06-29
1992	Excel Magic Trick 937: HYPERLINK VLOOKUP: Create Drop Down That Selects Web Address Link	2:10	2012-06-28
1993	Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups)	8:19	2012-06-28
1994	Excel Magic Trick 935: MAX Value Between Two Dates: DMAX, MAX-IF-IF, or AGGREGATE Function?	12:43	2012-06-27
1995	Excel Magic Trick 934: HYPERLINK Function and Hyperlink Feature (13 Examples)	9:13	2012-06-26
1996	Excel Magic Trick 933: Insert Comment Into Filtered Records Only (Keyboard Shortcuts)	2:33	2012-06-24
1997	Excel Magic Trick 931: VLOOKUP & MATCH: Lookup Values With Special Characters Such As ~ * ?	5:53	2012-06-22
1998	Excel Magic Trick 932: Formula to Show Cell Address: CELL or ADDRESS Function?	3:17	2012-06-22
1999	Excel Magic Trick 930: Mixed Numbers In Formulas: Plus or No Plus, Excel Stills Knows!	3:19	2012-06-22
2000	Excel Magic Trick 928: VLOOKUP Grading: Plus, Minus or Zero: Looking Up A Plus, Minus or Zero	5:11	2012-06-19

2001	Excel Magic Trick 926: Underscore and Custom Number Formatting: Decimals Not Lined Up	9:39	2012-06-19
2002	Excel Magic Trick 927: Insert Zero For Alphanumeric String With Single Digit Numbers	2:52	2012-06-19
2003	Excel Magic Trick 929: VLOOKUP Grading: Lookup Letter Grade With + and - & Return Decimal Grade	3:45	2012-06-19
2004	Excel Magic Trick 925: SUMIFS Function & Table Feature To Create Running Total Net Income Formula	20:10	2012-06-15
2005	Excel Magic Trick 924: Percentage Change On Running Total Months: 2012 Compared To 2011	4:19	2012-06-13
2006	Excel Magic Trick 923: Recorded Macro Basics: Click Button To Move Data To Table On Another Sheet	13:34	2012-06-06
2007	Excel 2010 Statistics 87: Linear Regression #1: Scatter Diagram: Relationship Between 2 Variables?	17:00	2012-06-04
2008	Excel 2010 Statistics 88: Linear Regression #2: Scatter Plot with Trendline & X and Y Mean Lines	12:04	2012-06-04
2009	Excel 2010 Statistics 89: Linear Regression #3: Sample Covariance & Coefficient of Correlation	19:59	2012-06-04
2010	Excel 2010 Statistics 90: Linear Regression #4: Calculate Slope, Y-Intercept, Estimated Equation	18:37	2012-06-04
2011	Excel 2010 Statistics 91: Linear Regression #5: Coefficient of Determination: Goodness of Fit	18:03	2012-06-04
2012	Excel Magic Trick 922: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup	6:05	2012-05-25
2013	Excel Magic Trick 921: COUNTIF Cells Containing Particular Characters: Count & Conditional Format	5:06	2012-05-23
2014	Excel Magic Trick 920: Rotating List & Upside down VLOOKUP: Alternative Formulas	8:51	2012-05-23
2015	Excel Magic Trick 919: How Do I Copy An Excel Sheet? Copy or Move Worksheet Keyboard Shortcut	4:53	2012-05-17
2016	Excel Magic Trick 918: Upside down VLOOKUP: Sort Decending & Bump Into First Smallest Value	6:43	2012-05-15
2017	Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)	6:58	2012-05-12
2018	Excel Magic Trick 916: Remove Blanks In Data Validation Drop Down List 5 Examples	23:58	2012-05-10
2019	Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples	26:04	2012-05-07
2020	Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet	8:17	2012-05-04
2021	Excel Magic Trick 914: Top 5, Bottom 5 Excluding Zeros: LARGE, SMALL & AGGREGATE Functions	9:14	2012-05-04
2022	Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and #N/A: AGGREGATE	10:15	2012-05-01
2023	Excel Magic Trick 911: Add Leading Zero and Dash, More Examples From Mr Excel & excelisfun Trick 107	8:01	2012-04-30
2024	Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers	7:29	2012-04-27
2025	Excel Magic Trick 910: Adding with AND, BETWEEN and OR Criteria: SUMIFS and COUNTIF Functions	5:23	2012-04-24
2026	Mr Excel & excelisfun Trick 106: LOOKUP Function in VisiCalc, Lotus and Excel	10:11	2012-04-20
2027	Excel Magic Trick 907: How To Make Excel Calendar (4 Examples)	16:12	2012-04-13
2028	Mr Excel & excelisfun Trick 105: Count Between Words	8:04	2012-04-13
2029	Excel Magic Trick 908: Count Text Entries Between Two Dates	5:04	2012-04-13
2030	Excel Magic Trick 909: Paste Special Values	3:14	2012-04-13
2031	Excel Magic Trick 905: Add 1 To Every Number Greater Than 20, IF Function, Paste Special Values	2:14	2012-04-10
2032	Excel Magic Trick 906: Ctrl + Backspace: Keyboard To Jump To Active Cell In Worksheet or Formula	2:01	2012-04-10
2033	Excel Magic Trick 901: Lookup First & Last Name From 2 Different Cells & Return Then To 1 Cell	3:47	2012-04-07
2034	Excel Magic Trick 902: Conditionally Format To Do List If Date in Row is TODAY and Item Is Done	4:08	2012-04-07
2035	Excel Magic Trick 903: Last Of Month & First Of Month Using EOMONTH or Excel 2003 Functions	3:13	2012-04-07
2036	Excel Magic Trick 904: Lookup Group Number and Return Names In Group	8:02	2012-04-07
2037	Excelisfunner & Mr Excel & Excelisfun Mr Trick 104: Truel With 5 Year old Exceler	6:21	2012-04-06
2038	Excel Magic Trick 900: Simulate Filter With Formula to Create Immediate Filter Results	16:02	2012-04-03
2039	Excel Magic Trick 899: Lookup Column of Data, Match Criterion, Display Items Vertically	8:31	2012-04-03
2040	Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula	7:30	2012-04-02
2041	Excel Magic Trick 897 Conditional Format Row If Brand Field Contains Particular Brand (Partial Text)	4:24	2012-04-02
2042	Excel Magic Trick 896: Conditional Formatting Formula: Entire Row Red If SUM Greater Than 45	4:12	2012-04-01
2043	Excel Magic Trick 890: Find Discrepancies with Formula (Dot at end or Repeated Words)	4:46	2012-03-30
2044	Excel Magic Trick 891: Dynamic Subtotals Using Table Feature and SUMIF or SUMIFS functions	2:55	2012-03-30
2045	Excel Magic Trick 892: Add Numbers Between 2 Dates w Multiple Criteria from Multiple Workbooks	6:49	2012-03-30
2046	Excel Magic Trick 893: Extract & Sort Records When Value Greater Than 75: Filter or Formula	9:28	2012-03-30
2047	Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula	10:04	2012-03-30
2048	Excel Magic Trick 895: Entered Date Must Be Greater or Equal to Any Dates Above Data Validation	3:13	2012-03-30
2049	Mr Excel & excelisfun Trick 103: Find Missing Numbers In A Series	6:54	2012-03-30
2050	CHOOSE Function Beginner to Advanced 12 Examples (Excel VLOOKUP WEEK Video #5)	37:46	2012-03-30
2051	Excel Lookup Picture Approximate or Exact match (Excel VLOOKUP WEEK Video #6)	4:59	2012-03-30
2052	Approximate Match & Sorting To Reduce Exact Match Calculation Time VLOOKUP WEEK #4	13:17	2012-03-29
2053	INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)	1:09:43	2012-03-28
2054	LOOKUP function Beginner to Advanced 23 Examples (Excel VLOOKUP WEEK Video #2)	46:11	2012-03-27
2055	Excel VLOOKUP Function - All You Need To Know	1:08:03	2012-03-26
2056	Excel Magic Trick 887: List Names In Tabular Table Twice: Row/Column or Column/Row Matches	7:31	2012-03-23
2057	Excel Magic Trick 886: Two Way Lookup, List Names In Tabular Table (Row & Column Criteria)	7:10	2012-03-23
2058	Excel Magic Trick 888: Delete Filtered Records Do Not Delete Hidden Records	1:13	2012-03-23
2059	Excel Magic Trick 889: Excel 2010 Filter Search: Easy To "Partial Text"Filter	1:00	2012-03-23
2060	Mr Excel & excelisfun Trick 102: Remove Duplicate Records Based On Partial Text in a Cell	6:41	2012-03-22
2061	Excel Magic Trick 885.5: Part 2 Calculate Payroll Penalty QUOTIENT & OR & Array Constant	4:33	2012-03-22
2062	Excel Magic Trick 885: Calculate Payroll Penalty For Every 15 Minute Late QUOTIENT & MOD	9:00	2012-03-21
2063	Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table	16:42	2012-03-19
2064	Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record	9:42	2012-03-17
2065	excelisfun: How To Search For Excel Videos, Find Playlists and Download Workbooks 2012 YouTube	6:35	2012-03-16
2066	Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions	4:30	2012-03-15
2067	Mr Excel & excelisfun Trick 101: Sum Numbers from Cells That Contain Both Text & Numbers	6:42	2012-03-15
2068	Excel 2010 Statistics 79: 1 Tail Left z Distribution Mean Hypothesis Testing P-value Critical Value	13:44	2012-03-15
2069	Excel 2010 Statistics 80: Two Tail z Distribution Mean Hypothesis Testing P-value Critical Value	13:29	2012-03-15
2070	Excel 2010 Statistics 82: 1 Tail Right t Distribution Mean Hypothesis Testing P-value Critical Value	13:57	2012-03-15
2071	Excel 2010 Statistics 81: NORM.S Functions Hypothesis Testing p-value & Critical Values 7 Examples	9:30	2012-03-15
2072	Excel 2010 Statistics 83: 1 Tail Left t Distribution Mean Hypothesis Testing P-value Critical Value	9:45	2012-03-15
2073	Excel 2010 Statistics 84: Two Tail t Distribution Mean Hypothesis Testing P-value & Critical Value	11:08	2012-03-15
2074	Excel 2010 Statistics 85: T Functions Hypothesis Testing for p-value & Critical Values 11 Examples	11:42	2012-03-15
2075	Excel 2010 Statistics 86: Hypothesis Test for Proportions using p-value or Critical Value	10:38	2012-03-15
2076	Excel 2010 Statistics 78: Hypothesis Testing Population Mean, P-value & Critical Value, 1 Tail Right	41:22	2012-03-13
2077	Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function	4:55	2012-03-11
2078	Excel 2010 Magic Trick 880: Multiple OR Criteria Using MATCH function For Extracting Data Formula	8:07	2012-03-08
2079	Mr Excel & excelisfun Trick 100: Two Way Lookup Formula and Conditional Formatting!	8:11	2012-03-08
2080	Excel 2010 Business Math 71.5: Formula To Convert Invoice Costs to Sell Price	5:17	2012-03-08
2081	Excel 2010 Magic Trick 877: Manager Sales Rep Report: OR Criteria Formula To Extract Records	10:52	2012-03-06
2082	Excel Magic Trick 876: Summarize GL Accounts Specific Date Period From Different Workbook	6:15	2012-03-06
2083	Excel 2010 Magic Trick 878: Manager Sales Rep Report: OR & AND Criteria Formula To Extract Records	12:52	2012-03-06
2084	Excel Magic Trick 879: Conditional Formatting Across Worksheet (Sheets or Tabs)	10:22	2012-03-06
2085	Excel Magic Trick 875: Lookup Bond Score Based On Years and Rate: 2-Way Lookup With Rounding	15:18	2012-03-02
2086	Excel Magic Trick 874: Lookup That Rounds To The Nearest Number (Increment Unequal) INDEX & MATCH	8:34	2012-03-02
2087	Mr Excel & excelisfun Trick 99: Recorded Macro: Double-Click Fill Handle Trouble	4:38	2012-03-02
2088	Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal)	3:10	2012-02-29
2089	Excel Magic Trick 871: Lookup Last Line In A Cell: Formula w LEN, SUBSTITUTE, SEARCH, CHAR, MID	6:49	2012-02-24
2090	Excel Magic Trick 869: Formula Calculate First Day of Week 2010 & 2003 Formula WEEKDAY Function	3:17	2012-02-24
2091	Excel Magic Trick 870: VLOOKUP A Date and Pattern To Simplify Formula	2:31	2012-02-24
2092	Excel Magic Trick 872: Calculate Quarters From Date:3 Methods	3:51	2012-02-24
2093	Excel 2010 Statistics 73: Introduction To Confidence Intervals	14:50	2012-02-21
2094	Excel 2010 Statistics 75 Confidence Intervals Sigma NOT Known T.INV, CONFIDENCE.T & Analysis Add-in	22:00	2012-02-21
2095	Excel 2010 Statistics 74: Confidence Intervals Sigma Known: NORM.S.INV, CONFIDENCE.NORM Functions	11:03	2012-02-21
2096	Excel 2010 Statistics 76: Confidence Interval To Estimate Population Proportion: NORM.S.INV Function	12:28	2012-02-21
2097	Excel 2010 Statistics 77: Determine Sample Size	7:17	2012-02-21
2098	Mr Excel & excelisfun Trick 98: Extract & Lookup Number When Table Of Numbers Is In A Single Cell	8:08	2012-02-17
2099	Mr Excel & excelisfun Trick 97: Determine Quarter For column of Dates: CHOOSE or CEILING function?	5:44	2012-02-09
2100	Excel Magic Trick 866: Four Lookup Values In VLOOKUP Formula? 6 Examples	20:24	2012-02-09

2101	Excel Magic Trick 867 AVERAGEIFS Function w/ Not and Between Criteria	4:46	2012-02-07
2102	Excel Magic Trick 868 Conditional Format Row Not & Between Criteria: Excel Conditional Formatting	3:40	2012-02-07
2103	Excel 2010 Statistics 68: Construct Sampling Distribution Of Samples Means (Xbar)	27:00	2012-02-04
2104	Excel 2010 Statistics 66: Simple Random Sample Using RAND Function, Sort and Copy Paste	6:47	2012-02-04
2105	Excel 2010 Statistics 67: Formula To Extract Simple Random Sample	8:29	2012-02-04
2106	Excel 2010 Statistics 65: Sample Mean Xbar and Probability, Not X values	5:08	2012-02-04
2107	Excel 2010 Statistics 69: Probability That Sample Mean Occur w/ Given Margin Of Error (3 Examples)	16:24	2012-02-04
2108	Excel 2010 Statistics 68.5: Sparklines to Compare Population and Sampling Distributions	1:38	2012-02-04
2109	Excel 2010 Statistics 71: Sampling Distrib. Of X Bar As Sample Size Increase Probability Increase	8:40	2012-02-04
2110	Excel 2010 Statistics 72: Sampling Distribution of Sample Proportion	9:57	2012-02-04
2111	Excel 2010 Statistics 70: Standard Error and Correction Factor For Finite Populations	5:52	2012-02-04
2112	Excel Magic Trick 864: Getting Data From Internet Into Excel -- Paste Special Text	0:53	2012-02-02
2113	Excel Magic Trick 865: Data From Many Columns Into One: Recorded Macro & Paste All Clipboard	6:15	2012-02-02
2114	Excel Magic Trick 863: If Sat or Sun, Multiply by 15, Any Other Day Use 14 WEEKDAY & IF Functions	6:23	2012-02-01
2115	Mr Excel & excelisfun Trick 96: LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type)	8:05	2012-01-26
2116	Excel Magic Trick 862: Count Numbers In Column, But Only If Number Is Not Repeated In Row	6:35	2012-01-20
2117	Mr Excel & Excelisfun Trick 95: Conditionally Format +/- 15% Change Arrows Or Logical Formula?	7:31	2012-01-20
2118	Excel Magic Trick 861: Conditional Format 50 Columns w Format Painter +/- 1 Standard Deviation	10:23	2012-01-18
2119	Excel Magic Trick 860: MAX & MIN Across Multiple Sheets Using Rectangular Range 3-D Cell Reference	2:22	2012-01-17
2120	Excel Magic Trick 858: Convert Month As Text To Number January = 1, February = 2, Etc.	1:21	2012-01-16
2121	Excel Magic Trick 859: Convert Month As Text To 3 Letter Abbreviation Using LEFT Function	0:40	2012-01-16
2122	Seattle Snow Jan 15, 2012: Kid Makes Tracks In Snow & Throws Snow Ball At Camera	1:52	2012-01-15
2123	Excel Magic Trick 857: SUMIF Function with Sheet References: Summarize Data From Different Sheet	3:15	2012-01-15
2124	Excel Magic Trick 856: Last 5 Values In Column: Formulas For Adding, Averaging and Extracting Data	8:45	2012-01-14
2125	Excel Magic Trick 854: COUNTIF Function to Count How Many 1s or 2s or 3s There Are In Column	1:39	2012-01-13
2126	Excel Magic Trick 855: Change Military Time To Non-Military Time (Time Number Formatting)	1:14	2012-01-13
2127	Excel Magic Trick 851: Formula To Sum Unique Values In Column	12:04	2012-01-05
2128	Excel Magic Trick 850: Conditional Format More Than 24 Hours (3 Examples)	5:28	2012-01-05
2129	Excel Magic Trick 853: Lookup Number That Occurs Least Frequently (2 Methods)	6:37	2012-01-05
2130	Excel Magic Trick 852: Conditional Standard Deviation: STDEV.S & IF or DSTDEV functions?	4:43	2012-01-05
2131	Download Excel File Shows Up As Zip?	1:21	2012-01-05
2132	Excel Magic Trick 848: Create List of Dates For Month With Formula	7:18	2011-12-21
2133	Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010	12:46	2011-12-21
2134	Mr Excel & excelisfun Trick 94: Lookup Data In Text String & Extract Data From Text String	10:27	2011-12-16
2135	Excel Magic Trick 836: VLOOKUP Lookup Value Not Matching Value in 1st Column (4 Examples)	8:30	2011-12-15
2136	Excel Magic Trick 838: Two Way Lookup, then Multiply To Get Commission Earned	6:31	2011-12-15
2137	Excel Magic Trick 840: Frequency & Total for Upper and Lower Limit Category Formulas or PivotTable?	8:57	2011-12-15
2138	Excel Magic Trick 839: Standard Deviation At Each New Value In Column	6:04	2011-12-15
2139	Excel Magic Trick 837: Lookup Multiplying with SUMIF & PRODUCT Experimental Outcome Probability	3:41	2011-12-15
2140	Excel Magic Trick 843: Is Record Duplicate, Excluding First Occurrence? COUNTIFS Function	4:54	2011-12-15
2141	Excel Magic Trick 841: One Standard Deviation Above Mean, Count & Conditional Format Values	4:44	2011-12-15
2142	Excel Magic Trick 845: Single Cell Calculation for EOM Cash Discount Final Discount Date	9:08	2011-12-15
2143	Excel Magic Trick 844: Last Date In Column A For "N" In Column B	4:35	2011-12-15
2144	Excel Magic Trick 842: Is Item A Duplicate In Column? Excluding First Occurrence: COUNTIF	2:26	2011-12-15
2145	Excel Magic Trick 847: Position Of Penultimate "Y" In A Text String	4:50	2011-12-15
2146	Excel Magic Trick 846: Formula To Reverse First & Last Name When Names Separated by A Space	2:26	2011-12-15
2147	Mr Excel & excelisfun Trick 93: Watch Window: VBA or Watch Window	9:42	2011-12-09
2148	Excel 2010 Business Math 84: Annuities: FV, PV and PMT for End & Begin (9 Examples)	35:07	2011-12-09
2149	Excel Magic Trick 835: Drill Through Conditional Formatting Across Sheets Using Format Painter	4:37	2011-12-08
2150	Excel Magic Trick 834: Average with Multiple Criteria Data Spread Out Across Many Sheets & Columns	16:06	2011-12-07
2151	Excel Magic Trick 833: AVERAGEIFS function & Wildcards, Averaging With Multiple Conditions Criteria	3:37	2011-12-07
2152	Excel Magic Trick 831: Clear Contents Of Worksheet Keep Formatting & Formulas & Other Clear Tricks	2:58	2011-12-07
2153	Excel Magic Trick 832: Merge Tables with Copy, Paste and Clipboard	1:53	2011-12-07
2154	Excel 2010 Business Math 81: FV Function For Future Value Calculations 5 Examples	16:46	2011-12-05
2155	Excel 2010 Business Math 83: Present Value of FV Lump Sum: How Much To Put In Bank?	19:30	2011-12-05
2156	Excel 2010 Business Math 82: Calculating Interest & Future Value For Bank Daily Interest Accounts	12:52	2011-12-05
2157	Excel 2010 Business Math 80: Compare Simple & Compound Interest & Future Value Calculations	21:50	2011-12-05
2158	Excel Magic Trick 830: No Duplicates Allowed In Row, Data Validation Custom Logic Formula COUNTIF	4:26	2011-12-04
2159	Mr Excel & excelisfun Trick 92: Round Invoice: ROUND or SUMPRODUCT - ROUND	4:09	2011-12-03
2160	Excel Magic Trick 828: Calculate Wholesale Price From Series Trade Discount (3 Array Formulas)	20:43	2011-11-26
2161	Excel Magic Trick 829: Insert Picture Into Comment	3:08	2011-11-26
2162	Excel 2010 Business Math 74: Calculating Fraction Of Year For Simple Interest calculations	9:04	2011-11-26
2163	Excel 2010 Business Math 72: Interest On Debt	7:20	2011-11-26
2164	Excel 2010 Business Math 75: Simple Interest: Calculating Interest, Maturity Value & Maturity Date	11:35	2011-11-26
2165	Excel 2010 Business Math 73: Basic Simple Interest Calculations	5:50	2011-11-26
2166	Excel 2010 Business Math 79: Simple Discount Notes or Interest in Advance Notes	15:59	2011-11-26
2167	Excel 2010 Business Math 77: Simple Interest Solve For Rate	6:24	2011-11-26
2168	Excel 2010 Business Math 76: Simple Interest Solve For Principal	9:07	2011-11-26
2169	Excel 2010 Business Math 78: Simple Interest Solve For Time	8:58	2011-11-26
2170	Excel 2010 Business Math 67: Basic Markup Formula	14:57	2011-11-20
2171	Excel 2010 Business Math 68: Markup On Cost	24:01	2011-11-20
2172	Excel 2010 Business Math 69: Markup On Sell Price	23:03	2011-11-20
2173	Excel 2010 Business Math 71: Convert % Markup On Cost To % Markup On Sell Price & Visa Versa	8:28	2011-11-20
2174	Excel 2010 Business Math 70: Sell Price For Perishable Goods (2nd Example)	5:50	2011-11-20
2175	Excel Magic Trick 827: Alt + Tab To Switch Between Open Windows (YouTube Video & Excel Workbook)	1:38	2011-11-19
2176	Excel Magic Trick 826: Formatting Floods Out Cell References When Making Formulas	0:55	2011-11-19
2177	Mr Excel & excelisfun Trick 91: Rank Scores, But If Tie Award Highest Rank To The Largest Weight	7:52	2011-11-17
2178	Excel 2010 Business Math 64: Calculate Cash Discounts Using Ordinary Dating Method	17:31	2011-11-15
2179	Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets	24:28	2011-11-13
2180	Excel Magic Trick 825: Variable Rate Tables: Commission, Piecework & Tax Examples	21:26	2011-11-13
2181	Excel Magic Trick 823: Conditional Formatting Row, Column, Intersecting and Specific Table 2 Methods	18:57	2011-11-13
2182	Excel 2010 Business Math 57: Calculating Single Trade Discounts and Net Cost (Wholesale Cost)	12:48	2011-11-13
2183	Excel 2010 Business Math 58 Calculating Series Trade Discounts, Net Cost Equivalent, Net Cost	13:31	2011-11-13
2184	Excel 2010 Business Math 61: Create An Invoice In Excel	18:33	2011-11-13
2185	Excel 2010 Business Math 63: Date Math For Invoices	8:54	2011-11-13
2186	Excel 2010 Business Math 60: Sales Tax On Invoices: Retail and Wholesale	4:16	2011-11-13
2187	Excel 2010 Business Math 62: Single Cost Equivalent & Solving For List Price	9:03	2011-11-13
2188	Excel 2010 Business Math 59: Shipping Terms	3:09	2011-11-13
2189	Excel 2010 Business Math 65: Calculating Cash Discounts EOM, ROG, Extra, Boolean Math Formulas	22:02	2011-11-13
2190	Excel 2010 Business Math 66: Partial Payments: Cash Discounts, Credit Applied & Remaining Balances	7:29	2011-11-13
2191	Excel 2010 Business Math 43: Excel Time Number Formatting & Excel Time Math	17:53	2011-11-08
2192	Excel 2010 Business Math 44: Payroll Time Sheets, IF Function For Overtime &Gross Pay Calculations	20:12	2011-11-08
2193	Excel 2010 Business Math 48: Incentive Pay: Variable Piece Work Rates	13:35	2011-11-08
2194	Excel 2010 Business Math 45: Overtime Calculations 4 Examples	12:54	2011-11-08
2195	Excel 2010 Business Math 46: Calculating Equivalent Earnings For Different Pay Periods	14:11	2011-11-08
2196	Excel 2010 Business Math 52: Variable Commission Rates, Multiple Step Method	12:52	2011-11-08
2197	Excel 2010 Business Math 47: Incentive Pay: Piece Work	2:30	2011-11-08
2198	Excel 2010 Business Math 49: Piecework With A Guaranteed Hourly Wage, MAX function	2:55	2011-11-08
2199	Excel 2010 Business Math 50: Overtime Earnings For Piecework (Incentive Pay)	1:42	2011-11-08
2200	Excel 2010 Business Math 54: Calculate Social Security and Medicare Deductions	16:34	2011-11-08

2201	Excel 2010 Business Math 51: Commission Rates as Incentive Pay, Calculate Commission on Sales	3:00	2011-11-08
2202	Excel 2010 Business Math 56: Federal Income Tax Deduction Percentage Method	14:45	2011-11-08
2203	Excel 2010 Business Math 53: Calculate Gross Pay for Salary and Commissions	1:21	2011-11-08
2204	Excel 2010 Business Math 55: Federal Income Tax Deduction Wage Bracket Method	8:20	2011-11-08
2205	Mr Excel & excelisfun Trick 90: Remove Earlier Duplicates, Keep Last Duplicate	5:50	2011-11-04
2206	Mr Excel & excelisfun Trick 89: PivotTables Grand Totals To Left: LOOKUP or GETPIVOTDATA function?	9:04	2011-10-28
2207	Excel 2010 Business Math 39: VLOOKUP to Calculating Checking Fees	11:27	2011-10-28
2208	Excel 2010 Business Math 42: Bank Reconciliation	21:49	2011-10-28
2209	Excel 2010 Business Math 37: Checks and Deposits & Withdrawals at Your Bank	20:00	2011-10-28
2210	Excel 2010 Business Math 40: Create Checkbook Register In Excel Using IF function	15:49	2011-10-28
2211	Excel 2010 Business Math 38: Calculating Checking Fees	3:48	2011-10-28
2212	Excel 2010 Business Math 41: Calculating Credit Card Fees	7:40	2011-10-28
2213	Excel Magic Trick 822: 4-Way Lookup When There ARE Duplicates (Return Multiple Items)	13:37	2011-10-25
2214	Excel 2010 Business Math 36: Memorization Trick For Percentage Math Problems	8:45	2011-10-23
2215	Excel 2010 Business Math 35: Stock Value Percentage Change & Web Query For Current Stock Values	7:15	2011-10-23
2216	Excel 2010 Magic Trick 821: 4-Way Lookup When There Are No Duplicates 2007 and 2003 Methods	9:35	2011-10-21
2217	Excel Magic Trick 819: Lookup Second 2nd Item In List: Excel 2010, 2007 and 2003 Methods	14:31	2011-10-21
2218	Excel 2010 Magic Trick 820: Conditional Formatting With Array Formulas!!??	10:03	2011-10-21
2219	Mr Excel & excelisfun Trick 88: Highlight Cumulative Top 70%	7:54	2011-10-21
2220	Excel 2010 Business Math 31: Increase Decrease Problems & Rate Of Change 12 Formulas	45:05	2011-10-20
2221	Excel 2010 Business Math 32: Rate Of Change Word Problem	13:19	2011-10-20
2222	Excel 2010 Business Math 30: Fractional Percentages To Decimals	11:28	2011-10-20
2223	Excel 2010 Business Math 33: Markup and Markdown Calculations	3:55	2011-10-20
2224	Excel 2010 Business Math 34: Begin Amount = (Amount of Change)/(Rate of Change)	13:56	2011-10-20
2225	Excel 2010 Business Math 28: Base = Part/Rate: Solve For Base	25:14	2011-10-17
2226	Excel 2010 Business Math 29: Rate = Part/Base	17:20	2011-10-17
2227	Excel 2010 Business Math 27: Part = Percent * Base: Solve for Part	23:53	2011-10-17
2228	Excel 2010 Business Math 26: Percent Conversions: By Hand and In Excel	32:41	2011-10-17
2229	Excel 2010 Business Math 25: Excel Percent Basics	17:06	2011-10-17
2230	Excel 2010 Business Math 26.5: Rounding Percentages	5:03	2011-10-17
2231	Mr Excel & excelisfun Trick 87: Positive Subtotals Only: PivotTable or SUMIFS	6:19	2011-10-14
2232	Excel 2007 / 2010 Tricks For Making Your Job Easier: HCC Professional Development Day	58:35	2011-10-12
2233	Five Year Old Shows How To Make Cacti and Sharp Spikes in Excel - ExcelisFunner Video	2:17	2011-10-10
2234	Excel 2010 Magic Trick 816: Compare Tables & Extract Records In Table 2 That Are Not In Table 1	8:31	2011-10-09
2235	Excel 2010 Magic Trick 815: Case Sensitive Lookup using EXACT and LOOKUP functions	5:38	2011-10-09
2236	Excel 2010 Magic Trick 817: Extract Unique List of Values For Dynamic Data Validation Drop Down List	11:16	2011-10-09
2237	Excel 2010 Magic Trick 818: Extract Records For Each Country To A New Sheet With Formula	10:42	2011-10-09
2238	Excel 2010 Magic Trick 814: Consolidation From External Workbooks using Consolidation Feature	2:37	2011-10-09
2239	Excel 2010 Business Math 17: Fractions: Types Of Fractions & Fraction Number Formatting	18:17	2011-10-09
2240	Excel 2010 Business Math 18: Reducing Fractions: Factors, Products, Prime Numbers	23:53	2011-10-09
2241	Excel 2010 Business Math 22: Adding & Subtracting Fractions Lest Common Denominator LCM Function	39:25	2011-10-09
2242	Excel 2010 Business Math 20: Multiplying and Dividing Fractions	14:38	2011-10-09
2243	Excel 2010 Business Math 23: Fraction Business Math Word / Application Problem	14:58	2011-10-09
2244	Excel 2010 Business Math 21: Convert Decimal To Fraction & Convert Fraction To Decimal	15:37	2011-10-09
2245	Excel 2010 Business Math 19: Mixed Number to Improper Fraction, Improper Fraction to Mixed Number	7:25	2011-10-09
2246	Excel 2010 Business Math 19.5: How To Display Fraction That Is Not Reduced	2:21	2011-10-09
2247	Excel 2010 Business Math 24: Cancelling Units in Fractions	3:46	2011-10-09
2248	Mr Excel & excelisfun Trick 86: MODE or MEDIAN From Frequency Table Formula or VBA?	9:09	2011-10-07
2249	Mr Excel & excelisfun Trick 85: Algebra Solving For Unknown: Goal Seek Or Algebra Excel Formula?	8:42	2011-10-01
2250	Excel 2010 Business Math 11: Round by Hand & Amazing ROUND function!	28:33	2011-10-01
2251	Excel 2010 Business Math 15: Word / Application Math Problems In Excel -- 3 Step Method	27:24	2011-10-01
2252	Excel 2010 Business Math 10: Writing Numbers As Words For Checks	9:50	2011-10-01
2253	Excel 2010 Business Math 12: Adding and Subtracting In Excel	12:54	2011-10-01
2254	Excel 2010 Business Math 13: Multiplying and Dividing in Excel	11:06	2011-10-01
2255	Excel 2010 Business Math 14: Exponents in Excel Formulas and Formatting	3:32	2011-10-01
2256	Excel 2010 Business Math 16: Solve Math Word Problem # 2	11:36	2011-10-01
2257	Excel 2010 Magic Trick 813: Compare Two Lists Extract Items In List 2 That Are Not In List 1	6:18	2011-09-29
2258	Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports	7:34	2011-09-27
2259	Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Function	11:16	2011-09-27
2260	Excel Magic Trick 810: RANKIF Function RANK IF: Ranking With Conditions	7:15	2011-09-27
2261	Excel Magic Trick 806: Schedule with Holidays Conditional Formatting & Custom Number Formatting	10:26	2011-09-27
2262	Excel Magic Trick 809: Diff Workbook: Advanced Filter Extract Unique Records & Adding W Criteria	6:21	2011-09-27
2263	Excel Magic Trick 807:Protect Sheet To Allow Data Enter Only In Cells With Raw Data	3:02	2011-09-27
2264	Excel Magic Trick 808: Copy Sheet and link Only Cells With Raw Data Go To Special Select Constants	3:34	2011-09-27
2265	Excel 2010 Business Math 08: Relative and Absolute Cell References and Fill Handle and Angry Rabbit	14:31	2011-09-23
2266	Mr Excel & excelisfun Trick 84: Count Calls Every 15 Minutes Count Times Between Upper & Lower Limit	9:06	2011-09-23
2267	Excel 2010 Business Math 02: Formulas In Excel	11:57	2011-09-23
2268	Excel 2010 Business Math 05: Don't Get Tricked By Number Formatting (Number Formatting As Façade)	15:48	2011-09-23
2269	Excel 2010 Business Math 01: Intro To Excel: Ribbons, QAT, Worksheets, Workbooks, Calculations	23:34	2011-09-23
2270	Excel 2010 Business Math 03: Stylistic and Number Formatting	11:07	2011-09-23
2271	Excel 2010 Business Math 04: Range Functions Rule!	3:10	2011-09-23
2272	Excel 2010 Business Math 07: How To Search For and Use Excel Functions	10:36	2011-09-23
2273	Excel 2010 Business Math 06: Math Order Of Operations & Formulas In Excel	6:16	2011-09-23
2274	Excel 2010 Business Math 09: Summarize Formula Inputs, Formulas & Stylistic Number Formatting	6:57	2011-09-23
2275	Excel Magic Trick 805: Unique List When Adjacent Cell Contains 1 of 4 Words SEARCH Function & More	11:18	2011-09-16
2276	Excel Magic Trick 803: COUNTIF Function Criteria & Comparative Operator Trouble & ASCII Characters	5:27	2011-09-16
2277	Excel Magic Trick 804: Chart Double Horizontal Axis Labels & VLOOKUP to Assign Sales Category	3:21	2011-09-16
2278	Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format	11:19	2011-09-16
2279	Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple Records	7:40	2011-09-09
2280	Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple Records	7:30	2011-09-09
2281	Mr Excel & excelisfun Trick 82: Allow Below Limit: Data Validation or Conditional Formatting	6:37	2011-09-09
2282	Excel 2010 Magic Trick 800: Alter VLOOKUP Table To Simplify Formula To Return Multiple Items	6:27	2011-09-06
2283	Excel 2010 Magic Trick 799: TRANSPOSE IF formula Transpose Data Show Text instead of Blanks/Zeros	3:57	2011-09-06
2284	Excel 2010 Magic Trick 798: Partial Text Lookup Formula To Return Multiple E-mail Records	10:29	2011-09-06
2285	Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE	13:23	2011-09-06
2286	Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula	10:21	2011-09-02
2287	Excel 2010 - 20 New Excel 2010 Features - Northwest Accounting Educator's Conference 2011	52:08	2011-09-02
2288	Broken Wrist = No excelisfun Videos For About A Month	0:16	2011-07-26
2289	Excel 2010 Statistics 64: Relationship Between Poisson & Exponential Probability Distributions	14:02	2011-07-22
2290	Excel 2010 Statistics 55: Uniform Probability Distributions	14:01	2011-07-19
2291	Excel 2010 Statistics 54: Continuous Probability Distributions (Basics)	17:06	2011-07-19
2292	Excel 2010 Statistics 62: Calculating Bell Normal Distribution Probabilities & X Values 10 Examples	13:27	2011-07-19
2293	Excel 2010 Statistics 56: Normal (Bell) & Standard Normal Characteristics	13:40	2011-07-19
2294	Excel 2010 Statistics 57: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV Functions Bell Curve	16:31	2011-07-19
2295	Excel 2010 Statistics 60: Normal Bell Probabilities Between 2 X or Z Values Area Charts & Functions	17:48	2011-07-19
2296	Excel 2010 Statistics 58: Charting Normal Bell Curve In Excel With X and Z Values & Dynamic Ranges	20:17	2011-07-19
2297	Excel 2010 Statistics 59: Normal Bell Probabilities Above X & Area Charts To Show Area above X	15:45	2011-07-19
2298	Excel 2010 Statistics 61: Find X Given Normal Probabilities NORM.INV & NORM.S.INV Functions	7:13	2011-07-19
2299	Excel 2010 Statistics 63: Exponential Probability EXPON.DIST function	8:15	2011-07-19
2300	Excel 2010 Statistics 50: BINOM.DIST Function (3 Examples) Mean & Standard Deviation for BD	29:08	2011-07-18

2301	Excel 2010 Statistics 44: Discrete Probability Distributions (Basics)	18:59	2011-07-15
2302	Excel 2010 Statistics 53: POISSON.DIST function Poisson Probability Distribution	15:38	2011-07-15
2303	Excel 2010 Statistics 45: Build Discrete Probability Distribution	20:09	2011-07-15
2304	Excel 2010 Statistics 49: Binomial Experiment, Probabilities, Chart and BINOM.DIST Function	31:56	2011-07-15
2305	Excel 2010 Statistics 47: Discrete Probability Mean & Standard Deviation	18:07	2011-07-15
2306	Excel 2010 Statistics 46: Discrete Probability Chart with 2 Data Sets	6:46	2011-07-15
2307	Excel 2010 Statistics 48: Accounting & Finance Examples of Expected Value & Standard Deviation	17:25	2011-07-15
2308	Excel 2010 Statistics 52: Cumulative BINOM.DIST Chart with IF Function	16:37	2011-07-15
2309	Excel 2010 Statistics 51: How Shape Of Binomial Distribution Changes As n And p Change	3:36	2011-07-15
2310	Excel 2010 Statistics 43: Further Explanation of Bayes' Theorem & Posterior Probabilities	11:36	2011-07-12
2311	Excel 2010 Statistics #36: Probability Basics with Excel	31:18	2011-07-12
2312	Excel 2010 Statistics #35: Probability Basics (by hand notes)	23:39	2011-07-12
2313	Excel 2010 Statistics #38: Probability Laws in Excel, Adding, Multiplying, Conditional Probability	11:24	2011-07-12
2314	Excel 2010 Statistics #40: Joint Probability Table and More!	11:54	2011-07-12
2315	Excel 2010 Statistics #37: Probability Laws (by hand notes) Adding, Multiplying and More	16:29	2011-07-12
2316	Excel 2010 Statistics #39: HYPGEOM.DIST and Conditional Probabilities New Excel 2010 Function	9:58	2011-07-12
2317	Excel 2010 Statistics #41: Joint Probability Table with PivotTable	9:11	2011-07-12
2318	Excel 2010 Statistics 42: Bayes' Theorem Posterior Probabilities & SUMPRODUCT	6:26	2011-07-12
2319	Excel 2010 Statistics #34.5: Z-Score IF, Standard Deviation IF, Mean IF, Mode IF, Median IF	15:42	2011-07-11
2320	Excel 2010 Statistics #30: Standard Deviation: How fairly does the mean represent its data points?	41:35	2011-07-07
2321	Excel 2010 Statistics #31: z-Scores, Chebyshev's Theorem and Empirical Rule	28:11	2011-07-07
2322	Excel 2010 Statistics #32: Detecting Outliers	6:12	2011-07-07
2323	Excel 2010 Statistics #33: SKEW function, Relationship between Mean Median & Mode and Skew	6:23	2011-07-07
2324	Excel 2010 Statistics #34: Data Analysis Add-in Descriptive Statistics tool	2:54	2011-07-07
2325	Excel 2010 Statistics #26: Location: Mean, Median, Mode, Percentile, Quartile, PercentileRank	12:53	2011-07-07
2326	Excel 2010 Statistics #25: Typical Values: Mean, Median, Mode	27:51	2011-07-07
2327	Excel 2010 Statistics #24: Conditional Formatting Cell Chart Histogram	2:57	2011-07-07
2328	Excel 2010 Statistics #27: Excel 2010 Functions for Percentile, Quartile and Rank	23:36	2011-07-07
2329	Excel 2010 Statistics #28: Box & Whisker Plot: Stacked Bar with Mean Point Plotted and Outlier Lines	22:48	2011-07-07
2330	Excel 2010 Statistics #29: Means: Weighted, Trimmed, From Grouped Data, Geometric Mean	15:33	2011-07-07
2331	Excel 2010 Statistics #20: Stem and Leaf Chart with REPT and COUNTIFS functions	8:22	2011-07-01
2332	Excel 2010 Statistics #18: Frequency Distribution Shape & Histogram Skew & Sparklines	15:06	2011-07-01
2333	Excel 2010 Statistics #19: Dot Plot Chart with REPT and COUNTIFS functions	10:38	2011-07-01
2334	Excel 2010 Statistics #23: Scatter Diagram to show Relationship Between Two Quantitative Variables	9:28	2011-07-01
2335	Excel 2010 Statistics #21: Cross Tabulation With PivotTable Frequencies and % Column & % Row	15:13	2011-07-01
2336	Excel 2010 Statistics #22: Cross Tabulation With Formulas	5:00	2011-07-01
2337	Excel 2010 Statistics #17 Ogive Chart Formula PivotTable Data Analysis Toolpak Add-in & Pareto Chart	35:11	2011-07-01
2338	Excel 2010 Statistics #16: Relative & Percent Frequency Distributions & Pie Chart & Histogram	17:21	2011-07-01
2339	Navigate Long Videos at excelisfun with Time Links in Show More Link Below Video	1:38	2011-06-30
2340	Excel 2010 Statistics #15: Frequency Distributions, Histograms, Column Charts (11 Examples)	1:18:29	2011-06-30
2341	Excel 2010 Statistics 13: Scales Of Measurement: Nominal, Ordinal, Interval, Ratio	14:14	2011-06-22
2342	Excel 2010 Statistics 10: Percentage Change and Ending Balance Formulas	10:19	2011-06-22
2343	Excel 2010 Statistics 11: What Is Statistics?	12:31	2011-06-22
2344	Excel 2010 Statistics 12 Data Sets, Excel Tables For Formulas & Charts, Cross Sectional, Time Series	24:20	2011-06-22
2345	Excel 2010 Statistics 14: Descriptive & Inferential Statistics	9:04	2011-06-22
2346	Excel 2010 Statistics 01: Introduction To Excel 2010 For Statistics	19:05	2011-06-17
2347	Excel 2010 Statistics 06: Data Analysis: Sorting and PivotTables	23:14	2011-06-17
2348	Excel 2010 Statistics 03: Calculations, Formulas, Functions, Math & Comparative Operators	29:31	2011-06-17
2349	Excel 2010 Statistics 02: Excel 2010 Data Analysis Add-in	1:38	2011-06-17
2350	Excel 2010 Statistics 04: Number Formatting As Façade Accounting Percentage Proportion Probability	15:12	2011-06-17
2351	Excel 2010 Statistics 05: Data Sets How They Are Setup & Terminology In Statistics & Data Analysis	4:16	2011-06-17
2352	Excel 2010 Statistics 07: Charts Basics: Pie, Column, Bar, Line and X-Y Scatter	31:49	2011-06-17
2353	Excel 2010 Statistics 09: Proportions, Probabilities and Percentages: Formulas and Formatting	10:31	2011-06-17
2354	Excel 2010 Statistics 08: Cell References In Formulas: Relative and Absolute	11:24	2011-06-17
2355	Excel 2010 Magic Trick 795: Pivot Table: Transactional Payroll Data Into Employee Reports PivotTable	6:02	2011-06-13
2356	Excel 2010 Magic Trick 796: Excel Flip Table Rotate Table TRANSPOSE or INDEX or Paste Special	8:05	2011-06-13
2357	Excel Magic Trick 793: Add Between Two Dates/Times/Numbers SUMIF & SUMIFS 10 Examples	20:20	2011-06-10
2358	Excel Magic Trick 792: Defined Names In Formulas	12:21	2011-06-10
2359	Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row	10:07	2011-06-10
2360	Excel Lesson in Gregory's Physics Class #1: Setup Data, X-Y Scatter Plot, Add Chart Labels	10:33	2011-06-07
2361	Excel Lesson in Gregory's Physics Class #2: Formula For Plotting Theoretical Line With X-Y Scatter	14:27	2011-06-07
2362	Excel Lesson in Gregory's Physics Class #4: X Y Scatter Data Points &Theoretical Line In Same Chart	14:29	2011-06-07
2363	Excel Lesson in Gregory's Physics Class #3: Linear Regression Trendline in Excel Charting	4:53	2011-06-07
2364	Excel 2010 Magic Trick 790: Formulas Convert Single Records Into Columns & Repeat Unique Identifier	14:54	2011-06-07
2365	Excel Magic Trick 788: Add Numbers After Last Zero	11:25	2011-06-06
2366	Excel 2010 Magic Trick 789: Extract Records That Match Criteria for Multiple Reports Across Sheets	17:43	2011-06-06
2367	Excel Magic Trick 791: Partial Part Number Lookup: LOOKUP SEARCH functions and more...	10:48	2011-06-06
2368	Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)	1:09:30	2011-05-27
2369	Mr Excel & excelisfun Trick 80: Chart Titles	7:46	2011-05-27
2370	Excel Magic Trick 783: Date Functions & Formulas (17 Examples)	19:06	2011-05-21
2371	Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria	8:58	2011-05-21
2372	Excel Magic Trick 780: 3-D Cell References For SUMIF Function - Adding with Criteria Across Sheets	9:43	2011-05-21
2373	Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells	7:23	2011-05-21
2374	Excel Magic Trick 782: Find All Numbers With 4, 2, 3 ISNUMBER & SEARCH functions	4:44	2011-05-21
2375	Excel Magic Trick 784: Empty Cells OR Formula Created Blank: Confusion Over Word "Blank"	11:31	2011-05-21
2376	Excel Magic Trick 785: Extract Top 3 Customer Names With Formula (Robust Formula Handles Dups)	10:15	2011-05-21
2377	Excel Magic Trick 786: Dynamic 5 Week Chart Example When Formulas Better Than PivotTable	10:50	2011-05-21
2378	Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards	55:05	2011-05-19
2379	Excel Magic Trick 777.75: SUMPRODUCT Solves: SUMIF Won't Calculate From Closed Workbook	7:55	2011-05-16
2380	Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)	1:09:39	2011-05-14
2381	Mr Excel & excelisfun Trick 79: Formula, PivotTable or PowerPivot? PowerPivot Wins For Big Data Sets	8:10	2011-05-13
2382	Mr Excel & excelisfun Trick 78: Extract Top Two Customers In Each Industry with Formula (2 Examples)	10:54	2011-05-06
2383	Warning!!!!! EXCELISFUN.COM IS NOT EXCELISFUN	1:09	2011-05-06
2384	Mr Excel & excelisfun Trick 77: Top Two Customers In Each Industry PivotTable or Sort Filter Formula	6:56	2011-04-29
2385	4-Year Old Does Excel Magic Trick: RAND function, Conditional Formatting & Bubble Chart	3:44	2011-04-22
2386	Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE	9:12	2011-04-22
2387	Mr Excel & excelisfun Trick 76: Worksheet With Hyperlinks That Jump To Each Sheet In The Workbook	7:46	2011-04-22
2388	Excel Magic Trick 777: SUMPRODUCT Function -- Basics To Advanced (14 Examples)	36:28	2011-04-19
2389	Mr Excel & excelisfun Trick 75: Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX?	9:41	2011-04-15
2390	Mr Excel & excelisfun Trick 74: Dynamic Range For VLOOKUP & Data Validation List - Table Feature	9:03	2011-04-08
2391	Excel Magic Trick 776: Slaying Excel Dragon DVD Out! & RANK From More Than One Column Trick	2:53	2011-04-06
2392	Mr Excel & excelisfun Trick 73: Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions	10:05	2011-04-01
2393	Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Number	4:04	2011-04-01
2394	Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ROUND & MROUND	8:09	2011-03-31
2395	Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Together	10:29	2011-03-30
2396	Excel Magic Trick 772: Remove Spaces From Number and Convert To Number	1:35	2011-03-28
2397	Excel Magic Trick 770: Count Cells With Color Using Filter Feature or SUBTOTAL function	4:22	2011-03-25
2398	Excel Magic Trick 771: Calculate Your "Current" Grade: SUMIF, SUM & VLOOKUP functions	10:56	2011-03-25
2399	Mr Excel & excelisfun Trick 72: Data Bar Cell Charts in Excel 2007/2010 & Excel 2003	3:30	2011-03-24
2400	Add Dot Com To End Of Column Of Words Excel Formula, Copy, Paste Special Values	0:35	2011-03-19

2401	Mr Excel & excelisfun Trick 71: ROUND to 4 or 2 Formula or Conditional Formatting?	4:43	2011-03-18
2402	Excel Magic Trick 769: Adding & Conditional Formatting with NOT Criteria	5:48	2011-03-15
2403	Excel Magic Trick 768: Gradebook Average w Criteria and Conditionally Format Less Than 4 Tests Taken	6:26	2011-03-14
2404	Office 2010 Class #48: Import Excel Data Into Access & Compare & Contrast Formulas in Access & Excel	14:18	2011-03-14
2405	Office 2010 Class #49: Word Letter Mail Merge w Excel Data (Number Format Problem & Field Code Fix)	16:42	2011-03-14
2406	Office 2010 Class 50: Word Letter Mail Merge w Excel Data (Number Format Problem TEXT function Fix)	8:40	2011-03-14
2407	Office 2010 Class #51: Word E-Mail Mail Merge from Data In an Access Database	7:42	2011-03-14
2408	Mr Excel & excelisfun Trick 70: Lookup & Return Last 5 Numbers in a List	7:24	2011-03-11
2409	Excel Magic Trick 767: Count Months from Start and End Date	6:55	2011-03-11
2410	Excel Magic Trick 766: Count Times Before And After A Stated Time.	4:58	2011-03-09
2411	excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks and more...	5:44	2011-03-09
2412	Excel Magic Trick 765: Formula To Sort Top 3, Including Ties	9:26	2011-03-08
2413	Excel Magic Trick 764: CHOOSE Function To "Mash" Columns Together To Create Lookup Tables	7:24	2011-03-08
2414	Office 2010 Class #47: Export Data From Access To Excel, PDF or Text File	6:29	2011-03-08
2415	Office 2010 Class #46: Access Create Report Based On A Query	11:54	2011-03-08
2416	Office 2010 Class #45: Creating Queries In Access (16 Examples)	37:54	2011-03-07
2417	Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data	5:47	2011-03-05
2418	Office 2010 Class #44: Access Create Forms (User Interface), Enter Data Tricks	7:48	2011-03-05
2419	Office 2010 Class #43: Access One To Many Relationship Between Tables	6:18	2011-03-05
2420	Office 2010 Class #42: Access Create Database, Import Table, Create Table, Data Validation For Table	37:36	2011-03-05
2421	Office 2010 Class #41: Introduction to Databases and Access	33:39	2011-03-05
2422	Mr Excel & excelisfun Trick 69: Count Saturdays	5:59	2011-03-04
2423	Slaying Excel Dragon Book Is Out In Print! Also: Cool Excel MONTH Function Trick.	5:57	2011-03-03
2424	Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending	15:03	2011-03-03
2425	Excel Magic Trick 761: Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT	7:24	2011-03-02
2426	Mr Excel & excelisfun Trick 68: Count Dates in Column That Match Year and Month Criteria	8:05	2011-02-25
2427	Mr Excel & excelisfun Trick 67: Extract Initials From Full Name: VBA or Formula?	6:29	2011-02-18
2428	Mr Excel & excelisfun Trick 66: Slaying Excel Dragons E-Book Available at Mr Excel Web Site!	14:18	2011-02-11
2429	Office 2010 Class #22: Excel Formulas: Math Operators and Order Of Operations	8:40	2011-02-05
2430	Office 2010 Class #20 What Is Excel?, Editing Ribbons & Quick Access Toolbar, File Extensions	19:53	2011-02-05
2431	Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?	31:27	2011-02-05
2432	Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)	24:09	2011-02-05
2433	Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF	22:32	2011-02-05
2434	Office 2010 Class #27: Excel Stylistic Formatting & Page Setup For Reports	15:24	2011-02-05
2435	Office 2010 Class #25: Excel Cell References: Relative, Absolute, Mixed	34:29	2011-02-05
2436	Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)	17:22	2011-02-05
2437	Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions	21:18	2011-02-05
2438	Office 2010 Class #35: Excel Sort and Filter (Data Analysis)	18:26	2011-02-05
2439	Office 2010 Class #28: Excel Number Formatting: Formatting As Façade	23:11	2011-02-05
2440	Office 2010 Class #29: Excel ROUND Function How And When To Use It.	12:25	2011-02-05
2441	Office 2010 Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting	34:06	2011-02-05
2442	Office 2010 Class #31: Excel Time Number Format & Payroll Time Sheet Calculations	8:47	2011-02-05
2443	Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days	3:52	2011-02-05
2444	Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)	12:20	2011-02-05
2445	Office 2010 Class #32: Excel Percentage Number Format (6 Examples)	6:37	2011-02-05
2446	Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features	5:22	2011-02-05
2447	Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)	14:54	2011-02-05
2448	Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables	5:39	2011-02-05
2449	Office 2010 Class #40: Excel SUM Function Keyboard Shortcut for 5000 Rows of Data	2:25	2011-02-05
2450	Office 2010 Class #18: Excel Intro Project 01: Data, Formatting, Formulas, Page Setup	54:50	2011-01-28
2451	Office 2010 Class #19: Excel Intro Project 02: Formulas, Charts, Page Setup Net Income	27:18	2011-01-28
2452	Mr Excel & excelisfun Trick 64: Extract Records With Not Criteria VBA or Filter	4:08	2011-01-27
2453	Mr Excel & excelisfun Trick 63: 2 Criteria Lookup and Multiple Table Lookup From Different Sheets	9:35	2011-01-20
2454	Mr Excel excelisfun Trick 62: Conditional Format Chart Auto Feature or Formula	8:16	2011-01-15
2455	Office 2010 Class #17: How To PowerPoint Tricks	42:16	2011-01-14
2456	excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks.	6:07	2011-01-13
2457	Office 2010 Class #10: Word Tables & Paste Special Link Excel Table Into Word Document	20:23	2011-01-12
2458	Office 2010 Class #11: Word Tabs: Left, Right, Center, Decimal, Bar	8:36	2011-01-12
2459	Office 2010 Class #12: Word Objects & Word Wrap	5:11	2011-01-12
2460	Office 2010 Class #15: Word Business Letter & Letterhead	28:43	2011-01-12
2461	Office 2010 Class #13: Word Theme affects Shapes, Tables, Smart Art, Numbered Lists and Styles	4:50	2011-01-12
2462	Office 2010 Class #14: Word Print Preview and Print Dialog Box Are The Same	2:46	2011-01-12
2463	Office 2010 Class #16: Word Style Tricks: Send Word To PowerPoint & Table Of Contents	17:57	2011-01-12
2464	Mr Excel & excelisfun Trick 61: Formula To Report Cell Reference 5 Examples	5:13	2011-01-07
2465	Excel Magic Trick 760: OR AND AND Logical Test To Extract Data With Formula Or Advanced Filter	11:53	2010-12-31
2466	Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range	17:02	2010-12-31
2467	Office 2010 Class #09 Word Research Paper Tricks Footnotes, Citations, Bibliographies, Styles, Find	40:17	2010-12-31
2468	Office 2010 Class #06: Word Hyperlinks and Save As Web Page	15:31	2010-12-31
2469	Office 2010 Class #05: Word Formatting, Insert Picture, Navigation, Selection Tricks, Backup Files	40:20	2010-12-31
2470	Office 2010 Class #08: Word Three Levels Of Formatting: Character, Paragraph, Section	23:06	2010-12-31
2471	Office 2010 Class #07: Spell Check, Custom Dictionary -- Auto Correct For Spelling and Shorthand	15:19	2010-12-31
2472	Office 2010 Class #04: Introduction To Word, Ribbons, QAT, Non-Printing Characters, Clipboard & More	46:42	2010-12-31
2473	Office 2010 Class #03: Creating System Of Folders For File Management Using Windows Explorer	21:33	2010-12-31
2474	Office 2010 Class #01: Windows Explorer and Introduction To Office 2010	21:58	2010-12-31
2475	Office 2010 Class #02: Using Windows Explorer For File Management	17:21	2010-12-31
2476	Mr Excel & excelisfun Trick 60: Conditional Format High Blood Pressures -- 4 Methods	6:49	2010-12-30
2477	Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions	15:06	2010-12-28
2478	Excel Magic Trick 757.5: Two Lookup Columns Or Sum With Two Criteria?	8:09	2010-12-28
2479	Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods	15:12	2010-12-26
2480	Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH	8:32	2010-12-26
2481	Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets	14:32	2010-12-26
2482	Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell	7:46	2010-12-26
2483	Mr Excel & excelisfun Trick 59: Custom Lists, Defined Names, PivotTable & COUNTIF Function	5:28	2010-12-24
2484	Mr Excel & excelisfun Trick 58.5: Sorting Formula For Biggest Sales and Sales Rep Names with Ties	5:24	2010-12-17
2485	Excel Magic Trick 755: Extract Records For Invoices 30 Days Past Due -- Advanced Filter & MACRO	12:57	2010-12-13
2486	Excel Magic Trick 754: Extract Records For Invoices 30 Days Past Due -- Formula Method	14:20	2010-12-13
2487	Excel Magic Trick 753: Extract Records For Invoices 30 Days Past Due -- Filter Method	6:28	2010-12-13
2488	Excel Magic Trick 745: Allocating Indirect Expenses to Calculate Departmental Net Income Accounting	10:58	2010-12-08
2489	Excel Magic Trick 743: Conditional Formatting To Match Items In List On A Different Sheet	4:53	2010-12-08
2490	Excel Magic Trick 741: Avoid Errors & Blanks In Chart Using Formulas & Defined Name Dynamic Ranges	14:31	2010-12-08
2491	Excel Magic Trick 740: Avoid Errors & Blanks In Chart Using Filter	3:35	2010-12-08
2492	Excel Magic Trick 742: Wrap Text In Chart Label Using CHAR function and Code 10	4:29	2010-12-08
2493	Excel Magic Trick 744: Break Even Analysis Formulas Chart & Plotting Break Even Point On Chart	18:02	2010-12-08
2494	Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic	6:26	2010-12-08
2495	Excel Magic Trick 747: Expected Returns and Standard Deviation Single Cell Array Formula	3:55	2010-12-08
2496	Excel Magic Trick 748: Count Weekends With No Events Scheduled Formula	9:55	2010-12-08
2497	Excel Magic Trick 749: Add Yearly Totals From Daily Date Data without SUMIF Function	2:44	2010-12-08
2498	Excel Magic Trick 750: 7 Days Past Due Conditional Formatting & Logical Formula	5:00	2010-12-07
2499	Excel Magic Trick 751: Freeze Panes For Large Workbooks Freeze either a Row, Column, or Both	2:16	2010-12-07
2500	Excel Magic Trick 752: Fill Column With Categories Using Approximate Lookup Formula	7:50	2010-12-07

2501	Mr Excel & excelisfun Trick 58: Sorting Formula For Biggest Sales and Sales Rep Names with Ties	9:35	2010-12-03
2502	ACCTG 455: Excel Finance Class 107: Calculating Beta (2 Methods)	11:16	2010-12-03
2503	ACCTG 455: Excel Finance Class 103: 2 Ways To Calculate Geometric Mean	4:46	2010-11-30
2504	ACCTG 455: Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock	11:44	2010-11-30
2505	ACCTG 455: Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio	10:48	2010-11-30
2506	ACCTG 455: Excel Finance Class 106: Market & Asset Specific Risk, Diversification, Beta	14:00	2010-11-30
2507	ACCTG 455: Excel Finance Class 108: Reward To Risk Ratio - Treynor Index	6:18	2010-11-30
2508	ACCTG 455: Excel Finance Class 109: Beta For Portfolio	3:59	2010-11-30
2509	ACCTG 455: Excel Finance Class 110: Security Market Line (SML) & Capital Asset Pricing Model (CAPM)	9:17	2010-11-30
2510	ACCTG 455: Excel Finance Class 111: Treynor Index & CAPM	3:03	2010-11-30
2511	Mr Excel & excelisfun Trick 57: Extract Many Years from Just Two Years	7:17	2010-11-24
2512	ACCTG 455: Excel Finance Class 102: Short Run Financial Markets Can Be Inefficient Mispriced Assets	4:15	2010-11-22
2513	ACCTG 455: Excel Finance Class 97: Using Geometric Mean & Arithmetic Mean to Estimate Future Returns	3:52	2010-11-20
2514	ACCTG 455: Excel Finance Class 99: US Capital Market History 5 Types Investments (2 Good Lessons)	21:07	2010-11-20
2515	ACCTG 455: Excel Finance Class 96: Compare Geometric Mean & Arithmetic Mean For Average Stock Return	15:59	2010-11-20
2516	ACCTG 455: Excel Finance Class 90: Period (Holding) Returns For Stock	5:45	2010-11-20
2517	ACCTG 455: Excel Finance Class 91: Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond	4:18	2010-11-20
2518	ACCTG 455: Excel Finance Class 92: Period (Holding) Returns For Zero Bond	3:51	2010-11-20
2519	ACCTG 455: Excel Finance Class 93: Period (Holding) Returns For Preferred Stock	2:41	2010-11-20
2520	ACCTG 455: Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR	4:41	2010-11-20
2521	ACCTG 455: Excel Finance Class 95: Use Past Period Holding Returns to Estimate Future Returns: Mean	3:56	2010-11-20
2522	ACCTG 455: Excel Finance Class 98: Stock Return Risk Measured with Standard Deviation	10:46	2010-11-20
2523	ACCTG 455: Excel Finance Class 100: Real Rate and Inflation or Deflation For T-bills.	3:30	2010-11-20
2524	ACCTG 455: Excel Finance Class 101: Average Real Return For A Stock Based On Historical Data	2:58	2010-11-20
2525	Mr Excel & excelisfun Trick 56: Copy Formula Down, Have Range Move Across	5:05	2010-11-18
2526	Plot F(x) Function & Chart In Excel - Gregory's Physics Class Acceleration of Block Up Down Ramp	21:36	2010-11-16
2527	Excel Magic Trick 689: Fill Column With 1 to 1000 Two Methods: 1) Series & 2) GoTo	2:30	2010-11-16
2528	Excel Magic Trick 687: Exclude Values Less Than Zero From Non-Contiguous Ranges - Amazing!	10:48	2010-11-16
2529	Excel Magic Trick 686: Fill Column & Concatenate With LOOKUP Last Word Expandable Range Trick	5:36	2010-11-16
2530	Excel Magic Trick 688: Lookup All Values In Expanding Dynamic Row and then Add	5:32	2010-11-16
2531	Excel Magic Trick 690: Extract Unique Records Based on 2 Columns, List Values Horizontally	17:58	2010-11-15
2532	Excel Magic Trick 691: Look At Cell C2 No Matter How Many Rows Or Columns You Insert Or Delete	5:01	2010-11-15
2533	Excel Magic Trick 737: Sorting Wrecks Formula, Use VLOOKUP function To Solve Problem	6:39	2010-11-15
2534	Excel Magic Trick 738: Goal Seek, PMT function for Loan Payment, Cash Flows and Balloon Payment	6:38	2010-11-15
2535	Excel Magic Trick 736: Formula & Conditional Formatting To Show Waste From Cutting Rebar	6:57	2010-11-15
2536	Excel Magic Trick 739: Three Ways To Do Double Underline in Excel	2:18	2010-11-14
2537	ACCTG 455: Excel Finance Class 80: Recognizing Cash Flow Patterns in Discounted Cash Flow Analysis	7:46	2010-11-14
2538	ACCTG 455: Excel Finance Class 83: Estimating Cash Flows For NPV calculation	16:45	2010-11-14
2539	ACCTG 455: Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses	12:40	2010-11-14
2540	ACCTG 455 Excel Finance Class 82 Discounted Relevant Costs Cash Flow Analysis Incremental Cash Flows	17:06	2010-11-14
2541	ACCTG 455: Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations	10:55	2010-11-14
2542	ACCTG 455: Excel Finance Class 84: Undoing Accrual Accounting to Get Cash Flows For Estimating NPV	7:10	2010-11-14
2543	ACCTG 455: Excel Finance Class 86: Estimating Cash Flows For NPV Calculation Comprehensive Example.	22:11	2010-11-14
2544	ACCTG 455: Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations	14:06	2010-11-14
2545	ACCTG 455: Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows	10:37	2010-11-14
2546	ACCTG 455: Excel Finance Class 87: Cost Savings Example Estimating Cash Flows For NPV calculation	7:33	2010-11-14
2547	ACCTG 455: Excel Finance Class 76: Investment Criteria: MIRR - Modified Internal Rate of Return	9:09	2010-11-11
2548	Mr Excel & excelisfun Trick 55: Calculate Grade & Exclude Scores When Student Is Absent.	5:36	2010-11-11
2549	Excel Magic Trick 735: Find Max Running Three Week Totals SUBTOTAL / OFFSET Array Formula	11:31	2010-11-08
2550	ACCTG 455: Excel Finance Class 30: Future Value For Interest Paid Daily, But Deposits Made Monthly	5:51	2010-11-08

For your README

Embed a badge

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

Markdown

[![Watch time: 23d 16h 31m · 2,550 videos](https://playlistduration.com/badge/playlist/UUkndrGoNpUDV-uia6a9jwVg.svg)](https://playlistduration.com/playlist/UUkndrGoNpUDV-uia6a9jwVg)

HTML

<a href="https://playlistduration.com/playlist/UUkndrGoNpUDV-uia6a9jwVg"><img src="https://playlistduration.com/badge/playlist/UUkndrGoNpUDV-uia6a9jwVg.svg" alt="Watch time: 23d 16h 31m · 2,550 videos" width="253" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/UUkndrGoNpUDV-uia6a9jwVg returns them as JSON — free, no key. API docs →

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