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? Click Data, then Sort, then sort by the firm name.

article thumbnail

Increasing Microsoft Excel 2007's Formula Bar Size

Professional Assistant Blog

Home About Me Advertise Increasing Microsoft Excel 2007s Formula Bar Size By The Professional Assistant on Wednesday, November 18, 2009 Filed Under: MS-Excel , Productivity D o you find that trying to either write or fix formulas in Microsoft Excel can be a pain?

Insiders

Sign Up for our Newsletter

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

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.

article thumbnail

Need to Change Excel Details from Vertical to Horizontal or Vice.

Professional Assistant Blog

By The Professional Assistant on Wednesday, July 07, 2010 Filed Under: MS-Excel , Productivity Y our boss calls you over to their office and asks that you send her a list of something that you’ve created in Microsoft Excel. You check your contact list and see that you have about 50 names in your Excel spreadsheet.

article thumbnail

A Leaders Guide to creating High Performing Teams (HPTs)

BioTeams

1) A team health-check calculator (written in Microsoft Excel ). The guide also provides comprehensive check-lists for both team process development and change management interventions with clear guidance and tips on when and how best to employ them. The guide concludes by offering 3 very useful support tools for HPTs.

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

Sorting Tables in Microsoft Word

Professional Assistant Blog

Home About Me Advertise Sorting Tables in Microsoft Word By The Professional Assistant on Wednesday, January 23, 2008 Filed Under: MS-Word , Productivity H ave you ever wondered or tried to sort a table within Microsoft Word ? One of my colleagues came to me and asked about this very question.