Канал: Short Excel

How to Count Cells that Contain Formulas in Excel

How to Count Cells that Contain Formulas in Excel

How to Find the Last Number or Text Value in Excel

How to Find the Last Number or Text Value in Excel

How to Sort Comma-Separated Values in a Single Cell in Google Sheets

How to Sort Comma-Separated Values in a Single Cell in Google Sheets

How to create a drop-down list in Excel

How to create a drop-down list in Excel

Fill Blank Cells in Excel

Fill Blank Cells in Excel

How to Find Case Sensitive Unique Values in Excel

How to Find Case Sensitive Unique Values in Excel

How to Extract the Maximum Number from a String Using Excel

How to Extract the Maximum Number from a String Using Excel

How to Find the Maximum Number Ignoring Signs in Excel

How to Find the Maximum Number Ignoring Signs in Excel

Excel's New TRIMRANGE Function

Excel's New TRIMRANGE Function

Create Date Range From Two Dates in Excel

Create Date Range From Two Dates in Excel

How to Perform Two Way Lookup in Excel

How to Perform Two Way Lookup in Excel

How to Calculate Group Totals in Excel

How to Calculate Group Totals in Excel

How to Separate Names and Job Titles in Excel

How to Separate Names and Job Titles in Excel

How to Highlight Odd and Even Number in Excel

How to Highlight Odd and Even Number in Excel

How to Sum the First n Rows

How to Sum the First n Rows

How To Remove Middle Name in Excel

How To Remove Middle Name in Excel

How to Convert Hours to Minutes in Excel

How to Convert Hours to Minutes in Excel

Removing Specific Text from Product Names Using Power Query

Removing Specific Text from Product Names Using Power Query

How to Count Unique Values in Excel

How to Count Unique Values in Excel

New Focus Cell in Excel

New Focus Cell in Excel

How to Sort Comma-Separated Values in a Single Excel Cell

How to Sort Comma-Separated Values in a Single Excel Cell

How to Calculate Average Salary by Department in Excel

How to Calculate Average Salary by Department in Excel

How to Convert Roman Numeral to Arabic Numeral In Excel

How to Convert Roman Numeral to Arabic Numeral In Excel

How to Convert Arabic Numeral to Roman Numeral In Excel

How to Convert Arabic Numeral to Roman Numeral In Excel

How to Use FLOOR MATH Function in Excel

How to Use FLOOR MATH Function in Excel

Separate Text and Numbers in Excel

Separate Text and Numbers in Excel

How to Use CLEAN Function in Excel

How to Use CLEAN Function in Excel

How to Mark Only the Last Item as 'Yes' in Grouped Data with Power Query

How to Mark Only the Last Item as 'Yes' in Grouped Data with Power Query

How to Capitalize the First Letter of Each Word in Excel

How to Capitalize the First Letter of Each Word in Excel

How to Combine Multiple Columns into One Unique List

How to Combine Multiple Columns into One Unique List

How to Separate Text and Numbers in Excel

How to Separate Text and Numbers in Excel

How to Combine Unique Values by Category in Power Query

How to Combine Unique Values by Category in Power Query

How to Combine Unique Values by Category in Excel

How to Combine Unique Values by Category in Excel

How to Convert Text to Uppercase

How to Convert Text to Uppercase

How to Convert Text to Lowercase

How to Convert Text to Lowercase

How to Filter Non-Fibonacci Numbers Using Excel

How to Filter Non-Fibonacci Numbers Using Excel

How to Pivot Sales Data by Category and Year

How to Pivot Sales Data by Category and Year

How to Convert Stacked Data to Tabular Format in Power Query

How to Convert Stacked Data to Tabular Format in Power Query

How to Use SUBSTITUTE Function in Excel

How to Use SUBSTITUTE Function in Excel

How to Transform Data into a Day-of-Week Matrix in Power Query

How to Transform Data into a Day-of-Week Matrix in Power Query

How to Convert YYYYMMDD Text Dates to Recognizable Dates in Excel

How to Convert YYYYMMDD Text Dates to Recognizable Dates in Excel

