Remove Blog Remove Examples Remove Microsoft Excel Remove Social Media
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

Today’s Admin Needs to Become a Mobile Office Pro

Office Dynamics

Apps for file access, e-mail, calendar, password protection, word processing, spreadsheets, presentations, virtual meetings, news, weather and travel are examples of key productivity tools mobile devices should have installed. Microsoft Office is one of the most widely used suites of productivity tools in the business world.

Dropbox 100
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).