Excel Tips and Tutorials

Producing Panel Charts In Excel

Data bars are amongst one of the many feature excel has for presenting data.

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

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.

Total Count  : 179