article thumbnail

Using Subtotals Function in Microsoft Excel

Professional Assistant Blog

Home About Me Advertise Using Subtotals Function in Microsoft Excel By The Professional Assistant on Wednesday, January 30, 2008 Filed Under: MS-Excel , Productivity D o you have a Microsoft Excel spreadsheet where you have firm names and figures? checked (in this example).

article thumbnail

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

BioTeams

First here are my top 3 free excel add-ins. NodeXL: How do I analyse network data quickly and visually? 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.

Insiders

Sign Up for our Newsletter

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

article thumbnail

Opening Microsoft Office 2007 Files in Microsoft Office XP

Professional Assistant Blog

For example, if I have Microsoft Excel XP and would like to send a file to a client that only has Microsoft Excel 97 (which was a horrible disaster for Microsoft, since there were quite a few bugs in this version), you could save the file as a Microsoft Excel 97 version.

2007 100
article thumbnail

Boost Productivity by Picking the Best To-do List for You

Stephanie LH Calahan

Archive Network with Steph Is This You? The following are options for to-do list formats and tips for using them most effectively:     * Excel lists. Keeping a list in Microsoft Excel is great for coordinators whose priorities can change from hour to hour. Productive & Organized Home Contribute to P&O!

Calendars 100
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

Bioteams develops unique Social Media Impact Forecasting Simulator

BioTeams

It is possible to profile campaigns over time to allow build-up periods and to tailor channel response rates, for example, to allow for seasonality and other temporary factors such as advertising campaigns. The free version of the simulator is fully functional but is limited to 6 month campaigns, 4 content types and 4 owner channels.