Microsoft Powerpoint: The Bumblebee’s 3 most useful PPT add-ins

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.

Continue reading “Microsoft Powerpoint: The Bumblebee’s 3 most useful PPT add-ins”

Microsoft Excel: The Bumblebee’s seven most useful Excel add-ins

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.

Continue reading “Microsoft Excel: The Bumblebee’s seven most useful Excel add-ins”

Data mining made easy with DMF

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!

Continue reading “Data mining made easy with DMF”

Data visualisation – which diagram should I use?

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!

Continue reading “Data visualisation – which diagram should I use?”

Instant Customer Data Analysis using Excel: worked example

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.

Continue reading “Instant Customer Data Analysis using Excel: worked example”

Is Roambi the killer iphone enterprise app?

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.

Continue reading “Is Roambi the killer iphone enterprise app?”

Transform your online dashboards with 3 new graph types

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.

Continue reading “Transform your online dashboards with 3 new graph types”