Skip to main content

Tech Tips

Show percentages with a little color (Excel 2007)

 

Percentages interpret your data as smaller parts of a larger piece. This is why pie charts are often a popular way to demonstrate percentages. However, if you want to conserve space and still present an attractive, effective visual of your percentage data, Excel 2007 offers a great alternative.

On the Home ribbon, in the Styles panel, there’s a Conditional Formatting icon that opens a shortcut menu. In this menu, you’ll see a formatting option called Data Bars. When you select a data range and then apply data bars (in any of a wide range of colors), the bars visually demonstrate the percentage or number in comparison to the other numbers in the data range. If you widen or contract the column’s width, the data bars remain proportionate.

The best part about the data bars is that they take seconds to apply — but it looks like they took hours of careful formatting

 

Stop forgetting to respond to that email: Flag it for follow-up

Outlook lets you flag messages and Contacts, but you can't flag other types of Outlook items, such as calendar items and tasks (which have their own reminder behaviors you can set). You can't flag notes or journal items either.

To flag a message for follow-up, display your Inbox and open a message that you need to respond to or one that's asking you to perform some kind of action. Usually, such an email message contains precisely the information you need to have on hand when you respond or when you get around to acting.

Outlook users typically might create a task or appöintment (appöintments aren't just for meetings, you know) by copying information from the email message into the other Outlook item they create.

Instead, choose Actions | Flag For Follow Up, or press [Ctrl+Shift+G]. You can also click the Flag For Follow Up tool. The Flag For Follow Up dialog box displays. From the Flag To dropdown list, choose from a variety of flags, each designed to jog your memory at some point in the future. Some of your choices inlcude Call, Follow Up, Forward, Read, Reply, or Review, as shown in Figure A.

Choose the type of flag that's most appropriate. Often the default Follow Up flag is sufficient. Or, you might prefer a flag reminder to call, reply, or even not to forward a specific message.

Open the Due By dropdown list and when the calendar displays, select the due date. By default, 5:00 p.m. is set. You can edit that time in the Due By text box.

When your choices are complete, click OK. Your full flagged information displays in the message box. Choose File | Savë and then close the message window. In the Inbox, a red flag marks the message.

Different flags for different views
The view determines if and how flags display. In Inbox views that group messages, such as By Sender, you must expand a group to see any flags. A Contacts table view, such as Phone List, uses the same kind of flag you see for messages. In the Inbox By Follow-up Flag view, a Follow Up Flag: (flag type), reports which type of flag is set.

 

 

Thanks & Regards

============================

Mohammed Rahman Mecheri

 

System Analyst – Network & Infrastructure
Kamal Osman Jamjoom Group LLC.
Unit #422, Sultan Business Centre
P.O Box 27844, Dubai, UAE
Tel:       +971 (4) 3355232 Extn: 1339
Fax:      +971 (4) 3355231
Mobile:  +971 (50) 9774048
Email:    mrahman.koj@gmail.com

             mrahman_koj@hotmail.com

             mrahman_koj_est@yahoo.co.uk

Web :    https://about.me/mrahman

============================

 

Comments

Post a Comment

Please write your comment

Popular posts from this blog

Tech Tips - Turn on Delegate Access

Turn on Delegate Access A delegate automatically receives Send on Behalf permissions. This means your delegate can do the following: ·          Respond to a meeting request sent to you, the manager. ·          Receive meeting request responses sent to you, the manager. ·          Compose and send an e-mail message that, when received, will have Delegate Name   on behalf of   Manager Name   next to   From . By default, the delegate can read only the meeting requests and responses sent to the manager. The delegate does not have access to read any other messages in your   Inbox . 1.      On the   Tools   menu, click   Options . 2.      Click the   Delegates   tab, and then click   Add . If the   Delegates   tab or the   Add   button is mi...
Post a Comment
Read more

How do I choose my password?

How do I choose my password? Your password is more than just a key to your online account. If your password falls into the wrong hands, someone can easily impersonate you while online, sign your name to online service agreements or contracts, engage in transactions, or change your account information. So, choose your password carefully and then keep it safe from others. A password is like a toothbrush: Choose a good one and don't share it. A Yahoo! password can be any length, and can contain spaces, symbols, or numbers. With so many options, you should be able to come up with a password that's easy for you to remember but impossible for someone else to figure out. A password is a secret that only you should know. Here are some tips for choosing a strong password - one that is difficult to guess. . Choose a password you'll remember. It should be memorable for you (so that you don't have to write it down or leave it in the open), but difficult for others to guess....
Post a Comment
Read more

Tech Tip - How to Search Like a Pro

Technology Tip - How to Search Like a Pro The internet is big, really, really big.  And it keeps growing bigger every day.  If you want to search it effectively you’re going to need to develop a couple of tricks to help you narrow the search.  Here’s a few real easy ones to integrate into your next search: Using +, - and “ “ (quotes) to narrow your searches: Lets say you were looking up apples on   Google.com .  If you just type in “apples” you get 22 million returns.  A few more sites than you can check in an afternoon so lets narrow the search down.  Let's say that what you're really interested in is   green apples .  To see all the apple websites that also have the word “green” on them type this: Now you will only see those apple sites that also have the word green on them.  Unfortunately we are still getting almost 6 million returned websites: To narrow the search even more lets elimina...
Post a Comment
Read more