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

I would do e-mails, phone calls, updating clients' calendars, word processing, etc. Microsoft Word Meetings Productivity Job Seeking Microsoft Access Microsoft Outlook Research Prioritize Microsoft PowerPoint Microsoft Excel Travel Customer ServiceImage by cogdogblog. U nfortunately, I got let go from my job due to restructuring and am looking for work now. This was the bad news. MORE

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

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

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. Home About Me Advertise Who Called? Use A Phone Call Log! MORE

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 ? Watch out for a future post on sorting tables within Microsoft Word. MORE

W e all know about Google as the search engine mogul and most know about Google Docs — an online version of word processing, spreadsheet, and presentations software. But if you’re like me, you are far more comfortable using Microsoft Office products. Google Cloud Connect lets you work right out of Microsoft Office software and still get all the benefits of Google Docs and a cloud-based office productivity suite. Copyright © 2011 Productivity Bits. MORE

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

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? Then, all files are set up in an excel file with columns for File #, property address, closing date, owner (whatever data important) - then sorts are run and printed so files can be referenced and found by whatever criteria you need. MORE

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

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