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.

the_bumblebees_1.jpgImage: A fractal map of retail sales data

First here are my top 3 free excel add-ins

NodeXL: How do I analyse network data quickly and visually?
Website: http://nodexl.codeplex.com/

NodeXL, a free third party add-in, turns excel into a powerful Social Network Analysis (SNA) tool which allows you to do a comprehensive analysis of social network data in the form of network maps. NodeXL also calculates key network metrics such as Degrees Centrality, In-Betweeness and Closeness. With NodeXL you simply import your network data in various forms (known as sociographs) and then manipulate it in excel.

Solver: What is the optimum solution to my model?
Website: http://www.solver.com/

Many spreadsheets take the form of a set of input decisions which then interact to produce a set of outcomes over time. For example, the percentage we could invest in different sales activities for different products or channels all of which add up to a total annual sales or profits figure. But what is the best combination? Solver is a free add-in which ships with every copy of Excel but is not automatically installed - you need to enable it from the options menu. Solver can be massively useful in supporting planning or strategy as it can automatically vary your input decision cells thousands of times subject to whatever constraints you specify until it finds the optimum value of a specified cell (e.g. Total Sales or Total Profits). If Solver is not enough for you there are a whole host of paid upgrades available from Frontline Systems.


Rainbow: How can I make this spreadsheet less of a maintenance nightmare?
Website: http://www.themodelanswer.com/

Rainbow is a clever piece of spreadsheet auditing software which offers a free personal version as well as paid versions. Rainbow allows you to check a spreadsheet for unnoticed errors or bad practice which will cause problems somewhere down the line. As well as error detection Rainbow also helps you to restructure and colour code a spreadsheet to make it easier to maintain.


Next my top 4 paid excel add-ins

Spreadsheet Converter: How do I turn this spreadsheet into a full web application?
Website: http://www.spreadsheetconverter.com

Spreadsheet Converter allows you to deploy spreadsheets as full-blown web-based applications or web apps solutions without having to recode them. Spreadsheet Converter is designed for applications which gather input values in forms which can then be processed in situ or sent over the web to dedicated back-end applications (e.g. survey and questionnaire type applications).


Crystal Ball: What are the range of outcomes in my data?
Website: http://www.oracle.com/crystalball

Crystal Ball is a tool from the massive Oracle Corporation which is broadly similar to Solver but provides additional functionality to allow you to fire different distributions of input numbers at a spreadsheet to test different solutions for risk and probability. Crystal Ball also allows you to perform standard complex analyses such as Monte Carlo simulations.


Fractal Maps for Excel: Can I see my data in a more compelling way than excel charts?
Website: http://www.fractaledge.com

Fractal Maps for Excel is a powerful add-in which allows you to produce fractal map representations from your data. Fractal maps are a new data visualisation technique which are particularly useful for showing instantly how hierarchical and matrix data is structured. Think 3-D Pie Charts on steroids!


XCell Compiler: How can I distribute my spreadsheet securely as a standalone executable program?
Website: http://www.doneex.com

It's a well known fact that excel password protection stinks. If you do an internet search you will quickly find a free excel password cracker which will decode the passwords in a spreadsheet in a matter of seconds. It's not really a problem if you are sharing material with your colleagues but say you are selling a commercial spreadsheet with valuable intellectual property embedded in it which would be compromised if your users could get at your formulae. Or you might have built a spreadsheet for a customer where you have used existing routines which you do not want to be copied.

Enter Stage left XCell Compiler which allows you to compile any Excel spreadsheet into an EXE application with securely hidden formulas in binary format and protected VBA code. It also allows you to add your own splash, icon and end user license agreement (EULA). XCell Compiler allows you to provide royalty free distribution of your compiled EXE, which doesn't require any pre-installed Run-Time libraries. It also allows you to restrict the time period of usage for your compiled Excel workbook which is useful if say you wish to offer a 30-day trial. If you need professional protection of your excel IP then XCell Compiler really is a no-brainer - none of the other alternatives come close - I have checked them out.

So these are my seven most useful free and paid excel add-ins as at August 2012 - I would love to get readers views on other products to add to my list!



About Ken Thompson

Ken Thompson delivers keynote conference speeches, workshop facilitation and in-house consultancy in four key business areas:

  1. Creating High Performing Teams in enterprises including Virtual and Mobile Teams (based on the Bioteams Book)
  2. Establishing effective Collaborative Business Networks enabling companies to co-operate effectively in areas such as sales and product development (based on the book - The Networked Enterprise)
  3. How to use the latest social media technologies including blogging and online communities to promote enterprises, brand, organisation or event
  4. Development of graphical on-line interactive Business Dashboards and What-if Simulators for organisations to support Performance Improvement, Strategy Development and Executive Team Development.



    Tags: , , , , ,

Comments (0)| Related (3) |

Print this article

2 Comments | Leave a comment

Hello Ken,

Thanks for the article. I came across a lot of useful add-ins which I was unaware of. I was surprised that PowerPivot was left off the list. In all great piece.

thanks,

-Othniel
Principal
Excellent Ones Consulting

Hi Othniel

Good spot - PowerPivot is a good add-on if the built in pivot tables are not enough for you

Best Regards

KEN

Leave a comment

 


Bioteams Books Reviews

Team leadership without formal authority

Team leadership without formal authority

Lateral leadership skills are how to get the job done when you are not the boss.Roger Fisher, the world's leading expert on win-win negotiation, partners with Alan Sharp in Lateral Leadership (1998, 2004) to identify three fundamental problems with collaboration in organisations and what you can do to fix them.


Buy it now from:
Amazon.Com
Amazon.Co.UK


Comments |

continue reading

Click here to check all Bioteams book reviews

Ken's LinkedIn Profile



Follow Ken's Blogs



NASA Widget2_160x40.jpg

KenThompson


Featured Categories

Trending Topics

agility analytics ants autopoiesis bees biomimicry bioteaming bioteams change management collaboration Collaboration collective intelligence community complex systems dashboards digital dashboards ecosystems excel experiential learning flock games high-performing teams innovation leadership learning meetings mobile phones organizational teams penguins pheromones self-managed teams serious games simulators social media Social Networks social networks social software swarm swarm intelligence swarmteams teamwork The Networked Enterprise tit for tat VEN videos virtual communities virtual enterprise virtual enterprise networks virtual teams visualization web2.0 wisdom of crowds

Click for more...

Featured Article

Team joining hands

The secret DNA of high-performing virtual teams

Bioteaming – the secret to high-performing, self-organising, virtually networked teams... more

Locations of visitors to this page

Bioteams iphone app
Bioteams android app

Search www.bioteams.com


Bioteams Lite

FeedWind

Latest Full Articles


Bioteams Assessor - Instantly check how good your team is?
BioScore Calculator – Instantly see if you need Bioteams
Discover Bioteams principles Yourself via Action Learning

Bioteams Manifesto

Communities and Networks Connection

Bioteams Ice-Breaker Zone

Only Fools and Horses Video Clip Funny Team Collaboration Video Dilbert Mission Statement Generator Ali G Video Funny Red Dwarf Video  FatherTed  Pixar

News Feed

Sign up for RSS   RSS Feed Subscription
        (What's RSS?)

10 Most popular posts

Recent posts

Archives

Download Browsealoud