1 тысяч подписчиков
275 видео
How to Fill Blanks and Sum Revenue Using Power Query
Sort comma separated values
Ignoring Case and Removing Duplicates in Power Query
[PowerQuery] How to find common values in 3 columns in Excel
Creating Custom Columns with Dynamic Column Names in Power Query
How to Transform and Extract Data in Excel Using Power Query
Lambda Helper Function - MAKEARRAY
[Power Query] How To Transpose Every N Rows From One Column To Multiple Columns?
How to Filter Numbers by a Specific Number of Digits
How to Count People with Missing Middle Names in Excel
How to Transform Grouped Number Intervals into Detailed Lists in Excel
Python in Excel - Finding the Maximum Numeric Value in Mixed Strings
Lambda Helper Function : REDUCE
How to Group Consecutive Numbers in Excel with VBA
How to Isolate Numbers in a Text String
How to Transform Grouped Number Intervals into Detailed Lists in Power Query
How to Select Every nth Row in Excel
How to Convert YYYYMMDD Text Dates to Recognizable Dates in Excel
How to Filter Non-Fibonacci Numbers Using Excel
How to Reverse Text String in Excel
[Power Query] Date.DayOfWeek
How to Convert Arabic Numeral to Roman Numeral In Excel
How to Combine Multiple Columns into One Unique List
How to Use MONTH Function in Excel
How to Convert Between Celsius (°C) and Kelvin (K) Temperatures in Excel
How to Separate Data into Multiple Columns Using Delimiters in Excel
INDEX MATCH with Multiple Criteria
How to Find Missing Numbers in Excel Using Power Query
How to use AutoSum in Excel
Using Power Query to Count Digits 0 to 9 in Excel
How to Consolidate Employee Information Using Power Query
How to Transform Data into a Day-of-Week Matrix in Power Query
How to Check for Palindromes in Excel
How to Separate Text and Numbers in Excel
Separate Text and Numbers in Excel
How to Get First Word and Last Word in Excel
New Translation Functions in Excel : TRANSLATE and DETECTLANGUAGE
How to Combine and Sort Rows in Excel Based on Duplicate Values
How to Extract and Join Text Between Brackets in Excel
How To Remove Non Numeric Characters From Cells In Excel
How to Calculate the Sum of Numbers in Mixed Strings in Excel
Sum of column by group as new column
How to Mark Only the Last Item as 'Yes' in Grouped Data with Power Query
How to Use the TRUNC Function in Excel
How to Extract Unique Values from Multiple Columns
Sum top n values
Summary of Customer Sales by Product and Total Sales
Using Regular Expressions in Power Query
[Power Query] - Sort comma separated values
How to Use COUNTIF Function to Count Cells Not Equal to Multiple Criteria | Excel Tutorial