Adding Missing Closing Brackets in Excel

Adding Missing Closing Brackets in Excel

New Translation Functions in Excel : TRANSLATE and DETECTLANGUAGE

New Translation Functions in Excel : TRANSLATE and DETECTLANGUAGE

How to use AutoSum in Excel

How to use AutoSum in Excel

How to Consolidate Employee Information Using Power Query

How to Consolidate Employee Information Using Power Query

How to Count People with Missing Middle Names in Excel

How to Count People with Missing Middle Names in Excel

How to Summarize Monthly Data by Department in Power Query

How to Summarize Monthly Data by Department in Power Query

How to Convert Between Celsius (°C) and Kelvin (K) Temperatures in Excel

How to Convert Between Celsius (°C) and Kelvin (K) Temperatures in Excel

How to Check if a Cell Contains Numbers in Excel

How to Check if a Cell Contains Numbers in Excel

How to use FIND/SEARCH function in Excel

How to use FIND/SEARCH function in Excel

How to Use the Power Query Null Coalescing Operator

How to Use the Power Query Null Coalescing Operator

How to use LEN Function in Excel

How to use LEN Function in Excel

How to use RIGHT function in Excel

How to use RIGHT function in Excel

Text.Middle vs Text.Range

Text.Middle vs Text.Range

How to use the MID function in Excel

How to use the MID function in Excel

How to use LEFT function in Excel

How to use LEFT function in Excel

How To Remove Non Numeric Characters From Cells In Excel

How To Remove Non Numeric Characters From Cells In Excel

How to Use VSTACK Function in Excel

How to Use VSTACK Function in Excel

How to Transform Grouped Number Intervals into Detailed Lists in Power Query

How to Transform Grouped Number Intervals into Detailed Lists in Power Query

How to Transform Grouped Number Intervals into Detailed Lists in Excel

How to Transform Grouped Number Intervals into Detailed Lists in Excel

How to Group Consecutive Numbers in Excel with VBA

How to Group Consecutive Numbers in Excel with VBA

How to Select Every nth Row in Excel

How to Select Every nth Row in Excel

How to Separate Data into Multiple Columns Using Delimiters in Excel

How to Separate Data into Multiple Columns Using Delimiters in Excel

How to Extract and Join Text Between Brackets in Excel

How to Extract and Join Text Between Brackets in Excel

How to Create Fibonacci Sequence in Excel

How to Create Fibonacci Sequence in Excel

How to Calculate the Sum of Numbers in Mixed Strings in Excel

How to Calculate the Sum of Numbers in Mixed Strings in Excel

How to Use Trunc Function In Excel

How to Use Trunc Function In Excel

How to Use Int Function In Excel

How to Use Int Function In Excel

Using Power Query to Count Digits 0 to 9 in Excel

Using Power Query to Count Digits 0 to 9 in Excel

How to Check for Palindromes in Excel

How to Check for Palindromes in Excel

How to repeat values N times in excel

How to repeat values N times in excel

How to Simplify Complex Tables with Power Query by Unpivoting and Grouping

How to Simplify Complex Tables with Power Query by Unpivoting and Grouping

How to Fill Blanks and Sum Revenue Using Power Query

How to Fill Blanks and Sum Revenue Using Power Query

How to Group Clients by Unique Groups

How to Group Clients by Unique Groups

How to Use SECOND Function in Excel

How to Use SECOND Function in Excel

How to use Minute function in Excel

How to use Minute function in Excel

INDEX MATCH with Multiple Criteria

INDEX MATCH with Multiple Criteria

Excel's New PIVOTBY Function

Excel's New PIVOTBY Function

How to Use HOUR Function in Excel

How to Use HOUR Function in Excel

How to Use DAY Function in Excel

How to Use DAY Function in Excel

How to Use MONTH Function in Excel

How to Use MONTH Function in Excel

How to Use YEAR Function in Excel

How to Use YEAR Function in Excel

Excel's New GROUPBY Function

Excel's New GROUPBY Function

