Subscribe to DSC Newsletter

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, 2014

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

A lot of the time, there are differences between different pieces of data received from a client/ data team – one being when different pieces roll up to different levels in a nested structure, for eg. weekly vs monthly vs yearly. Is that problem? Let’s take a look.. Taking the example here – let’s assume […]

Round “time” in Excel

How does the Time format work in Excel? – The DATE & TIME is integrated to be represented by one number – a floating point number! – The decimal part characterizes the time, while the integer part the date. – [0,1] = [00:00 HRS,00:00 HRS + 1 day] This is the set that determines the […]

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 by groups in Excel

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 more than 2D data for a scatter plot? Let’s take an example here. This is how the data looks like – While the above scatter plot gives […]

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 (132)


Follow Us

On Data Science Central

On DataViz

On Hadoop

© 2016 is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Terms of Service