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

40 Excel hacks for assistants

Practically Perfect PA

If I had to make a list of all of my favourite office technology and software Microsoft Excel would most certainly be missing from the top ten (urm… it probably wouldn’t make the top 100). I do hold a grudge against Excel I must say. Mostly because of all the time spent on Excel doing expenses for Executive’s that had that habit of chucking months and month’s of receipts at me with no idea where they came from or what they were for.

2015 182

Today’s Admin Needs to Become a Mobile Office Pro

Office Dynamics

Microsoft. 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. Backup and store your files via a cloud service. Files will be accessible from any device you have installed the app on. An added benefit is the ability to share and collaborate on files of various types with others.

2016 150

Productivity Multiplier: Google Cloud Connect Now a Reality

Productivity Bits

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. Here are my favorite reasons for making the switchless switch to Google Cloud Connect: Keep Your Favorite Microsoft Office Tools. The Google Cloud Connect toolbar in Microsoft Word after installation.

Google 185

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

Productive & Organized

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. Review past files, e-mails, and calendars to fill in specific dates for tasks and appointments. Productive & Organized Home Contribute to P&O! Archive Network with Steph Is This You?

2010 164

Best Business Technology for Small Businesses & Their Owners (28 ideas from them to you!)

Productive & Organized

OneNote: My Filing Cabinet In The Clouds. Microsoft's OneNote is my go-to organizing tool for anything that I do online.I create notebooks and files just like I would with paper, but now it is all organized on my computer. We were trying to figure out a way for my Associates and I to share files within my home office but also with my business partner that lives about 20 minutes away. Microsoft Excel Spreadsheets & Having Processes In Place.

2011 201

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

Convert excel spreadsheets into online simulations and dashboards

BioTeams

There are two neat tools you can use to quickly turn excel spreadsheets into online simulations, what-if models and dashboards. Simulate Simulate allows you to import excel models (and also a number of other tools including ithink) and then add a user interface with a drag and drop tool enabling you to add multiple pages with objects such as text, images, sliders and charts before publishing over the web.

2012 53

"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