44 тысяч подписчиков
323 видео
XLOOKUP Partial Match with Numbers | the Multiply by 1 Trick | Getting Good with Excel Takes Time
Splitting Multiple Columns in Power Query | Battling null values and line-feeds
FFF: Powery Query (Get and Transform) - Shifting a column up by a single cell
Sum variable and custom ranges with XLOOKUP: the Victor Momoh Edition
Using RANDARRAY for a Random Data Generator in Excel: Random Names
Event Planning, Budgeting and Organizing a Guest List with Excel
Excel COUNTIFS function with OR Criteria
Extract a column of data from a Power Query table
Generating Random Data to Set Up a Pivot Table Tutorial
VLOOKUP Approximate Match in Power Query: Binning & Column by Example
Power Query: Combine rows into a single cell with Text.Combine
How to Stack Columns of Data in Excel: Formula Method, Power Query Method
Practical use for Excel's EXPAND function | VSTACK mystery solved | Dynamic Arrays
Adding Line-Breaks in an Excel Cell: Using CHAR and SUBSTITUTE
New Excel Feature: Insert Images into Cells (With Warnings)
Excel Dynamic Arrays: 6 Examples of FILTER with Multiple Criteria
Import from a Specific Folder with Power Query ... and that Formula.Firewall Error
The VSTACK Function | Dynamic Arrays | Stacking variable data into a single array
TEXTBEFORE function | Splitting names from professional designations
Power Query: Stacking Columns of Data (Unpivot, Split Columns by delimiter, and everything!)
Power Query: Sorting & Merging and ignoring Case-Sensitivity | Excel Days in Bulgaria | My Roadtrip
Excel Expert Live Challenge | Celia Alves & The Cupcake Challenge
Create Variable Columns in Power Query - Goodly Challenge - The First Class Edition
Retrieve the Adjacent Value from a Grid with XLOOKUP & Dynamic Arrays
Excel Campus License Plate Challenge: Odd vs. Even Days & License Plates
Creating a Dynamic Hyperlink in Excel
Excel Expert Challenge with Wyn Hopkins of
Power Query: Split Column by Delimiter and Split into Rows
Custom Sorting in Excel: sorting your data by season and by zodiac symbol
Power Query Challenge: Split by Multiple Delimiters | Merge All Columns
Excel Experts Live Challenge: Diarmuid Early vs. The Jumbled Course Completions
DataRails and The Functionary: Excel Top 5 Wall of Shame
Excel Campus License Plate Challenge: The Down & Dirty Edition
Excel Expert Live Challenge with Bill Jelen: Reception Party Guests
Excel Expert Live Challenge - Helen Wall - Shifts & Overtime
New in Excel: Get Data from Image | Excel vs. OneNote
Victor Momoh takes the Excel Expert Live Challenge | Calculating Clopen Earnings
Test Your PowerQuery Instinct With This 5 Question Quiz
ExcelHash 2021 Bill "Mr. Excel" Jelen and Oz du Soleil discuss all 17 solutions
Power Query: Split columns between digits and non-digits
Identify 2 partial strings of data in 1 cell | Text.Contains | Cross Join | Power Query
Power Query: Handling Percentages & Percent Totals
Extract Bold Font from a String of Text in a Cell - Baffmasta Edition
FunkyFunktionFriday: Part 2/3: PowerQuery, IF Statements & Custom Columns
Excel Power Query: Import Data from Web Page and Clear Line-Breaks
Excel Dynamic Arrays: 4 Complex Filter Examples
Connect Power Query to a Dynamic Dropdown List
Excel Discussion: The hard way or the concise way?
The Madness of How to Make Running Totals in Power Query
Power Query Drill Down, Query Dependencies and Formulas
Complex Excel IF Formula Simplified to a 2-Way Lookup with INDEX-MATCH-MATCH
