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