## 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…

## Combine Data from Multiple Worksheets (Tables) using Power Query

In the previous post, I have explained How to Combine Data from Multiple Worksheets of an Excel Workbook. That was a crude method of static nature and won’t be the right choice, when you have plans to Add or Delete worksheets. The method explained here is recommended for those who want to Combine data from…

## Combine Multiple Worksheets of a Workbook using Power Query in Excel

In this blog post, I am explaining the Power Query Method to combine data from multiple worksheets. If you are a person who deals with data in Multiple Worksheets, You should definitely try this one. Following is the screenshot a workbook which contains 7 worksheets called Violet, Indigo, Green, Blue, Orange, Yellow and Red. These…

## Remove or Extract Special Characters from a data set using Power Query

In this article, I will explain an easy method to Extract or Remove Special Characters, Alphabets or Numerals from a data set using Power Query in Excel. Following is the data set from which I want to remove the special characters like ‘!’, ‘@’, ‘#’, ‘\$’, ‘%’, ‘&’, ‘*’, ‘(‘ etc. To clean this data,…

## Find the Most Repeated Word in a data set using Power Query

MODE function in Excel will return the most frequently occurring number in a data set. But for finding the most frequently occurring text string in a data set, we don’t have an Excel function for that. In this article, I will show you how to find the most repeated word in a data set using…