Ask Analytics: Magic of Excel

Showing posts with label Magic of Excel. Show all posts

Time Series Forecasting - Part 2

Single Exponential Smoothing - Excel : SAS : R

In the previous article of this series, we described basics about the time series and also enlisted the methods that can used for time series forecasting.
Let's now learn the methods one by one in details.

Auto Execution in Excel with Zero Manual Intervention

WINTER is coming !

Age of Automation is here to save you from all the Manual Work, after all winter is not meant to work. You worked enough in summers, but now it's time to hibernate.

Let's be part of this Rest Revolution, and witness the perks of it.

Fun with Colours in Excel

Ever played around with colors in excel?

You might feel the weirdness in it, but why not give it a try when you have a chance to do so.

Play, Fill, Pattern around the space using Colors from the Palette !!!

The key reason behind writing this blog is to provide a practical example of using Relative Referencing in Excel VBA. However the blog covers many other things as well, not just the Relative Referencing concept .

VLOOKUP with approximate Match option - An application

For more than 10 years I had been using VLOOKUP function of excel extensively in my day to day job. I had designed so many Excel dashboard with blend of VLOOKUP, form control and other function such as match (), column() within. However, the child curiosity, still alive within me, was still not satiated as I used to wonder about the utility of last argument options : TRUE (Approximate Match) and FALSE (Exact Match). All these years, I used to write "0" for using FALSE (Exact Match) option.

Today (20th Oct 2015), is my Excel Christmas Day, when my long pending wish is fulfilled, as Santa has left behind a chance for me to use VLOOKUP with "1". Sharing the awesomstic feeling with you.

Fun with Beer and of course Excel

Ever got High over the Beer 'n' Excel punch??

It’s been long, may be since our school days, that we all are using Excel as a Tool. But have you ever wondered what all super cool stuffs can be done using this commonly available Tool? It’s just as simple as you’re thinking, may be a little tricky but at the end, it’s all fun and bliss!!

What's that heading? Why are we mixing beer and excel ? Cocktail party ...?

Radar chart on my radar

Try Radar Chart ... It is Awesome

Last night in my dreams, Radar chart knocked at my subconscious mind ... it was crying like hell. I asked the reason, it said, "All other Charts e.g. Line, Bar and Pie have become superstars like Khans of Bollywood but I am left behind like Ashmit Patel".

I said, "You are last in the charts' list in Excel, it is making you most neglected one. Also you looks like a Cobweb and are quite scary, where can we use you." But being too warm-hearted, I promised it a break. I tried to find out its utility and now I feel that it is really worth using ... n ... I was missing something, not using it so far. Would you like to know about it ?