M language in power query

Getting Started with M Language in Power Query

Power Query, a powerful data transformation tool embedded in Microsoft Excel and other Microsoft products, utilizes a specialized language known…

IF Statements in Power Query

IF Statements in Power Query [3 Examples]

In Power Query, the IF statement is a conditional logic tool that allows you to make decisions based on specified…

INDEX and MATCH functions to match two columns & output third

How to Match Two Columns in Excel and Output a Third Column

To find a match between two columns in Excel and output a third column,  follow the steps below: Select cell…

Vlookup Partial Matches and Return Multiple Values in Excel Using IF, ISNUMBER, & SEARCH Functions

Vlookup Partial Matches and Return Multiple Values [5 Ways]

To vlookup partial matches and return multiple values, you can follow the steps below: Select cell C2. Type this formula:=FILTER($A$2:$A$11,…

Compare Three Columns to Find Matches in Excel Using IF & AND Functions

6 Ways to Compare Three Columns to Find Matches in Excel

To compare three columns to find matches in Excel: Select cell D2. Type the formula: =IF(AND(A2=B2,B2=C2),”Common”,”Not Common”) Press ENTER to…

Find Partial Match in Two Columns in Excel

4 Ways to Find Partial Match in Two Columns in Excel

To find a partial match in two columns in Excel, follow the steps below: Select cell D2. Type the formula:…

Accessed built-in Custom Sort option to customize sort in Pivot Table

How to Custom Sort in Excel Pivot Table [2 Methods]

Custom Sort is a feature in Excel that allows users to arrange data in a specific order based on their…

Options to Sort by value in Excel Pivot Table

Sort by Value in Pivot Table in Excel [3 Methods]

To sort by value in the Pivot Table in Excel, go through the instructions below: Click on a cell containing…

15 Important Features of Power Query in Excel

15 Important Features of Power Query in Excel

Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide…

Uncheck autofit in Pivot Table to lock Pivot Table column width

3 Methods to Lock Pivot Table Column Width in Excel

To lock the Pivot Table column width, follow the steps: Select any cell within the Pivot Table. Navigate to the…