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,
57 total views, 27 views today
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
102 total views, no views today
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
51 total views, no views today
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
84 total views, no views today
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
75 total views, no views today
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
111 total views, no views today
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
117 total views, no views today
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
108 total views, no views today
Pareto charts are extremely useful for analyzing what problem needs attention first, the taller bars on the chart, which represent frequency and the line shows the cumulative frequency percentage.
The Pareto principle (also known as the 80/20 rule), states that,
114 total views, no views today
141 total views, no views today
141 total views, no views today