February 2012
3 posts
3 tags
Quick Access Toolbar in MS Office
I am constantly trying to find helpful shortcuts that can make me a more productive Executive Assistant. One thing I use is the Quick Access Toolbar which allows me to add the commands I use more frequently to the toolbar highlighted below. This in turn helps me eliminate a few extra clicks and save time. There are two possible locations to display this: above or below the Ribbon. I currently...
2 tags
View Google Calendar (.iCAL) in Outlook 2010
I use Google Docs and Google Calendar to do most of my personal work. But if you are an Executive Assistant or Admin Assistant chances are that you use MS Office for office work. Since I am on Outlook all the time at work, I thought it would be easier to view my Google Calendar in Outlook as well. If you’d like to add your Google Calendar try what I did. I am currently using Outlook 2010.
...
1 tag
Sort Data in Excel 2007
As an Executive Assistant I work on MS Excel a lot. I am constantly doing something on it. Here I mention how to sort data in Excel 2007. I have listed some methods I personally use to sort, filter or format data in Excel.
Ascending order (A-Z) or descending order (Z-A).
Multiple Columns.
Auto filter.
Custom sort using cell color.
To sort data click on the DATA tab in the ribbon. Now you can...