1
Excel Magic Trick #184: Setup Database in Excel
7:51
2009-01-03
2
Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail
25:46
2016-01-05
3
Excel Magic Trick #130: 3 Dimensional Database in Excel
7:55
2008-10-17
4
YTLE#64: D Function: DAVERAGE DSUM & more
10:11
2008-07-24
5
Excel Magic Trick 310: D Functions & Date Criteria
3:02
2009-05-01
6
Excel Magic Trick 312: Extract Date & Time From Text String
5:13
2009-05-01
7
Excel Basics #18: Data Analysis Sort
5:31
2008-12-16
8
Excel Basics #19: Data Analysis Subtotals
5:49
2008-12-16
9
Excel Basics #20: Data Analysis Pivot Tables PivotTables
10:23
2008-12-16
10
Excel Basics #21: Data Analysis Filter &Dynamic Ranges
6:02
2008-12-16
11
YTL Excel #130: Income Statement from Excel Table: Array For
10:21
2008-09-17
12
Excel Magic Trick #183: Income Statement by Year & Month
7:35
2009-01-03
13
YTLE#100: Array Formula Database Customer Evaluation
8:37
2008-08-13
14
YTLE#95.2: Identifying Customers in Database
5:29
2008-08-12
15
YouTubersLoveExcel#45: SUMPRODUCT & TEXT functions
4:49
2008-06-27
16
Excel Magic Trick 330: DCOUNT DSUM between 2 Numbers
3:38
2009-05-29
17
Excel Magic Trick 378: Field Names Should Be Formatted
2:36
2009-09-04
18
Excel Magic Trick 508: VLOOKUP with Dynamic Table using OFFSET function
12:15
2010-02-17
19
Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclature
12:01
2010-02-17
20
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through
11:33
2010-03-05
21
Mr Excel & excelisfun Trick 82: Allow Below Limit: Data Validation or Conditional Formatting
6:37
2011-09-09
22
Excel 2013 Power Query #01: Append 3 Tables Into One in PowerPivot or Excel Table
5:31
2014-11-11
23
Excel Magic Trick 1214: How To Enter Text Criteria Into Excel Database Functions
4:07
2015-07-28
24
Excel Magic Trick 1217: D Functions: Text Criteria: “Starts With”, “Exact” and “Contains”
5:07
2015-07-31
25
Highline Excel 2016 Class 19: Transform Data Sets using Advanced Filter (8 Examples)
33:42
2016-06-04
26
Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transform)
28:34
2016-10-13
27
Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform
29:48
2016-10-16
28
Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model?
11:35
2016-10-27
29
Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Files
18:43
2016-12-10
30
Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555
3:32
2019-07-01
31
Excel Table Column Formulas and Spilled Arrays? Excel Magic Trick 1679
3:38
2020-07-20
32
Create Excel Database and Data Entry Form. Excel Magic Trick 1690.
8:08
2020-09-14
33
How to Rank in Power Query. EMT 1698 by excelisfun.
3:44
2020-11-02
34
Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.
13:09
2021-01-08
35
Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717
6:57
2021-01-15
36
Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2
1:18
2021-02-04
37
Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.
6:21
2021-04-16
38
Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts
36:04
2021-04-19
39
Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!
1:16:25
2021-04-26
40
Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas
58:02
2021-05-10
41
Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752
9:14
2021-09-07
42
Import OneDrive File or Folder using Power Query. EMT 1755
4:29
2021-09-20
43
Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783
8:29
2022-03-22
44
TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785
10:20
2022-03-24
45
VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786
6:29
2022-03-25
46
TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789
3:26
2022-04-04
47
Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790
4:07
2022-04-16
48
Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796
7:50
2022-08-09
49
Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834
9:03
2023-08-11
50
2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2
3:07
2023-11-18
51
Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845
19:34
2023-11-20
52
ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846
2:29
2023-11-19
53
Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848
5:50
2024-01-29
54
Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849
5:41
2024-02-05
55
Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850
3:02
2024-01-23
