Using SUMPRODUCT() To Validate Multiple Criteria In Columns
We have studied and used SUMIFS() and SUMPRODUCTS() function with their appropriates use. Just to recall, SUMIFS() work great when our data is in the shape of list or is in column.
Can You Convert A Number Present As String To A Proper Number?
There are times when you bring data from other software to excel sheets and find that some of the numbers are formatted as text
.png "Getting Data From A Pivot Table – Using Getpivotdata()")
Getting Data From A Pivot Table – Using Getpivotdata()
If you have a large pivot and want to create a report based on that pivot, it is time to revert to a function dedicated for it – GETPIVOTDATA().
Plotting Trajectory Of Projectile
Have you ever thrown a pebble in water? You must have in your childhood! The pebble follows not a straight line but a parabolic path.
Understanding Optimization With Excel 2010
In real life, resources are scarce and wants are unlimited. This fact leads us to optimize our resources to get best out of available resources
Developing And X And R Chart For Quality Control
We do create different type of charts to fulfill our charting needs – quite a few of them are related to quality control purposes.
Finding An Equation That Fits Your Data…
Whenever we have data, we are interested in getting some meaningful insights from it.
Total Count : 192
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
