Microsoft Excel: The Bumblebee's six most useful Excel add-ins

BioTeams

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 6 excel add-ins which meet this criterion - NodeXL, Solver, Rainbow, Spreadsheet Converter, Crystal Ball and Fractal Maps. Next my top 3 paid excel add-ins.

Today’s Admin Needs to Become a Mobile Office Pro

Office Dynamics

Microsoft. An added benefit is the ability to share and collaborate on files of various types with others. Microsoft OneDrive. OneDrive is tightly integrated with newer versions of Microsoft Office. If you want to stay all Microsoft and easily edit Microsoft documents from the cloud, OneDrive might be the one for you. Microsoft’s paid version is OneDrive for Business, which contains more features for collaboration.

2016 150
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Productivity Multiplier: Google Cloud Connect Now a Reality

Productivity Bits

But if you’re like me, you are far more comfortable using Microsoft Office products. Google Cloud Connect lets you work right out of Microsoft Office software and still get all the benefits of Google Docs and a cloud-based office productivity suite. Here are my favorite reasons for making the switchless switch to Google Cloud Connect: Keep Your Favorite Microsoft Office Tools. The Google Cloud Connect toolbar in Microsoft Word after installation.

Google 185

A Leaders Guide to creating High Performing Teams (HPTs)

BioTeams

1) A team health-check calculator (written in Microsoft Excel ). I am pleased to release a new white paper " A Leaders Guide to creating High Performing Teams (HPTs) ". This 15-page executive guide, aimed at leaders and managers in all sizes and types of organisation, proposes and explains a pragmatic and comprehensive framework for the necessary interventions required to successfully introduce High Performing Teams (HPTs) into organisations.

2015 40

Convert excel spreadsheets into online simulations and dashboards

BioTeams

There are two neat tools you can use to quickly turn excel spreadsheets into online simulations, what-if models and dashboards. Simulate Simulate allows you to import excel models (and also a number of other tools including ithink) and then add a user interface with a drag and drop tool enabling you to add multiple pages with objects such as text, images, sliders and charts before publishing over the web.

2012 53

The River Diagram: Strategic community change management

BioTeams

Next you aggregate the scores of all of the groups to create the River Diagram - this can easily be done in Microsoft 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. The River Diagram idea is quite straightforward.

2011 53

A free Leadership Development Benefits Estimator Tool

BioTeams

Here is a simple Excel-based tool which will get you started and which you can easily enhance if you need more. That is good news and it is a comprehensive and excellent 80-page report which is well worth studying. At Dashboard Simulations we have developed a simple Excel-based (Excel) tool which guides you through 3 simple steps to estimate the financial benefits resulting from a specific leadership intervention with an individual Leader.

2014 54

Instant Customer Data Analysis using Excel: worked example

BioTeams

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 I will share with you a simple 7-step plan based on a fully worked example of Customer Data Analysis using Excel. For a copy of the worked example excel spreadsheet containing all the formula please email me.

2012 70

Bioteams and the beliefs of high performing teams

BioTeams

We conducted two surveys: the first (using Microsoft Excel ) included twenty questions, which allowed us to cover the 10 areas with two questions per area. Organizing Genius - The Secrets of Creative Collaboration , Nicholas Brealey Publishing. Team Beliefs are the fuel which can really energise or kill team effectiveness. Unfortunately this is often the most neglected aspect of a high-performing team initiative.

2011 58