Import Worksheet of Data From External Excel File into Current Excel File
excelisfun
Import Worksheet of Data From External Excel File into Current Excel File
1:15
Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887
excelisfun
Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887
17:44
Increase Excel Row Height for Multiple Columns
excelisfun
Increase Excel Row Height for Multiple Columns
0:32
Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889
excelisfun
Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889
3:56
COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891
excelisfun
COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891
6:09
Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890
excelisfun
Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890
3:08
INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888
excelisfun
INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888
3:42
Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886
excelisfun
Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886
3:00
File Explorer Skills To Be Good In Excel? 100% Yes! File Extensions & F2 Trick! EMT 1885
excelisfun
File Explorer Skills To Be Good In Excel? 100% Yes! File Extensions & F2 Trick! EMT 1885
1:23
The Beauty Of Power Query! One Quick Example : )
excelisfun
The Beauty Of Power Query! One Quick Example : )
1:59
MS 365 Excel Basics #13: Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas
excelisfun
MS 365 Excel Basics #13: Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas
46:46
Opposite of TEXTJOIN? It's TEXTSPLIT used to Split Sub-text from Text String. Excel Short 76 Part 3
excelisfun
Opposite of TEXTJOIN? It's TEXTSPLIT used to Split Sub-text from Text String. Excel Short 76 Part 3
1:00
Array of Delimiters in TEXTJOIN for the Perfect Join! Excel Magic Trick Short # 76 part 02
excelisfun
Array of Delimiters in TEXTJOIN for the Perfect Join! Excel Magic Trick Short # 76 part 02
0:56
MS 365 Excel Basics 12: Power BI Desktop & Interactive Visuals / Dashboards, Import Excel Data Model
excelisfun
MS 365 Excel Basics 12: Power BI Desktop & Interactive Visuals / Dashboards, Import Excel Data Model
25:17
GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883
excelisfun
GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883
2:45
MS 365 Excel Basics 11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context Too!
excelisfun
MS 365 Excel Basics 11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context Too!
39:24
Turn Off GETPIVOTDATA Function So I Can Refer To My PivotTable With A Cell Reference. Excel Short 77
excelisfun
Turn Off GETPIVOTDATA Function So I Can Refer To My PivotTable With A Cell Reference. Excel Short 77
1:25
Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882
excelisfun
Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882
4:21
MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total
excelisfun
MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total
3:28
Excel TEXTJOIN Function Trick to Join Text from 2 Columns into 1 Cell! Excel Short Magic Trick 76
excelisfun
Excel TEXTJOIN Function Trick to Join Text from 2 Columns into 1 Cell! Excel Short Magic Trick 76
1:20
MS 365 Excel Basics #10 Part 03: FILTER Array Function to Dynamically Filter!
excelisfun
MS 365 Excel Basics #10 Part 03: FILTER Array Function to Dynamically Filter!
4:41
Introduction to excelisfun @ YouTube: Free Excel Classes, Videos & Practice Files & Power BI Too!
excelisfun
Introduction to excelisfun @ YouTube: Free Excel Classes, Videos & Practice Files & Power BI Too!
1:47
MS 365 Excel Basics #10 Part 02: SORT Array Function & the Many Varied Tasks It Can Achieve!
excelisfun
MS 365 Excel Basics #10 Part 02: SORT Array Function & the Many Varied Tasks It Can Achieve!
6:14
MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples.
excelisfun
MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples.
1:28:49
Mind-Blowing: GROUPBY Function Beats PivotTable, Hands-down. Beats COUNTIFS Too! Excel Short # 75
excelisfun
Mind-Blowing: GROUPBY Function Beats PivotTable, Hands-down. Beats COUNTIFS Too! Excel Short # 75
1:50
MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!
excelisfun
MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!
51:23
Temporary Fix for GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? EMT 1881
excelisfun
Temporary Fix for GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? EMT 1881
1:23
GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks?
excelisfun
GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks?
2:11
Excel Revolution with PIVOTBY & GROUPBY Functions! #Short Preview of Upcoming Video
excelisfun
Excel Revolution with PIVOTBY & GROUPBY Functions! #Short Preview of Upcoming Video
0:26
How to Add Subtitles to YouTube Videos in Multiple Language March 25 2025 Update
excelisfun
How to Add Subtitles to YouTube Videos in Multiple Language March 25 2025 Update
2:33
Add Slicer to PivotTable & Chart To Enable Quick Analysis Excel Short Magic Trick 74
excelisfun
Add Slicer to PivotTable & Chart To Enable Quick Analysis Excel Short Magic Trick 74
1:00
Fast Keyboard to Create Excel PivotTable Excel Short Magic Trick 73
excelisfun
Fast Keyboard to Create Excel PivotTable Excel Short Magic Trick 73
1:15
Why Excel Table Feature is Amazing & How To Create Them: Excel #Short Magic Trick 72
excelisfun
Why Excel Table Feature is Amazing & How To Create Them: Excel #Short Magic Trick 72
1:50
MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!
excelisfun
MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!
35:54
PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879
excelisfun
PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879
1:22
Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878
excelisfun
Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878
2:35
Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71
excelisfun
Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71
0:46
Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70
excelisfun
Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70
2:23
Increase All Numbers by a Multiple of 10: Excel Paste Special Multiply Magic!! Short Excel Trick 69
excelisfun
Increase All Numbers by a Multiple of 10: Excel Paste Special Multiply Magic!! Short Excel Trick 69
0:42
Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68
excelisfun
Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68
2:30
PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877
excelisfun
PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877
2:21
Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876
excelisfun
Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876
2:33
No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875
excelisfun
No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875
4:42
FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874
excelisfun
FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874
3:24
LET Function to Define LAMBDA as f, then Perform Column Iteration With Vertical Spill. #Short 67
excelisfun
LET Function to Define LAMBDA as f, then Perform Column Iteration With Vertical Spill. #Short 67
2:29
LET & BYCOL Functions to Spill Column Aggregate calculations Vertically. #Short 66
excelisfun
LET & BYCOL Functions to Spill Column Aggregate calculations Vertically. #Short 66
2:19
Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872
excelisfun
Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872
13:36
Spill Aggregate Totals with the AGGREAGATE Function. #Short 65
excelisfun
Spill Aggregate Totals with the AGGREAGATE Function. #Short 65
2:19
Spill Aggregate Totals with BYCOL Function (GEOMEAN too), Across Bottom of Table! #Short 64
excelisfun
Spill Aggregate Totals with BYCOL Function (GEOMEAN too), Across Bottom of Table! #Short 64
2:07
AI Doesn't Know This: Best Solution for Excel Table Running Count Error! #Short Excel Trick 63
excelisfun
AI Doesn't Know This: Best Solution for Excel Table Running Count Error! #Short Excel Trick 63
1:37
BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871
excelisfun
BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871
6:54
Excel's WRAPCOLS Array Function to Undo Table Into a Specified # of Columns. #Short Excel Trick #62
excelisfun
Excel's WRAPCOLS Array Function to Undo Table Into a Specified # of Columns. #Short Excel Trick #62
0:47
Add Secondary Series of Numbers To Excel Chart & Add Second X-Axis Labels to Chart: EMT 1873
excelisfun
Add Secondary Series of Numbers To Excel Chart & Add Second X-Axis Labels to Chart: EMT 1873
3:01
GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870
excelisfun
GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870
5:45
No More VBA! Amazing WRAPROWS Function Converts Column of Records to Table. #Short Excel Trick 61
excelisfun
No More VBA! Amazing WRAPROWS Function Converts Column of Records to Table. #Short Excel Trick 61
1:36
Best Formula for % Change (Daily Stock Returns). #Short Excel Trick 60
excelisfun
Best Formula for % Change (Daily Stock Returns). #Short Excel Trick 60
1:09
Stock Portfolio Expected Return & Beta with single cell array formula. Bonus Trick Too! #Short 59
excelisfun
Stock Portfolio Expected Return & Beta with single cell array formula. Bonus Trick Too! #Short 59
1:39
Expected Return & Standard Deviation 4 Portfolio of Stocks Single Cell Excel Array Formula #Short 58
excelisfun
Expected Return & Standard Deviation 4 Portfolio of Stocks Single Cell Excel Array Formula #Short 58
2:10
Expected Return & Standard Deviation for 2 Stocks: Single Cell Excel Spilled Array Formula #Short 57
excelisfun
Expected Return & Standard Deviation for 2 Stocks: Single Cell Excel Spilled Array Formula #Short 57
2:28
excelisfun YouTube Channel is 17 Years Old!!!!!!!
excelisfun
excelisfun YouTube Channel is 17 Years Old!!!!!!!
0:35
Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56
excelisfun
Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56
1:53
Excel's Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55
excelisfun
Excel's Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55
2:10
Dynamic PivotTable To Count SalesRep Monthly Sales & Visualize Trend. Excel Magic Trick 1869
excelisfun
Dynamic PivotTable To Count SalesRep Monthly Sales & Visualize Trend. Excel Magic Trick 1869
7:49
Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54. ACCTG 455 #68.4
excelisfun
Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54. ACCTG 455 #68.4
2:30
Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53. ACCTG 455 #68.3
excelisfun
Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53. ACCTG 455 #68.3
1:27
Net Present Value: Do We Buy Asset? PV or NPV Function? #Short 52. ACCTG 455 #68.2
excelisfun
Net Present Value: Do We Buy Asset? PV or NPV Function? #Short 52. ACCTG 455 #68.2
2:20
Build Text Formula for Dynamic Label For Financial Model. #Short 51. ACCTG 455 #68.1
excelisfun
Build Text Formula for Dynamic Label For Financial Model. #Short 51. ACCTG 455 #68.1
1:41
Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50. ACCTG 455 #63.2
excelisfun
Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50. ACCTG 455 #63.2
1:56
Visualize How Stock Values Changes as Dividend Growth Rate Changes. #Short 49. ACCTG 455 #63.1
excelisfun
Visualize How Stock Values Changes as Dividend Growth Rate Changes. #Short 49. ACCTG 455 #63.1
1:11
Bond Rate Risk: Lower Coupon Rate, The More YTM Affects Bond Price. #Short 48. ACCTG 455 #54.2
excelisfun
Bond Rate Risk: Lower Coupon Rate, The More YTM Affects Bond Price. #Short 48. ACCTG 455 #54.2
1:45
Excelisfun Needs Your Help in Solving A Formula Number Formatting Mystery. #Short 52 Part 02
excelisfun
Excelisfun Needs Your Help in Solving A Formula Number Formatting Mystery. #Short 52 Part 02
0:43
Bond Rate Risk: Longer Maturity, More YTM Affects Bond Price. #Short 47. ACCTG 455 #54.1
excelisfun
Bond Rate Risk: Longer Maturity, More YTM Affects Bond Price. #Short 47. ACCTG 455 #54.1
2:05
Visualize Inverse Relationship for Bond Price & YTM Rate. #Short Excel Trick 46. ACCTG 455 50.4
excelisfun
Visualize Inverse Relationship for Bond Price & YTM Rate. #Short Excel Trick 46. ACCTG 455 50.4
1:13
Spill Bond Valuation PV Function Formula Across YTM Rates. #Short Excel Trick 45. ACCTG 455 #50.3
excelisfun
Spill Bond Valuation PV Function Formula Across YTM Rates. #Short Excel Trick 45. ACCTG 455 #50.3
1:21
IFS Function for Bond Value "Par", "Discount", or "Premium". #Short Excel Trick 44. ACCTG 455 # 50.2
excelisfun
IFS Function for Bond Value "Par", "Discount", or "Premium". #Short Excel Trick 44. ACCTG 455 # 50.2
1:23
Conditional Formatting for Bond Sold at Discount or Premium. #Short Excel Trick 43. ACCTG 455 # 50.1
excelisfun
Conditional Formatting for Bond Sold at Discount or Premium. #Short Excel Trick 43. ACCTG 455 # 50.1
1:23
Deep Discount Loan Spilled Amortization Table (Treasury Bonds) . #Short Excel Trick 42. ACCTG 455.
excelisfun
Deep Discount Loan Spilled Amortization Table (Treasury Bonds) . #Short Excel Trick 42. ACCTG 455.
1:23
Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41. ACCTG 455.
excelisfun
Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41. ACCTG 455.
1:20
Excel Spilled Loan Amortization Table. #Short Excel Trick 40. ACCTG 455.
excelisfun
Excel Spilled Loan Amortization Table. #Short Excel Trick 40. ACCTG 455.
1:39
What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39
excelisfun
What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39
1:11
CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38
excelisfun
CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38
1:08
Excel Formulas: Arrow Keys or Mouse? Return on Assets & Return on Equity Show the Best! #Short ET 37
excelisfun
Excel Formulas: Arrow Keys or Mouse? Return on Assets & Return on Equity Show the Best! #Short ET 37
1:15
I Can’t See All of My Excel Worksheet Tabs!?!?! #Short Excel Trick 36
excelisfun
I Can’t See All of My Excel Worksheet Tabs!?!?! #Short Excel Trick 36
0:23
Subtle Excel Keyboard Awesomeness: Ctrl + Shift + Arrow, then, Shift + Arrow #Short Excel Trick 35
excelisfun
Subtle Excel Keyboard Awesomeness: Ctrl + Shift + Arrow, then, Shift + Arrow #Short Excel Trick 35
1:11
MS 365 Excel Basics #3.5: Spill Rectangle Range of Weekly Commission Paid Amounts: #Short EMT 34
excelisfun
MS 365 Excel Basics #3.5: Spill Rectangle Range of Weekly Commission Paid Amounts: #Short EMT 34
1:20
ACCTG 455: Excel Finance Class 19.75: DuPont ROE Analysis. EMT Short #33.
excelisfun
ACCTG 455: Excel Finance Class 19.75: DuPont ROE Analysis. EMT Short #33.
1:51
ACCTG 455: Excel Finance Class 19.5: Why DuPont ROE Analysis is So Clever!
excelisfun
ACCTG 455: Excel Finance Class 19.5: Why DuPont ROE Analysis is So Clever!
1:50
World’s Greatest Excel Keyboard Short Cut? It’s a Tie Between Two!!! #Short Excel Magic Trick 32
excelisfun
World’s Greatest Excel Keyboard Short Cut? It’s a Tie Between Two!!! #Short Excel Magic Trick 32
0:33
Warning About Excel SUM Function Keyboard Shortcut: Alt + = #Short Excel Magic Trick 31
excelisfun
Warning About Excel SUM Function Keyboard Shortcut: Alt + = #Short Excel Magic Trick 31
0:45
ACCTG 455 Excel Finance Class 15.75: Three Common Sized Balance Sheet: Single Formula #Short EMT 30
excelisfun
ACCTG 455 Excel Finance Class 15.75: Three Common Sized Balance Sheet: Single Formula #Short EMT 30
1:00
ACCTG 455, Excel Finance Class 13.5: Financial Statement Cash Flow Equation Algebra Hint for HW 19
excelisfun
ACCTG 455, Excel Finance Class 13.5: Financial Statement Cash Flow Equation Algebra Hint for HW 19
3:16
ACCTG 455 Excel Finance Class 15.5: Formula for Multiple Common Sized Income Statements #Short ET 29
excelisfun
ACCTG 455 Excel Finance Class 15.5: Formula for Multiple Common Sized Income Statements #Short ET 29
1:00
ACCTG 455 Excel Finance Class 14.5: Common Size Income Statement Spilled Array Formula #Short EMT 28
excelisfun
ACCTG 455 Excel Finance Class 14.5: Common Size Income Statement Spilled Array Formula #Short EMT 28
1:01
How To Make Your Worksheet Formula Solution Better!
excelisfun
How To Make Your Worksheet Formula Solution Better!
0:56
Slicer Not Working With Second PivotTable? Here Is The Easy Fix! #Short Excel Magic Trick 26
excelisfun
Slicer Not Working With Second PivotTable? Here Is The Easy Fix! #Short Excel Magic Trick 26
0:37
Create Excel PivotTable and Slicer is Less Than One Minute! #Short Excel Magic Trick 25
excelisfun
Create Excel PivotTable and Slicer is Less Than One Minute! #Short Excel Magic Trick 25
0:56
Spill SUM Functions ? BYROW & BYCOL to Spill Any Aggregate Function! #Short Excel Magic Trick 24
excelisfun
Spill SUM Functions ? BYROW & BYCOL to Spill Any Aggregate Function! #Short Excel Magic Trick 24
1:00
25 Formulas with a Single Keyboard Shortcut: Believe it! #Short Excel Magic Trick 23
excelisfun
25 Formulas with a Single Keyboard Shortcut: Believe it! #Short Excel Magic Trick 23
0:44
Excel Dynamic Range with TRIMRANGE Function #Short Excel Magic Trick 22
excelisfun
Excel Dynamic Range with TRIMRANGE Function #Short Excel Magic Trick 22
0:59
Excel Dynamic Range Reference Operator .:. Trim Range Reference. #Short Excel Magic Trick 21
excelisfun
Excel Dynamic Range Reference Operator .:. Trim Range Reference. #Short Excel Magic Trick 21
0:59