excelisfun
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 running an award-winning boomerang manufacturing company (Gel Boomerangs) with sports boomerang sales all over the world. Here at my excelisfun YouTube Channel, I provide free education for the world, with over 3,700 videos, over 100 playlists free classes, over 10,000 downloadable Excel example files, and over 2,000 free pdf notes files. Data analysis, accounting, finance and statistics are my specialty. Hopefully these free Excel & Power BI resources will help you to become better with Excel, Power BI and data analysis so you can save time at work, help coworkers become better, and save so much time that you can take an extra vacation! This is all free, so pass the word along to all who you know: excelisfun is here to help!
Go Team!
P.S. if you want to Donate, use PayPal link below, or join my YouTube channel : )
Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899
Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898
Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897
Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896
Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895.
Create Random Dates with Excel Functions. Excel Magic Trick 1894
XLOOKUP, LEFT, TEXTBEFORE, & LOOKUP Functions & Math Tricks to Calculate Discounted Sales! EMT 1893
Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892
3 Months of Seattle Skatepark Clips in 3 Minutes. excelisfun & Son Skateboard and BMX Action.
Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887
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
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!
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
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.
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?