Chris Leong

Disoriented views from the rosy lens of an optimistic realist.

Tag: Office

Now you can Tweet with your MS Outlook

Ok if you are Tweeter fan, now you can actually tweet using MS Outlook.

Some summary about TwInBox

If you are a Microsoft ® Outlook ® user, you probably have it open all the time. Now you can have a fully-featured, powerful Twitter client at your fingertips without having to open any other applications. TwInbox seamlessly integrates Twitter into Outlook. It is a perfect Twitter client for any Outlook user, from a Twitter newbie to a business professional.

 ot 

ot_post_tn 

Here are some of the features provided by TwInbox

Features

  • Update your Twitter status directly from Outlook.
  • Receive your friend updates in Outlook.
  • Archive, manage, group and search your tweets the
    same way you manage your email (details).
  • Search, track keywords. TwInbox will automatically download ALL tweets matching the keywords you specify, even if you are not following the tweet sender. This feature is perfect for keeping up to date with the Twitter buzz on your name, brand, interests, etc.
  • Group tweets by sender, topic, etc using the Search feature.
  • Upload and post picture files and Outlook email attachments.
  • See new tweets at a glance (details).
  • Assign custom folder and categories to new messages.
  • Use Outlook’s “Reply” and “ReplyAll” commands to send twitter direct messages and @replies.
  • Automatically sort new tweets into per-sender folders.
  • Shorten URLs with tinyurl.
  • See graphs of your Twitter usage statistics.
  • Tweets sent to you (@replies and direct) are marked with high importance, so you can see them at a glance.

 

Thanks to Blake from the Road to Know Where in highlighting this

Digg This
Advertisements

Office 2010 coming your way

Office 2010 has its own website for anyone who wants to know more about what Office 2010 has to offer. They even created a preview video (transformer style) to promote it.

Office 2010 Preview

Also for anyone who’s looking into testing the new Office 2010 can sign up for the technical preview. Here’s some explanation about the technical preview

The Microsoft Office 2010 Technical Preview is a limited, invitation only program which will provide you with the opportunity to experience early, pre-release versions of Office 2010 which will include the following applications:  Word 2010, Excel 2010, Outlook 2010, PowerPoint 2010, OneNote 2010, Access 2010, InfoPath 2010 and Publisher 2010.

By registering you are signing up to be considered for the Technical Preview Program, you will be waitlisted for consideration to be invited into the Technical Preview Program. We will notify invitees in early to mid July.

Digg This

Changing the color scheme of MS Office

Black Theme of MS Word

 

You learn different things everyday. I just got to know today that you can change the color themes of your MS Office. I really need to spend more time playing around with Office, seems like there are little little things that you just don’t know. I like my office background to be black as it easier to my eyes.

Here’s how you do it

  1. Go to Word Options –> color scheme. There are 3 different color schemes for you to choose. Black, Silver and Blue.

image

Digg This

How to enter data in multiple sheet at the same time in Excel?

digg_url = “http://www.chrisleong.net/index.php/2009/04/18/how-to-enter-data-in-multiple-sheet-at-the-same-time-in-excel/”;digg_title = “How to enter data in multiple sheet at the same time in Excel?”;digg_bgcolor = “#F8F8EC”;digg_skin = “normal”;digg_url = undefined;digg_title = undefined;digg_bgcolor = undefined;digg_skin = undefined;

Here’s another tip that I found on the web. Hope its useful.

In Excel 2007, it’s possible to enter the same data into several worksheets without retyping or copying and pasting the text into each one. As an example, let’s say you want to put the same title text into different worksheets. One way to do this is to type the text in one worksheet, and then copy and paste the text into the other worksheets. If you have several worksheets, this can be very tedious.

An easier way to do this is to use the CTRL key to group worksheets. When worksheets are grouped, whatever you do to one worksheet affects all other worksheets.

  1. Start Excel. A new, blank workbook appears.
  2. Press and hold the CTRL key, and then click Sheet1, Sheet2, and Sheet3.

    This temporarily groups the worksheets. In the title bar, you should see the name of the workbook followed by the word [Group].

  3. Click in cell A1 in Sheet1, and then type:

    This data will appear in each sheet.

  4. Click Sheet2 and notice that the text you just typed in Sheet1 also appears in cell A1 of Sheet2. The text also appears in Sheet3.

    Tip   When you click another worksheet, Excel automatically ungroups the worksheets for you.

