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

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?

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

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

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

Stephanie LH Calahan

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. Coordinators have many options when it comes to picking a to-do list system.

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