Excel Tips and Tutorials

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.

Finding An Equation That Fits Your Data…

Whenever we have data, we are interested in getting some meaningful insights from it.

Using Moving Averages For Forecasting

Sales people often need to estimate the sales of upcoming months. They do it with a handful of techniques that uses both quantitative analysis as well as qualitative judgment.

Total Count  : 191