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 : )
Функция ФИЛЬТР. Логическая проверка становится проще благодаря функциям BYROW и AND! Волшебный тр...
Удивительная функция BYROW в функции FILTER упрощает динамическую фильтрацию с помощью логическог...
Потрясающий трюк с функцией GROUPBY в отчётах с использованием BYROW и LAMBDA eta AND. Волшебный ...
Список проверки магических данных с использованием динамического эталонного диапазона или операто...
Формула Excel создаёт уникальный список со значением «ALL» наверху! Функции массива VSTACK, UNIQU...
The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908
Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907
Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906
Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905
Excel TEXTSPLIT function to Split Values By Delimiter & More! Excel Magic Trick 1904
Turn Off Excel Copilot Pop-up Button in Worksheet. Excel Magic Trick 1903
Dad & Son Skateboard & BMX West Coast Tour: 20 stops in 9 days
Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902
COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901
PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900
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