article thumbnail

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

BioTeams

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. Solver: What is the optimum solution to my model? Website: [link]. But what is the best combination?

article thumbnail

The Most Important Trait To Boost Your Productivity

Productivityist

Back in 2011, I took the time to learn new techniques in Microsoft Excel through a course. tasks completed in seconds rather than minutes) in using Excel, a workhorse tool in the corporate world. Example : I am currently working to launch my first online course. For example, want a book contract with a major publisher?

Insiders

Sign Up for our Newsletter

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

article thumbnail

Convert excel spreadsheets into online simulations and dashboards

BioTeams

Here is an example model I built with Crystal. As well as building dashboards Crystal is also very good at building online questionnaires (in my example a Bioteams Questionnaire) where you can instantly see charts and visualisations of the entered results. More about ezViz later when I look at data visualisation tools.

article thumbnail

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. The example diagram below is taken from an Evaluation of the UNAIDS/UNITAR AIDS Competence Programme. First you assess each group individually across each of the behaviours.

article thumbnail

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.

article thumbnail

A free Leadership Development Benefits Estimator Tool

BioTeams

You might, for example, conclude that only 50% of these benefits might accrue in the first year followed by 100% in year 2 and 80% in year. If you would like a free copy of the Leadership Development Benefits Estimator Tool Microsoft Excel) just send me an email with "Leadership Development Calculator" in the subject line or clicking here.

article thumbnail

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. These ten areas had been determined as possible HPT key belief areas from a review of the relevant literature (see References at end of this article).