"Out of Office" When You Are Out Permanently

This summary is not available. Please click here to view the post.

MS Excel Keys

CTRL+SHIFT+(	Unhides any hidden rows within the selection.
CTRL+SHIFT+)	Unhides any hidden columns within the selection.
CTRL+SHIFT+&	Applies the outline border to the selected cells.
CTRL+SHIFT_	Removes the outline border from the selected cells.
CTRL+SHIFT+~	Applies the General number format.
CTRL+SHIFT+$	Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+%	Applies the Percentage format with no decimal places.
CTRL+SHIFT+^	Applies the Exponential number format with two decimal places.
CTRL+SHIFT+#	Applies the Date format with the day, month, and year.
CTRL+SHIFT+@	Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!	Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+*	Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report.
CTRL+SHIFT+:	Enters the current time.
CTRL+SHIFT+"	Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+)	Displays the Insert dialog box to insert blank cells.
CTRL+Minus (-)	Displays the Delete dialog box to delete the selected cells.
CTRL+;	Enters the current date.
CTRL+`	Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+'	Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+1	Displays the Format Cells dialog box.
CTRL+2	Applies or removes bold formatting.
CTRL+3	Applies or removes italic formatting.
CTRL+4	Applies or removes underlining.
CTRL+5	Applies or removes strikethrough.
CTRL+6	Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+8	Displays or hides the outline symbols.
CTRL+9	Hides the selected rows.
CTRL+0	Hides the selected columns.
CTRL+A	Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B	Applies or removes bold formatting.
CTRL+C	Copies the selected cells. CTRL+C followed by another CTRL+C displays the Clipboard.
CTRL+D	Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F	Displays the Find and Replace dialog box, with the Find tab selected. SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action. CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
CTRL+G	Displays the Go To dialog box. F5 also displays this dialog box.
CTRL+H	Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+I	Applies or removes italic formatting.
CTRL+K	Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N	Creates a new, blank workbook.
CTRL+O	Displays the Open dialog box to open or find a file. CTRL+SHIFT+O selects all cells that contain comments.
CTRL+P	Displays the Print dialog box. CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
CTRL+R	Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S	Saves the active file with its current file name, location, and file format.
CTRL+T	Displays the Create Table dialog box.
CTRL+U	Applies or removes underlining. CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
CTRL+V	Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
CTRL+W	Closes the selected workbook window.
CTRL+X	Cuts the selected cells.
CTRL+Y	Repeats the last command or action, if possible.
CTRL+Z	Uses the Undo command to reverse the last command or to delete the last entry that you typed. CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.

 

Five Short Chapters on Change

Five Short Chapters on Change

 

Chapter 1.
I walk down a street and there is a deep hole in the sidewalk. I fall in. It takes forever to get out. It is my fault.

 

Chapter 2.
I walk down the same street. I fall in the hole again. It still takes a long time to get out. It is not my fault.

 

Chapter 3.
I walk down the same street. I fall in the hole again. It is becoming a habit. It is my fault. I get out immediately.

 

Chapter 4.
I walk down the same street and see the deep hole in the sidewalk. I walk around it.

 

Chapter 5.
I walk down a different street.

 

Thank You Again for the First Time : Improve Your Business Writing

Thank You Again for the First Time

 

One of the most common polite mistakes I see in business writing is this: a message that ends "Thank you again. . . ." without thanking the reader at the beginning.

 

If you are in the habit of thanking the reader again at the end of your messages, be sure you said thanks somewhere previously. Otherwise, your politeness will sound canned and look silly. That would be a shame when your intention is to connect sincerely with your reader.

 

How to Have a Great Conversation with Anyone

The art of conversation takes practice, and is not as hard as you might think. It will take some knowledge, practice, and patience, and you can learn to relax and enjoy a great conversation.

With these tips you will be well on your way to having a good, meaningful and entertaining conversation with anyone!

1. Make a good first impression. Smile, ask questions that require more than a yes/no answer, and really listen. Maintain eye contact and keep as friendly and polite as possible.
2. Listen. This is the most important part of any conversation. You might think a conversation is all about talking, but it will not go anywhere if the listener is too busy thinking of something to say next. Pay attention to what is being said. When you talk to the other person, injecting a thought or two, they will often not realize that it was they who did most of the talking, and you get the credit for being a good conversationalist - which of course, you are!
3. Find out what the other person is interested in. You can even do some research in advance when you know you will have an opportunity to talk with a specific person. Complimenting them is a great place to start. Everyone likes sincere compliments, and that can be a great ice-breaker.
4. Ask questions. What do they like to do? What sort of things have they done in their life? What is happening to them now? What did they do today or last weekend? Identify things about them that you might be interested in hearing about, and politely ask questions. Remember, there was a reason that you wanted to talk to them, so obviously there was something about them that you found interesting.
5. Forget yourself. Dale Carnegie once said, "It's much easier to become interested in others than it is to convince them to be interested in you." If you are too busy thinking about yourself, what you look like, or what the other person might be thinking, you will never be able to relax. Introduce yourself, shake hands, then forget yourself and focus on them instead.
6. Practice active listening skills. Part of listening is letting the other person know that you are listening. Make eye contact. Nod. Say "Yes," "I see," "That's interesting," or something similar to give them clues that you are paying attention and not thinking about something else - such as what you are going to say next.
7. Ask clarifying questions. If the topic seems to be one they are interested in, ask them to clarify what they think or feel about it. If they are talking about an occupation or activity you do not understand, take the opportunity to learn from them. Everyone loves having a chance to teach another willing and interested person about their hobby or subject of expertise.
8. Paraphrase back what you have heard, using your own words. This seems like an easy skill to learn, but takes some practice to master. Conversation happens in turns, each person taking a turn to listen and a turn to speak or to respond. It shows respect for the other person when you use your "speaking turn" to show you have been listening and not just to say something new. They then have a chance to correct your understanding, affirm it, or embellish on it.
9. Consider your response before disagreeing. If the point was not important, ignore it rather than risk appearing argumentative. If you consider it important then politely point out your difference of opinion. Do not disagree merely to set yourself apart, but remember these points:
• It is the differences in people–and their conversation–that make them interesting.
• Agreeing with everything can kill a conversation just as easily as disagreeing with everything.
• A person is interesting when they are different from you; a person is obnoxious when they can not agree with anything you say, or if they use the point to make themselves appear superior.
• Try to omit the word "but" from your conversation when disagreeing as this word often puts people on the defensive. Instead, try substituting the word "and", it has less of an antagonistic effect.

10.  Consider playing devil's advocate - which requires care. If your conversation partner makes a point, you can keep the conversation going by bringing up the opposite point of view (introduce it with something like "I agree, and…"). If you overuse this technique, however, you could end up appearing disagreeable or even hostile.

11.  Do not panic over lulls. This is a point where you could easily inject your thoughts into the discussion. If the topic seems to have run out, use the pause to think for a moment and identify another conversation topic or question to ask them. Did something they said remind you of something else you have heard, something that happened to you, or bring up a question or topic in your mind? Mention it and you'll transition smoothly into further conversation!

12.  Know when the conversation is over. Even the best conversations will eventually run out of steam or be ended by an interruption. Shake hands with the other person and be sure to tell them you enjoyed talking with them. Ending on a positive note will leave a good impression and likely bring them back later for more!

Warnings

• Choose carefully when asking personal questions. You do not want to venture into overly personal issues. Even if the other person might be willing to talk about it, you may end up learning things that you really do not want to know. You certainly do not want the other person to think afterward that you coerced them into revealing personal information.
• Be sincere! Compliments are great, but too much flattery is obvious and will reveal you as being insincere.
• Beware of topics that can be inflammatory - such as religion and politics - and don't venture into them unless you know the person has roughly the same convictions as you, or the circumstances otherwise allow for pleasant discussion. Again, it's fine to disagree and can be nice to talk about differences, but it can also be a quick step toward an argument.
• Try not to argue! You do not have to agree with everything someone says, but you do not have to tell them all about how you disagree. If you feel the need to explain an opposing viewpoint, express it simply and without putting the other person on the defensive. It is better to simply change the subject in a casual conversation than to get involved in an argument.
• Try not to nod or respond with "Yes" and "I see" so much. It might make the person think you are bored and sometimes it may seem like you are rushing them along. Never say anything hurtful or offensive to the other person, this may project a bad feeling between you.
• If it is a planned conversation, try listening to the news in case you run out of thing to say, it is always a good solution.
• Also try not to cut the person off mid-sentence. It seems disrespectful and it makes it seem like what you have to say is more important than what the other person has to say. Let the person finish their thoughts and then continue on with thoughts of your own.

 

A good story for all of us to follow in our careers and social life

A good story for all of us to follow in our careers and social life

Once upon a time a Washerman was bringing up two donkeys.

Let us say Donkey-A and Donkey-B.

Donkey-A felt it was very energetic and could do better than the other.  It always tried to pull the washerman's attraction over it by taking more load and walking fast in front of him.

Innocent Donkey-B is normal, so it will walk normal, irrespective of the washerman's presence.  After a period of time, Washerman started pressurising Donkey-B to be like Donkey-A.  But Donkey-B unable to walk fast, got continuous punishment from washerman.  It was crying and told personally to Donkey-A "Dear friend, only we two are here, why to compete with each other....we can carry equal load at normal speed ".

That made Donkey-A all the more energetic and next day it told to washerman that it can carry more load and even it can run fast also.

Obviously happier washerman looked at Donkey-B.., his BP raised and he started kicking Donkey-B. Next day with smile, Donkey-A carried more load and started running fast. But it was breathtaking for Donkey-B and it couldn't act that way....But the washerman was frustrated, so he harassed Donkey-B terribly, and finally it fell down hopelessly.

Then Donkey-A felt itself as a supremo and happily started carrying more load with great speed.  But now the Load of the Donkey-B is also being carried by Donkey-A., and still it has to run fast.   For some period it did, finally due to fatigue it got tired and started feeling the pain.  But washerman expected more from Donkey-A. It also tried best, but couldn't cope up with his owners demand. The Washerman got angry with Donkey-A also and started harassing to take more load... Donkey-A was crying for long time and then tried its best... But it couldn't meet the owner's satisfaction.  Finally the day came when due to frustration the washerman killed Donkey-A and went for searching some other Donkeys.

Its an endless story..........

But the moral of the Story in Corporate and social life is......,

"Think all colleagues are same and that everyone is capable.... Always Share the Load equally..... Don't ever act smart in front of your Boss and never try for getting over-credit...

It doesn't matter if you are 'A' or 'B'

For the Boss you shall be always DONKEY.

 

How Can I Ask Telemarketers To Stop Calling

Telemarketers can be quite a pain at times. However, if you have always wanted to avoid such phone calls but never knew what to say or do, read on. In this article, we tell you how to get telemarketers to stop calling.

 

How Can I Stop Telemarketers to Stop Calling

 

·         If available, it is always advisable to check the caller ID. If it is some number which you do not recognize, then it might be a telemarketer. But, on the contrary it can be your friend or family member who might be calling from another phone, so be cautious about it.

·         Another way of avoiding such calls is after answering the phone, if you feel that you do not know the person on the other side of the phone, say a simple sorry and hang up. You can also say something like - "Sorry, but I do not accept telephone solicitations at this number."

·         Make sure you find out the name of the company that the marketer is calling from. Some of the telemarketers will just give you their name when asked who is calling. If the caller acts smart, simply ask which organization he/ she is calling from.

·         After you have successfully got the name of the organization, request immediately that you be placed on the particular company's ‘Do not call list’.

·         Jot down or save the number of the company that had called you. This will remind you that you have already asked the company to stop calling you if they call you again.

·         Simply hang up! Yes, this is rude, but sometimes you need to be a little rude to make them understand. 

 

Tips 

 

·         If you do not have any interest in the product they are trying to sell, say so directly instead of wasting anyone's time.

·         Be fast and precise to ask them to add you in their 'Do not call' list. Some marketers are pretty clever and will hang up as soon as they sense what you are trying to say.

·         Simply saying something like - "No, thank you, I would not like to buy the product" will work sometimes but be firm in whatever you say.

·         If you have voice message activated, then, perhaps you can record something like - "If you are a telemarketer or a business organization trying to sell anything, please put me on your 'Do not call' list. Thank you."

·         Lastly, try not to make personal attacks on anyone. Please remember, that those telemarketers are people too who are trying to make a living like you.