How to Sort and Merge Delimited Text Strings in Power Query

How to Sort and Merge Delimited Text Strings in Power Query

How to Reverse Text String in Excel

How to Reverse Text String in Excel

How to Sum Positive Numbers in Excel

How to Sum Positive Numbers in Excel

How to Group and Transpose Data in Excel using Power Query

How to Group and Transpose Data in Excel using Power Query

Calculate running total

Calculate running total

How to Sum Numbers in a String

How to Sum Numbers in a String

How to Transform and Extract Data in Excel Using Power Query

How to Transform and Extract Data in Excel Using Power Query

How to Split Characters and Numbers in Strings

How to Split Characters and Numbers in Strings

How to obtain the results of the input data replicated n times

How to obtain the results of the input data replicated n times

How to Filter Odd or Even Numbers in Excel

How to Filter Odd or Even Numbers in Excel

Python in Excel - Finding the Maximum Numeric Value in Mixed Strings

Python in Excel - Finding the Maximum Numeric Value in Mixed Strings

Finding the Maximum Numeric Value in Mixed Strings in Power Query

Finding the Maximum Numeric Value in Mixed Strings in Power Query

Finding the Maximum Numeric Value in Mixed Strings

Finding the Maximum Numeric Value in Mixed Strings

How to Use VLOOKUP to Reference Different Tables Based on Conditions

How to Use VLOOKUP to Reference Different Tables Based on Conditions

How to Isolate Numbers in a Text String

How to Isolate Numbers in a Text String

How to Automatically Add a Comma Before Spaces#shorts

How to Automatically Add a Comma Before Spaces#shorts

Using Power Query M code to Combine Rows Based on Common ID in Excel

Using Power Query M code to Combine Rows Based on Common ID in Excel

How to Repeat Product Names Based on Quantity in Excel#shorts

How to Repeat Product Names Based on Quantity in Excel#shorts

How to Find Missing Numbers in Excel Using Power Query

How to Find Missing Numbers in Excel Using Power Query

How to Find Missing Numbers in Excel

How to Find Missing Numbers in Excel

Perform a Case Sensitive Lookup in Excel

Perform a Case Sensitive Lookup in Excel

Python in Excel - How to Extract a Word at Any Position from a String

Python in Excel - How to Extract a Word at Any Position from a String

How to Extract a Word at Any Position from a String in Power Query

How to Extract a Word at Any Position from a String in Power Query

How to Filter Numbers by a Specific Number of Digits

How to Filter Numbers by a Specific Number of Digits

How to Compare the Most Recent and Penultimate Scores by Date for Each Group in Power Query

How to Compare the Most Recent and Penultimate Scores by Date for Each Group in Power Query

How to Combine and Sort Rows in Excel Based on Duplicate Values

How to Combine and Sort Rows in Excel Based on Duplicate Values

How to Remove Errors and Split Lists, then Compute Group Averages Using Power Query

How to Remove Errors and Split Lists, then Compute Group Averages Using Power Query

Using Power Query M to Evaluate Formulas in Excel

Using Power Query M to Evaluate Formulas in Excel

How to Get First Word and Last Word in Excel

How to Get First Word and Last Word in Excel

How to Convert a Multi-Column Range into a Single Column in Excel

How to Convert a Multi-Column Range into a Single Column in Excel

How to Convert a Table from Vertical to Horizontal

How to Convert a Table from Vertical to Horizontal

Selecting Top N or Bottom N Rows in Excel

Selecting Top N or Bottom N Rows in Excel

Filter data in Excel based on bold font

Filter data in Excel based on bold font

How to change only the year in a date using Power Query

How to change only the year in a date using Power Query

How to Change Only the Year in a Date

How to Change Only the Year in a Date

How to Extract First Letter of First Word in Excel Cells with PowerQuery

How to Extract First Letter of First Word in Excel Cells with PowerQuery

How to Extract First Letter of First Word in Excel Cells

How to Extract First Letter of First Word in Excel Cells

How to Extract Unique Values from Multiple Columns

How to Extract Unique Values from Multiple Columns

