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

Write An Effective Out Of Office Assistant Message

Professional Assistant Blog

Ill be checking email _(once a week, every day, etc) __, but will have limited ability to respond. 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.

Insiders

Sign Up for our Newsletter

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

article thumbnail

Is Your Boss Not Giving You Enough Work?

Professional Assistant Blog

Ive tried to exhaust all the possible things I could do that he doesnt ask me to do - organize emails, files, clutter, contacts, create procedures. Explain to him that youre in a situation where you feel unproductive and give some examples. His reply is usually, "Im working on some things that Ill get to you soon." and he never does.

2008 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. Until next time, Take care - of your clutter!

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

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