Hello Everyone! Welcome to the Group.
A group which tries to bring the latest news on Excel, interesting solutions using Excel, thoughts and ideas, tips and tricks and anything that revolved around Excel and Analytics using Excel.
Please feel free to actively contribute!
For something that’s not so catchy, this is an awfully innovative solution I found. Sometimes, what’s out there on Excel surprises you to the extent of making you feel like a noob every now and then. Most usually, data for modeling comes in the form of Monthly data, which needs to be converted to Weekly […]
The “Time” format is one of those least understood formats, at least used to be for me! Until, I had to work on it extensively for one of my projects.. And it’s actually not that complex.. :) Here’s a quick snapshot on how the Time format works - - The DATE & TIME is integrated […]
All the while it’s been Excel can do this, and Excel can do that. But what are its pitfalls? Where does it fail? What should we beware? Surprisingly, there’s a whole community that’s at this topic! And I only recently stumbled upon them. That while trying to learn the new software “R”. Here’s a link […]
Scatter plots are generally a nice tool to represent data, especially ones where we’d like to show a pattern of some kind. But what happens when we have a sub-pattern of data which we need to plot to understand the pattern in the scatterplot? Let’s take an example here. This is how the data looks […]
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Here’s an excerpt: 600 people reached the top of Mt. Everest in 2012. This blog got about 7,600 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 13 years to get […]