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: filetype:xls
Dec 07
Apr 19
Access has come in handy so many times for me when Excel just wouldn’t cut it. Jorge at ExcelCharts.com suggests that knowing how to use Access can may you a better Excel user. I agree. Check out his post for the rest of the details.
Oct 27
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.
Jul 08
Just because everyone has Excel doesn’t mean everyone knows how to use it correctly. Jorge Cameos brings us 10 Excel chart mistakes to avoid. Make sure to check out his site for all the details.
- Assuming that Excel can do it
- Assuming that Excel can’t do it
- Not having a go-to person
- Creating Excel islands
- Tons of useless workbooks sitting around
- Bypassing IT
- Not using VBA
- Excel is the only charting tool
- Forgetting the 3 R’s – reduce, reuse, recycle
- Not making things work together
May 23
PTS has some good tricks for using Excel’s auto filters including using auto filters with pivot tables
May 20
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.
May 12
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.
Mar 14
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.
Mar 14
Here’s a hack for excel that explains how to better chart related series on two axes without the confusion associated with the normal excel way of doing it.
