Professional Assistant Blog

article thumbnail

Using Subtotals Function in Microsoft Excel

Professional Assistant Blog

The spreadsheet might contain other types of data, but is similar to this example? checked (in this example). Imagine your boss comes to your desk and asks you to provide him/her with details of how much each firm earned in revenue on this spreadsheet. You think to yourself, how can I do this quickly, without much manual work?

article thumbnail

Prioritization: A Colorful Outlook

Professional Assistant Blog

For example, I receive an e-mail from my direct supervisor. No, you are not making your screen more lively - well, if thats what you are intending to do, then go ahead. When e-mails come in and you have set up your colors, you will notice that you have prioritized them by color. Then I have my faxes set up as green.

2008 100
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. I remember in the past that you can always downgrade files.

2007 100
article thumbnail

Calculation of Discounts in Excel

Professional Assistant Blog

Here is how to calculate the difference between two numbers as a percentage: For example, your earnings are $2,342 in November and $2,500 in December. It kept providing me topics that werent relevant to the particular answer I was looking for. I then checked Excels help file and there it was.

article thumbnail

Break The Routine, Inspire Yourself!

Professional Assistant Blog

F or example, if you want to make a million dollars before you die, write out exactly what you want and how you will achieve this. Another thing that helps people to get motivated is by writing some sort of mantra on a piece of paper or printing it out. This way, when you sit down, you can read it each and every day.

Cubicle 100
article thumbnail

"Stop Watch"ing Your Productivity

Professional Assistant Blog

For example, you want to spend one hour on a particular project. But of course, you don’t want to disturb others around you with the bell going off or some even have chickens clucking as the alarm. To avoid this, try using an online timer instead. Virtual Stopwatch gives you the option to set a predetermined amount of time.

2008 100
article thumbnail

Write An Effective Out Of Office Assistant Message

Professional Assistant Blog

For example: Advertising inquiries, please contact John Doe at john.doe@company.com Billing inquiries, please contact Jane Smith at jane.smith@company.com And so on and so forth. I appreciate your example. And lastly, don’t forget to turn it on. Thanks, Richard Posted on 23 September, 2008 10:40 AM Delilah Thanks for the tip.