Articles Tagged With: "excel"
There are two neat tools you can use to quickly turn excel spreadsheets into online simulations, what-if models and dashboards. They are Simulate from Forio and Crystal Presentation Design (formerly known as xcelsius) from SAP. Here's the lowdown.
There are a plethora of excel add-Ins out there, many of which aim to improve or extend a feature which excel already performs. I am not much interested in these but what I am interested in is add-ins which enable you to do something really useful which you cannot currently do in excel. In this article I introduce seven excel add-ins which meet this criterion - NodeXL, Solver, Rainbow, Spreadsheet Converter, Crystal Ball, Fractal Maps and XCell Compiler.
Data Mining, a hi-tech buzzword for many years, is about excavating useful patterns which are hidden deep in your data to give you valuable insights you could not otherwise find. I was looking for a data mining tool in the same broad price bracket as Excel but which was also robust and did not require you to be a mathematics genius to use it. Surprisingly I managed to find a product which exactly met my needs!
Here is an excellent web link plus two great books which address the question which diagram or chart should I use to best communicate different types of information visually. With at least 40 types of diagram and new ones/variants constantly being invented this is a hot topic!
One of the most useful aspects of Microsoft Excel is its ability to quickly slice and dice customer data from live systems to identify important trends and behaviors which can inform strategy. In this article and screencast I share a 7-step plan, illustrated with a worked example, for Instant Customer Analytics using Excel.
I am always on the lookout for good simple visualisation techniques to support change management. Chris Collison has introduced me to The River Diagram - a great strategic tool for moving a community of groups forward via common initiatives and best practice sharing.
I have been intrigued with a new iphone app called RoamBi ("roaming business intelligence") which allows the creation of "secure mobile dashboards and visualizations" on iphones and ipads for individuals (free) and enterprises (not free) using data from excel plus other data-rich enterprise applications such as Business objects and Salesforce.com.