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? Here are the 6 simple steps to using the subtotal function in Microsoft Excel: Highlight the firm names and figures. Retrieve Your Files with Ease Is You Boss Not Giving You Enough Work?

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? I remember back in the day when Microsoft Excel 2003 and prior versions didn’t have this feature. Then we upgraded to Microsoft Office 2007 and voila!

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

Retrieve Your Files With Ease

Professional Assistant Blog

Home About Me Advertise Retrieve Your Files With Ease By The Professional Assistant on Wednesday, November 05, 2008 Filed Under: MS-Access , MS-Excel , Organize , Productivity D o you have quite a bit of filing to do? Do you feel that you should have some sort of control over these files on how you find them, for future reference? One of my readers asks: I am trying to organize a file room based not on traditional alphabetical filing, but on a retrieval system.

Filing 100

Copying Tables, Pictures or Text in PDF Files to Other Sources

Professional Assistant Blog

Home About Me Advertise Copying Tables, Pictures or Text in PDF Files to Other Sources By The Professional Assistant on Thursday, January 17, 2008 Filed Under: MS-Excel , MS-PowerPoint , MS-Word , Productivity D id your boss just ask you to copy a table, picture or text to another source of software, such as Microsoft Excel or Word ? If you want to copy text from a PDF file into another source, click on the following icon shown below.

2008 100

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

Professional Assistant Blog

Home About Me Advertise Need to Change Excel Details from Vertical to Horizontal or Vice Versa? 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.

2010 122

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 ? Do you already have a table set up in Microsoft Word, but dont want to copy to Microsoft Excel and back again, just to sort it? Retrieve Your Files with Ease Is You Boss Not Giving You Enough Work?

Opening Microsoft Office 2007 Files in Microsoft Office XP

Professional Assistant Blog

Home About Me Advertise Opening Microsoft Office 2007 Files in Microsoft Office XP By The Professional Assistant on Wednesday, January 09, 2008 Filed Under: Client Service , MS-Access , MS-Excel , MS-Outlook , MS-PowerPoint , MS-Word , Productivity I recently had a vendor send us an Excel spreadsheet that he created in Microsoft Word 2007 format. Unfortunately, our firm still only has Microsoft Office XP and was curious as to how this would work.

2007 100

Who Called? Use A Phone Call Log!

Professional Assistant Blog

By The Professional Assistant on Thursday, October 09, 2008 Filed Under: MS-Excel , Organize , Productivity D o you find that when you receive phone calls or voice mail messages, you cant remember who called, what time they called, who they were trying to call, etc? The way I would do it is that I would create a Microsoft Excel spreadsheet for the month. Also, remember to archive these files, just in case you need to go back and check who called when for what reason.

2008 100

"Excel"ing to Create Subtotal Row Totals

Professional Assistant Blog

Home About Me Advertise "Excel"ing to Create Subtotal Row Totals By The Professional Assistant on Wednesday, September 03, 2008 Filed Under: MS-Excel , Organize , Productivity Y our manager sends you an e-mail with a spreadsheet attached. On a side note, if you need help creating subtotals, check my post on using subtotal functions in Microsoft Excel. Retrieve Your Files with Ease Is You Boss Not Giving You Enough Work?

2008 100