Hi All, When we think of the analysis of data into excel, what comes first in our mind? Yes! The correct answer is the Pivot table. However, we know that the pivot table has its own limitation and we know that, when we want to do the analysis of any data, we need to convert …
Unpivot Column Data Using Power Query Excel 2016 Read More »
Array function is one of the powerful formulas. Array formula can do multiple tasks and multiple calculations can replace multiple formulae in one cell. And guys, still approximately 80-90% of the people do not know, how to use this formula? And the reason because they scare to learn it. No doubt, Array function is a …
Hi, Sometimes, we need to get data from the webpage. What we do, we simply copy and paste it in excel however, most of the time, excel does weird data paste because the margin and alignment of the web page are different from excel. In Today’s blog-post we will get rid of this kind of …
How to Import Live Data from Web to Microsoft Excel Read More »
The people often say, “What’s in the Name”. we would learn the importance of the name in this article. Yes, In Excel we can define a name of the cell, range or in Formula. This is an incredible feature given by Microsoft in Excel however, a very few people know about it. In day to …
In this article, we would put lights on the most mysterious concern of all time in Excel The Offset Function. So, what Offset does in Excel? Basically, the OFFSET formula returns a reference to a range that is offset from a starting cell or a range of cells by a specified number of rows and …
Hi All, When we are copying or importing a database in our excel file, we are facing a big problem which is related to “Text Alignment”. Some texts are in vertical form, some texts are in horizontal form and they are not in justified form. Isn’t it? By default, Microsoft Excel aligns text to the …
In this blog post, we will learn the use of Solver. Excel solver belongs to a special set of commands referred to as what-if analysis tools. Its primary purpose is to use in various business and engineering tools. It is helpful when dealing with all kinds of optimization problems where you need to take the …
In our previous blog post, we have discussed Goal Seek. In Goal seek, we can define only one variable at a time, However, suppose if we have more than one variable then goal seek would not help us. If there is such a problem, then we use “Scenario Manager”. Scenario manager is a kind of …
The PPMT & IPMT function comes under the financial function group. We all know that the PMT (EMI) amount is consisting of two things one is the principal amount, and another is an interest amount. In our previous blog post we have learned how can we calculate the EMI in Excel? However, if we want …
PMT function is one of the function of the Financial Function in Excel. This function helps us to calculate the amount payable on a monthly basis. It is also known as an EMI calculator. When we have a Loan Amount, Number of payments and annual interest rate then easily we can calculate the payable EMI …