[PowerQuery] How to Remove Excluded Characters - 2

[PowerQuery] How to Remove Excluded Characters - 2

[PowerQuery] - How to Remove Excluded Characters - 1

[PowerQuery] - How to Remove Excluded Characters - 1

How to Remove Excluded Characters

How to Remove Excluded Characters

Counting Digits 0 to 9 in Excel

Counting Digits 0 to 9 in Excel

How to Extract Uppercase or Lowercase Letters from Mixed Case Text

How to Extract Uppercase or Lowercase Letters from Mixed Case Text

How to Extract Lowercase Letters from Mixed Case Text

How to Extract Lowercase Letters from Mixed Case Text

Prime Number Detection

Prime Number Detection

Using Regular Expressions in Power Query

Using Regular Expressions in Power Query

List All Sheets in an Excel Workbook

List All Sheets in an Excel Workbook

Using Power Query to Fetch and Transform MLB Team Season Data

Using Power Query to Fetch and Transform MLB Team Season Data

Convert Column Names to Uppercase or Capitalize First Letter in Power Query

Convert Column Names to Uppercase or Capitalize First Letter in Power Query

Split cells with line feed into rows with Power Query

Split cells with line feed into rows with Power Query

How to Remove Apostrophes from Excel Data

How to Remove Apostrophes from Excel Data

Creating a reverse index in Power Query

Creating a reverse index in Power Query

Extract unique fruits that appeared once in Power Query

Extract unique fruits that appeared once in Power Query

Ignoring Case and Removing Duplicates in Power Query

Ignoring Case and Removing Duplicates in Power Query

Get Product IDs Only When Product Name Starts with C, S, or Q

Get Product IDs Only When Product Name Starts with C, S, or Q

Replace negative numbers with zero in Power Query

Replace negative numbers with zero in Power Query

Find Missing Numbers In A Series - SEQUENCE,FILTER

Find Missing Numbers In A Series - SEQUENCE,FILTER

Power Query Tutorial - Checking Data Types with Value.Is Function

Power Query Tutorial - Checking Data Types with Value.Is Function

How to Combine Data from Multiple Cells in Excel using Textjoin Function

How to Combine Data from Multiple Cells in Excel using Textjoin Function

How to Calculate Sales Amount by Month using SUMPRODUCT

How to Calculate Sales Amount by Month using SUMPRODUCT

Summary of Customer Sales by Product and Total Sales

Summary of Customer Sales by Product and Total Sales

Removing Duplicate Purchases to Get Unique Product Lists

Removing Duplicate Purchases to Get Unique Product Lists

Filtering Data by ID List with Power Query in Excel

Filtering Data by ID List with Power Query in Excel

Sum of column by group as new column

Sum of column by group as new column

[PowerQuery] - Sum top n values

[PowerQuery] - Sum top n values

Sum top n values

Sum top n values

How to classify product types using Power Query in Excel

How to classify product types using Power Query in Excel

How to Use Power Query to Add a Custom Column for Product Types in Excel

How to Use Power Query to Add a Custom Column for Product Types in Excel

[PowerQuery] - Most frequently occurring text

[PowerQuery] - Most frequently occurring text

[OFFICE365] - Most frequently occurring text

[OFFICE365] - Most frequently occurring text

How to Calculate Year-to-Date (YTD) in Excel

How to Calculate Year-to-Date (YTD) in Excel

Advanced Data Filtering in Power Query - Filter only manufacturers with 3 or more categories

Advanced Data Filtering in Power Query - Filter only manufacturers with 3 or more categories

Handling Missing Fields in JSON Data

Handling Missing Fields in JSON Data

[Power Query] What is the difference between Text.Split and Text.SplitAny?

[Power Query] What is the difference between Text.Split and Text.SplitAny?

How to Add Custom Columns based on Maximum Dates in Power Query

How to Add Custom Columns based on Maximum Dates in Power Query

Creating Custom Columns with Dynamic Column Names in Power Query

Creating Custom Columns with Dynamic Column Names in Power Query

