Square and Square Root of a Number in Excel

Calculate the Square of a Number The following are 3 different formulas to calculate the Square of the number in the cell B3 Formula 1 =B3*B3 Formula 2 =POWER(B3,2) Formula 3 =B3^2 Calculate the Square Root of a Number The following are 3 different formulas to calculate the Square Root of the number in the…

Connect Google Sheets to Excel

In this blog post, I will explain the step by step procedure to Connect Google Sheets with Excel using Power Query. Once a spreadsheet in Google Sheets is connected with an Excel file, the changes made in the Source (Google Sheet) will be reflected in the Excel file at the expense of a single mouse…

Passing a Parameter in Power Query

When we transform data using Power Query, every Transformation Step is recorded as an M Code. And most of the time, values got hard coded in these codes. The problem with Hard coding is, when the user decides to change the input data, the Source code (Query in this case) also should be modified accordingly.…

Change Letter Case using Power Query

Like the UPPER, LOWER and PROPER functions we can also use Power Query to convert letters cases. Following is a list of names/words that are written with a combination of upper and lower case letters. To convert these words into UPPER, LOWER or PROPER cases using Power Query, Select a cell in the data set…

Add an Index Column using Power Query

In this blog post, I am explaining an easy method to add a new column to a data set which contains Automatically updating Serial Numbers. Following is the data set to which I want to add a new column of Serial Numbers. To add a column of Automatically Updating Serial Numbers to this data, Select…

Remove Duplicates using Power Query in Excel

Like the Remove Duplicates feature in Excel, Power Query also can be used to remove duplicates from a data set. But, why should we use Power Query to get rid of the Duplicates? Here is why . . . Following is a sample sales data containing duplicate records (The records with arrows against them). Now,…