Blog

Formula Errors in Excel

If you are a person who use Excel a lot, you might have encountered with these Error Codes like #DIV/0!, #NAME?, #N/A, etc. Each of these error codes tell us something. It gives us information on how to troubleshoot an incorrect formula. Following are the most common Error codes in Excel and I will explain…

Import Text from Excel to AutoCAD

In this blog post, I will explain about an ‘Excel formula’ that can be used to ‘Import Text from Excel to AutoCAD’. Suppose you have some data like the following that needs to be inserted into AutoCAD. The texts to be inserted into AutoCAD are in the column C and the X,Y Co-ordinates of the…

STOCKHISTORY Function (Beta) in Excel

In the second week of June 2020, Microsoft introduced a new Excel Function called STOCKHISTORY, with which we can pull the Historical data of Stocks Prices and Currency exchange rates into an Excel worksheet. Note: At present, STOCKHISTORY function is available only to the 50% of Microsoft 365 Subscribers in the Beta level of the Office…

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…