Excel Tips – View Worksheet Side by Side

It’s been very long since i posted another office tips and tricks page. I sometimes needs to do that and it really is frustrating when you need to switch between Excel files. I guess this tip will be useful for those who needs to compare worksheet side by side.

So here how you can view your worksheets side by side.

On the View tab, in the Window group, click New Window.

Inst

clip_image004

On the View tab, in the Window group, click View Side by Side .

clip_image006

In the Compare Side by Side dialog box, click the worksheets that you want to compare. To scroll both worksheets at the same time, click Synchronous Scrolling  in the Window group on the View tab.

 

Thanks to Lee Chun Onn that provide me. Have a tips and tricks that you want to share. Email me 🙂

Free Outlook add-in to organize your email and make your inbox better

Recently I am playing around with a free outlook add in to help me organize my inbox better. It’s call ClearContext Personal

Here are some things that it can help you with

  • suggesting the right folders to instantly file messages and entire conversations with a single click
  • highlights the most important messages in your Inbox from your most important contacts.
  • Easily follow the conversation with a threaded conversation view as part of each email message
  • Explore and preview attachments within Outlook just like folders on your desktop

So far i haven’t got use to the add in. I believe it takes some effort to adapt to it. But i guess once you got used to it, your productivity and efficiency in Outlook will increase.

But overall the best feature for me is the email thread function it provides. One of the things i like about Gmail is that it groups all similar emails. I find it easier for me to search for all my emails. It offers something similar, so far i like this feature the most.

In every mail, it will show you the email threads as highlighted in the picture below

 

Check out ClearContext’s short video demo

Import Gmail Contacts to Outlook 2007

My friend post a question to me about importing Gmail contacts to Outlook. It is actually quite simple to do it, here are some steps to do it.

1) In Gmail, click on contacts. Then select that contacts that you want to import.

Gmail Export

2) Click Export

Gmail Export Contacts

3) In the next screen, select Outlook CSV contacts

image

4) Next go to Outlook 2007. Click on File –> Import and Export

5) Select “Import from another file”

6) Select “Comma Separated Value (DOS)”

7) Follow the instructions and you should see your Gmail contacts in Outlook

Outlook Tips – Add a Second Time Zone

In my line of work, I do need to work with people from different time zones. Adding a different time zone can really helps to manage the time differences.

To add a new time zone. Go to Tools menu > click Options > Under Calendar . Calendar options

Outlook Timezones

Outlook Options

Under Advance options > Click Time Zone > select the Show an additional time zone check box. In the Label box, type a description such as “Houston”. In the time zone list, click the Time Zone and click “Ok”

Outlook Timezones

An additional time zone will appear next to your default time zone

2nd Timezone

Outlook Tips & Tricks – Managing your folders

If you are like me, my Outlook mail have too many folders storing different types of emails. Searching for your folders can be messy.

Here are some tips on how to add your frequently use folder in your favourite list.

 

Favorite folders are shortcuts to your most commonly used folder. Think of it the same as your desktop shortcut. To create a favorite folder, simply drag any folder up to the Favorite Folders area and drop it.

Remember though, if you drag “too many” favorite folders then you will end up with the same problem. So it should some selected folders that you always use

 

Favorite Folders in Outlook

Favorite Folders in Outlook

 

 

The next time you need to access the folder, just click on the favorite folder.

To remove a favorite folder, just right click and select “Remove from favorite folders”. Do not, do not delete as it will delete the original folder as well

Remove folder from favorites

Record a webcast on your desktop

Try out Office Community Clip. This is a useful tool that allows you to record your voice and all the activities in the screen in your desktop.

It is very useful tool for you to:

  • record your presentation and share it with others
  • Share your tips and tricks via video rather than text

Download the Office Community Clip and try it out..