Cart

Blog

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

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

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,

Hi Guys, We hope that you are enjoying our blog posts. Please share it with colleagues & friends in case you find them useful. “What if analysis” is one of the most powerful tools. In general terms, “what if analysis

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

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

Microsoft Excel has lots of predefined charts to visualize the data like Column, Pie, Line etc. In the new version of Ms-office i.e. 2016 or 365, six new charts have been introduced by Microsoft. In this blog post, we are

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

The requirement of counting is almost always present in our day to day job and Excel made it really easy for us by giving a number of counting functions like Count, CountA, CountBlank, CountIf and CountIfs. Let’s understand them in

Power Query is an amazing tool to import data from almost any popular or semi-popular data source in Excel. One can import any database, which can be in any format like .txt, CSV, JSON, Access etc. or from any database