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

How to Use Evernote: 22 Ways

Ian's Messy Desk

Document Storage - When I receive a document (PowerPoint, Word, Excel, or PDF) that I’ll need again, I forward it to Evernote. Store Business Cards - Instead of collecting a pile of business cards that you’ll lose, photograph or scan them send the images to Evernote. You can also select the width of the pen.

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

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.

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

“Who, me, network?” Build Confidence in Your Networking Skill!

Office Dynamics

Bring business cards to an event or IAAP meeting, and set a goal to get or give a certain number before or after the meeting. Jot notes on the back of their card, and make it a goal to follow up with them within a week following the introduction (next day is even better!) Awesome wordsmith? Paint watercolors? Able juggler?].

article thumbnail

“Who, me, network?” Build Confidence in Your Networking Skill!

Office Dynamics

Bring business cards to an event or IAAP meeting, and set a goal to get or give a certain number before or after the meeting. Jot notes on the back of their card, and make it a goal to follow up with them within a week following the introduction (next day is even better!) Awesome wordsmith? Paint watercolors? Able juggler?].

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.