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 …
Data Table Hi Guys, We hope that you are enjoying our blog posts. Please share it with colleagues & friends in case you find them useful. A data table is a range that calculates changing variables based on a single formula. The data table is one of “what if analysis” features (Do not compare this …
Heat Map Chart through Radio Button in Excel- If we wish to highlight Top and bottom values in excel along with colour, rather than finding it manually, simply we will use conditional formatting. Today we will discuss a different way to highlight Top & Bottom values with radio button along with colours. Are you Excited! …
According to Investopedia, “a Histogram is a graphical representation, similar to a bar chart in structure, that organizes a group of data points into user-specified ranges. The histogram condenses a data series into an easily interpreted visual by taking many data points and grouping them into logical ranges or bins”. In other words, Histogram is a type of …