Subscribe to Dr. Granville's Weekly Digest

Excel Analytics


Excel Analytics

Excel and Analytics have never quite gone hand in hand, but the truth is, both can definitely be the best partners! Personally I haven't seen many places where Excel & Analytics co-exist in harmony. But here, IT WILL!!!

Members: 133
Latest Activity: Aug 27

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!

Discussion Forum

Excel Add-INs 5 Replies

Started by Arun. Last reply by Mark Johnson May 15, 2011.

Data Mining tools in Excel

Started by Angshuman Saha Feb 7, 2011.

Node XL - a great free Excel add-in

Started by Eckhardt Kriel Jun 1, 2010.

Excel Security using XML Conversion

Started by Arun Apr 1, 2010.

Discriminant Analysis on Categorical Variables

Started by Arun Oct 26, 2009.

Text Mining 1 Reply

Started by Arun. Last reply by Alex Zolot Aug 19, 2009.

Some help on Monte Carlo simulation using Excel 6 Replies

Started by Arun. Last reply by Shashank Shekhar Jun 14, 2009.

RExcel 9 Replies

Started by Alex Zolot. Last reply by Arun May 26, 2009.

Bring up your Comments/Issues/Ideas please

Started by Arun Apr 26, 2009.


Excel Modeling World Championships 2014

The annual Excel and Financial Modeling World Championship 2014 Event (known as ModelOff) is here. Check out more details at

Converting Monthly data to Weekly data in Excel

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 […]

Round “time” in Excel

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 […]

Where EXCEL fails?!

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 […]

Coloring the scatter plot in Excel in groups

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 […]

Comment Wall

Comment by Arun on April 1, 2010 at 9:59am
Been quite long, and I actually only found my way after a mail from Vincent on "Member of the Month"!! :)


You need to be a member of Excel Analytics to add comments!


Members (133)


© 2014 is a subsidiary and dedicated channel of Data Science Central LLC

Badges  |  Report an Issue  |  Terms of Service