How to separate letters and numbers when letters and numbers are mixed without a separator

How to separate letters and numbers when letters and numbers are mixed without a separator

How to Select Specific Columns with Power Query

How to Select Specific Columns with Power Query

[PowerQuery] How to find common values in 3 columns in Excel

[PowerQuery] How to find common values in 3 columns in Excel

[Power Query] Replace Each x in a Matrix With Column Headers in PowerQuery

[Power Query] Replace Each x in a Matrix With Column Headers in PowerQuery

Get maximum of comma separated values in a cell

Get maximum of comma separated values in a cell

[Power Query] Group Data in Excel using Power Query

[Power Query] Group Data in Excel using Power Query

Value Preview Tooltips in Excel No More F9 & Ctrl + Z!!!!

Value Preview Tooltips in Excel No More F9 & Ctrl + Z!!!!

How to Remove Duplicates and Sort Characters in Excel

How to Remove Duplicates and Sort Characters in Excel

[Re-upload] PowerQuery - Convert Stacked Columns Report to Table Transpose

[Re-upload] PowerQuery - Convert Stacked Columns Report to Table Transpose

[OFFICE-365] Each Row Has 3 Records, Unwind Table into Proper Data Set - Formula

[OFFICE-365] Each Row Has 3 Records, Unwind Table into Proper Data Set - Formula

[Power Query] - Each Row Has 3 Records, Unwind Table into Proper Data Set - One Step

[Power Query] - Each Row Has 3 Records, Unwind Table into Proper Data Set - One Step

[Power Query] Each Row Has 3 Records, Unwind Table into Proper Data Set

[Power Query] Each Row Has 3 Records, Unwind Table into Proper Data Set

[OFFICE 365] How to remove duplicates in Excel cell

[OFFICE 365] How to remove duplicates in Excel cell

PowerQuery Create M code with ChatGPT

PowerQuery Create M code with ChatGPT

[OFFICE 365] Extract a unique distinct list and ignore blanks

[OFFICE 365] Extract a unique distinct list and ignore blanks

Cell to return first item in filtered column

Cell to return first item in filtered column

Cell to return first item in filtered column - help column

Cell to return first item in filtered column - help column

How to add subtotal in a row in Power Query

How to add subtotal in a row in Power Query

[Power Query] Create sum of Expanded Table Column (number) after NestedJoin

[Power Query] Create sum of Expanded Table Column (number) after NestedJoin

[Power Query] Combine data from 2 columns in a single table

[Power Query] Combine data from 2 columns in a single table

[Power Query] Find the row with the lowest value

[Power Query] Find the row with the lowest value

[Power Query] Find the row with the largest value

[Power Query] Find the row with the largest value

Sum text values like numbers

Sum text values like numbers

[Power Query] Pivot Columns - List.Split & Table.FromRows

[Power Query] Pivot Columns - List.Split & Table.FromRows

[Power Query] Combine only DISTINCT values

[Power Query] Combine only DISTINCT values

[Power Query] Find a column name

[Power Query] Find a column name

Counting cells that contain a specified count of characters

Counting cells that contain a specified count of characters

[Power Query] - How To Combine Multiple Rows Into One Based On Duplicates In Excel?

[Power Query] - How To Combine Multiple Rows Into One Based On Duplicates In Excel?

BYCOL Function

BYCOL Function

BYROW Function

BYROW Function

[Power Query] Error handling

[Power Query] Error handling

[Power Query] Cross join

[Power Query] Cross join

Remove All Empty Columns in Power Query

Remove All Empty Columns in Power Query

How to use EXACT function in Excel

How to use EXACT function in Excel

[Power Query] Grouping or summarizing rows

[Power Query] Grouping or summarizing rows

Sort comma separated values

Sort comma separated values

[Power Query] - Sort comma separated values

[Power Query] - Sort comma separated values

[Power Query] - Pivot Columns

[Power Query] - Pivot Columns

[Power Query] - Unpivot

[Power Query] - Unpivot

Extract mth word from text string

Extract mth word from text string

WEEKDAY Function

WEEKDAY Function