In an earlier article, The Bumblebee's 7 most useful Excel add-ins, I shared my 7 most useful excel add-ins. Here I share my 3 most useful Powerpoint add-ins - Acoolsoft PPT to Video, iSpring and PPT2HTML. Like excel add-ins once you install them they become available within the powerpoint menus. Unfortunately none of these are free but sometimes you get what you pay for.
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.
It's a common problem - you have developed some very useful excel charts and dashboards and now you need to publish and share them on the web. There are lots of excel add-ins and add-ons (and I must have tried them all) - the problem is most will either be very expensive or disappoint you either in terms of their restrictions or how nicely they present your data.
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!
I have been looking for way to monitor and track all my websites/blogs plus all my social media accounts (linkedIN, Twitter etc) from a single dashboard. I figured this would be pretty easy - a thing that most people would want to do! Not so - despite the abundance of great social media tools I found it surprisingly difficult to find one which met all my requirements.
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 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.
Three new types of graphing/charting object - sparklines, bullet charts and heat maps used in conjunction with a powerful new technique known as micro-charting, which allows complete mini charts to be embedded in single cells, can transform online dashboards, business scorecards, and what-if simulations. Here is a simple introduction.
Interesting post on the idashboard blog which shows up how mass sentiment expressed through social media such as twitter can be automatically extracted into data visualization software and the results displayed in almost real-time. The number of applications for this type of social media dashboarding must be huge in both business and civic engagement