XLMiner solves Big Data Problems in Excel. Here’s the KDNuggets article.
Released: Twitter Analytics for Excel 2013 zite.to/158IRE7
Copying Data from Excel to R and Back zite.to/YuY7a5
The Data Mining: Text Mining, Visualization and Social Media blog has some good tips on using Google to locate Excel files. Try this next time you’re on Google:
The PTS Blog has a constant stream of great articles on how to better utilize Excel and its charting capabilities. This is one I found quite useful today, how to make clustered, stacked column charts in Excel. Column charts are great, as are stacked column charts. But this shows you how to make stacked column charts with multiple stacked columns per point on the x axis.
PTS has some good tricks for using Excel’s auto filters including using auto filters with pivot tables
Making charts in Excel is something we all do quite frequently. When you make a stacked column chart in Excel, the columns are normally stacked in whatever order you put the series in. Check out this how-to guide for reorganizing the columns so the largest values are on the bottom of each column. Using this approach will help you more easily compare the biggest feature of your data set from one observation to the next.
And here are some other Excel related articles.
If you’ve been missing the Analysis Toolpack and Solver from Excel 2008 for Mac, Microsoft has a solution for you. They’ve worked with AnalystSoft to develop an add-on called StatPlus:Mac LE. Check out this article for the full details.
For all you Mac Excel users out there who have been missing the Analytics Tool Pack, rejoice. Microsoft says the Analytics Tool Pack will be back any day now.