Blog Archive

​ Rules for Happiness



1. Do not expect anything from anyone.

2. Let go – Do not hold on to any issue.

3. Forget everything Old – Forget the Past – Past is Past

4. Forgive all people unconditionally.

5. Do not try to change others – Let it be. Accept them as they are.

6. Accept Situations, Relations and Work as they are, if you cannot change them.

7. Do not compare yourself with those who are more 'fortunate' than you are – Be contented.

8. Always be positive in all situations.

9. Have no regrets for anything that has happened, just learn the lesson that was required.

​​


10. Enjoy each moment of life – Life is Very Very Beautiful.

11. Love all – Life is Very Short.

Desires are Trapping You

​​


Staying Peaceful

Desires cause peace to disappear. You think that acquiring things will make you feel secure, but the reality is that the more you have the more fear there usually is of losing it, and the further you are from peace. Desires are the cause of all conflicts. When you want something and cannot get it you become frustrated.
Learning to be free from desires is learning how to stay peaceful

8 Effective Cold Prevention Strategies




1. Wash your hands - The world we live in is filled with viruses and bacteria that can make us ill. Your hands are no exceptions. Wash your hands often to keep them clean. If you cannot wash them, at least use some hand sanitizer, such as Purel.

2. Drink hot fluids, especially in the morning - The rhinovirus incubates in the back of the throat and spreads in the upper respiratory area because it's cooler than the body temperature. Rhinovirus can't survive at 98.6 (hence it doesn't travel far down into the bronchi or the lungs). By drinking hot fluid (such as hot tea and lemon) you can prevent the virus from incubating.

3. Keep your hands out of your face - We have already discussed the germs and viruses on your hands. You cannot wash them continuously, so in between washings keep your hands out of your face. Your face is an open portal to your insides. Keep the germs away from your portal.

4. Drink water - Drinking more water is my answer to everything. Water will help clean out your body and keep it clean. It will also keep your body functioning at 100%. You should drink at least (eight) 8oz glasses of water everyday. This will also help you lose weight.

5. Eat your fruits and vegetables - There are phytochemicals and antioxidants in fruits and vegetables that can help strengthen your immune system and prevent diseases. You should eat at least four servings of vegetables and two servings of fruits every day.

6. Multivitamins - If you are not eating all of your fruit and vegetable servings, you should take a multivitamin to ensure you are getting all of the vitamins your body needs to function properly. Take a simple one-a-day multivitamin everyday.

7. Stay warm - Being cold weakens your immune system and makes your body more susceptible to illness. Look at the day's temperature at weather.com before leaving your home. Wear layers in and out of your home when it is cold.

8. Relax and rest - Stress weakens your immune system. You can reduce your stress levels by relaxing and getting more sleep. Sleep is essential to maintaining a healthy immune system. Sleep will also boost your recovery time if you become ill.

Getting a cold can derail your nutrition and activity plans. However, if you follow the strategies I laid out for you, you can prevent this from happening.

Is Your Boss Pushing You to Your Limit?


Image credit: Rocky | United Artists


Helping someone truly transform takes a huge amount of effort from a teacher. Because of this, truly great teachers are unwilling to teach everyone, because you can't hope to reach everyone. Not everyone has the work ethic and hunger to deserve that type of effort and hard work. It takes an enormous amount of energy and personal sacrifice for a good leader to help someone transform themselves into something new. 
I always tell people when they have a boss pushing them or hounding them to not worry -- that boss probably cares about you improving and progressing. You should start worrying when your boss stops. When someone stops putting an effort into your progress, they may have given up on you. 
I've seen this happen both ways while running my company. I've helped people transform who didn't have the will out of necessity, and I've helped people who did have the will and wanted it more than anything. It's a demanding process. In both cases, I think the individuals resented me to varying degrees, and that was okay. I wasn't in it for them to thank me. I was in it to create an end product. While they may have not have completely understood at first why I was doing what I was doing, in most cases, I believe they came to an appreciation of how I was helping them. 
To me, there is nothing more extraordinary than a human being changed at his or her core. Most people go through life and never change fundamentally. They don't change -- because it's hard. Ninety-nine percent of people are driven by emotions, instincts, desires, lusts and hungers. An individual who wants to change must rise above, recognize himself or herself for who they are, make a conscious decision in every moment to face these things and choose to be different. 
Making a choice to be different in every moment is the great challenge that anyone who has risen to the top of their field or had great success must recognize and conquer. 
Here are five things a great boss who cares will do that you might resent him or her for:

1. A good leader will demand excellence.

For too many, mediocrity is okay. Most bosses or leaders will sell you short. They will say that's as good as they can do, because they don't care enough to demand your best. It's just easier to except you as you are. The boss who demands more of you is the boss who is doing you a favor. He's the boss who sees your potential and is willing to put the energy into you, to see you evolve. 

2. A good leader will push you to the edge.

A great boss or leader will push you to the breaking point. You might think they are pushing you too far. However, if they really care about you and believe in you, they will push you past where you think you can be -- but not so far that you break. A great leader knows that it's at the edges where real progress is made. When you have gone further than you thought you could and get close to your breaking point, that's where greatness is discovered. 
Related: How Successful People Overcome Toxic Bosses

3. A good leader will tell you the truth.

Most people don't want to hear the truth. They are just fine where they are. They do not want to disrupt the status quo. People often ask me for advice on business. Most of the time, I decline. The reason is that most people don't want to hear the truth. Most people just want you to reassure them that what they are doing is good. The truth does not always reassure. Sometimes it can hit you hard, like a punch to the face. But the boss who is honest with you is the boss who will make you better.

4. A good leader will yell at you. 

Sometimes leaders are tough -- even jerks -- but it's always for a valid reason. Do not sell yourself short by being lazy and not appreciating what they are trying to do for you. Sometimes to get your attention, a boss may yell. If that's what it takes to get you back on track, so be it. Would you rather they say something important in a way that is nice but doesn't get your attention -- and then you miss it?

5. A good leader will compliment you only when you deserve it.

A good boss is not there to hand out participation trophies. They want you to learn what it means to accomplish something and receive legitimate praise based on an actual accomplishment. It's a great feeling and way different than an empty pat on the back. If they praise you for something undeserving, they will gradually lose your respect. It's important in the process to not only to be fair with criticisms and challenges but also be fair with praise. A boss is there to measure your progress. The feedback they give will help you gauge progress and build confidence. 
The next time your boss is pushing you hard and you don't understand why, just remember -- they might be trying to take you to a place you didn't think you were capable of reaching.

8 Ways To Make A Difference In The World




Steps In The Right Direction

1. Everything - people, places, and situations - has something to say. Really listening, without interrupting or letting your attention wander, is the simplest way to learn and understand the needs of other people and of the world.

2. Volunteer your time or donate your money to a cause that touches your heart. Read to an elderly patient or buy new books for a veterans' home. Work at a soup kitchen or send a gift of food. No matter how big or small, your contribution will positively affect many people.

3. Embrace nature and beautify the world for others. To lift people's spirit, keep your garden bright, or plant and maintain flowers in a public area. Plant and donate a tree in somebody's name in your local park. As a gift to wild animals, make your yard animal friendly with dense hedges and by using natural pesticides.

4. Your energy affects others so choose to be a beacon of light. Project goodness, happiness, and peace outward through your home, neighborhood, country, and, finally the world. The effects are felt for thousands of miles.

5. Smile and the world smiles with you. When you catch a stranger's eye, flash a bright smile, even if you aren't feeling quite that happy. Your stranger may be confused, but their day (and yours) will be brighter.

6. Animals feel a lack of love as acutely as humans. Adopt a pet from your local shelter rather than purchasing one from a pet store. If your life can't include a pet, spend an afternoon volunteering at the animal shelter giving the animals some much-needed love.

7. Help improve someone's self-esteem or simply show them you care. Give a compliment, send a friendly letter, or tell someone you were thinking about them. Make an effort to keep in touch with long-time acquaintances and to develop new friendships.

8. Be a role model. Rather than asking others to alter themselves, change your own outlook and behavior. A role model can be a source of inspiration, hope, and self-respect. Or actively take on the responsibilities of a role model and reach out to children in need of guidance or an adult in need of a friend.

Story: The Lady and the 4 Turtles



Every Sunday morning I take a light jog around a park near my home.  There's a lake located in one corner of the park.  Each time I jog by this lake, I see the same elderly woman sitting at the water's edge with a small metal cage sitting beside her.

This past Sunday my curiosity got the best of me, so I stopped jogging and walked over to her.  As I got closer, I realized that the metal cage was in fact a small trap.  There were three turtles, unharmed, slowly walking around the base of the trap.  She had a fourth turtle in her lap that she was carefully scrubbing with a spongy brush.

"Hello," I said.  "I see you here every Sunday morning.  If you don't mind my nosiness, I'd love to know what you're doing with these turtles."

She smiled.  "I'm cleaning off their shells," she replied.  "Anything on a turtle's shell, like algae or scum, reduces the turtle's ability to absorb heat and impedes its ability to swim.  It can also corrode and weaken the shell over time."
"Wow!  That's really nice of you!" I exclaimed.

She went on: "I spend a couple of hours each Sunday morning, relaxing by this lake and helping these little guys out.  It's my own strange way of making a difference."

"But don't most freshwater turtles live their whole lives with algae and scum hanging from their shells?" I asked.
"Yep, sadly, they do," she replied.

I scratched my head.  "Well then, don't you think your time could be better spent?  I mean, I think your efforts are kind and all, but there are fresh water turtles living in lakes all around the world.  And 99% of these turtles don't have kind people like you to help them clean off their shells.  So, no offense… but how exactly are your localized efforts here truly making a difference?"

The woman giggled aloud.  She then looked down at the turtle in her lap, scrubbed off the last piece of algae from its shell, and said, "Sweetie, if this little guy could talk, he'd tell you I just made all the difference in the world."

The moral:  You can change the world – maybe not all at once, but one person, one animal, and one good deed at a time.  Wake up every morning and pretend like what you do makes a difference.  It does.  


Story: The Mountain Principle
Story - Correct it or Prevent it - The Choice is Yours
Story – the Positive Power
Story – The WOW approach
Story – The Monkey and the Wooden Apple
Story - Knowing where to tap
Story - Glass, Lake and Salt
Story - Socrates - Triple Filter
Story - A story you may like

The Hidden Cost of Antibiotic Drugs in Fast Food

What You Don't Know Can Hurt You

The hidden cost of antibiotic drugs in fast food
The United States' food report card is in, and it's not good.
In the first comprehensive report of its kind, 80% of surveyed fast food and fast casual restaurants received an "F" for their sourcing practices and antibiotics usage.
Only 5 major chains received a "C" or above.



Source: Bestmedicaldegrees.com 

Seven Habits of Highly Ineffective People



  
  By Vijai P. Sharma, Ph.D

Yes, you read it right.  It's not a misprint.  In this article, I will discuss the seven habits of highly ineffective people.  It is as important to know about the habits that can make us ineffective as it is to know the ones that make us effective.  

The credit for identifying the seven habits of ineffective people goes to John Covey, the brother of Steven Covey who is the celebrated author of the book, Seven Habits of Highly Effective People.  Incidentally, I smell some sibling rivalry there, don't you?

At any rate, the
​​
first habit that really holds the master key to the treasury of failures is, "Be reactive.  Always doubt yourself and blame others."   By being reactive you don't have to take a preventive action, entertain a forethought or plan for anything in advance.  You can avoid decisions forever by continuing to doubt yourself.  If you don't take a decision in the first place, how can you blame yourself.  This way, you also reserve the right to blame others for the inconveniences and difficulties.  

The
​​
second habit is to "work without any clear end in mind."  Then whichever way it ends, look at it philosophically, "That's the way things sometimes happen. "  The fact that the outcome didn't turn out to be so great is nobody's fault and certainly not yours.  

The
​​
third habit is to "do only what is urgent."  You will have the satisfaction of doing the urgent thing while avoiding crises until things catch up with you.  

The
​​
fourth habit is to think in win/lose terms, that is, "I should win and they should lose" as the basic orientation to all negotiations and collaborations.  Sometime, this may offer you a big ego trip and when you lose, you may even get some sympathy.

The
​​
fifth habit is to "seek first to be understood."  Don't try to understand them until they understand you and that way you can be even with them.

The
​​
sixth habit is to follow the dictum, "If you can't win, compromise."  This will help you to secretly admire yourself for being so adaptable and having "one up on them."

The
​​
seventh habit is to "fear change and put off improvement."  When you spend all your energy in maintaining the status quo, many of your coworkers will become your bosom buddies.    

Foster these seven habits and you shall rank very highly among the highly ineffective people.  
 

Peace is simplicity. Simplicity is beauty


Choose a day as your day of simplicity.

Speak little, and listen with attention. Do something incognito and nice for a person you are close to. Eat simple and natural food.
Create time periods for not doing anything - just walk, look around, live the moment. Have your mind open to a more profound and silent sensitivity.
Appreciate each scene and each person as they are.

​ 7 Sentences That Will Change Your Life

​​tumblr_m90e18qPXC1qz6f9yo1_500
​​The power of words, a single sentence can ruin someone's life, so what can it do to improve one's life? 

Words can move you to make change, and they can inspire you to inspire others. Like a virus, it's beautiful in its own simplicity – but complex in its far reaching effects on the human condition.

1. "You learn more from failure than from success; don't let it stop you. Failure builds character."

2. "Remembering that you are going to die is the best way to avoid the trap of thinking you have something to lose. Nothing in life is permanent. There is no reason not to follow your heart."

3. "The most dangerous risk of all – The risk of spending your life not doing what you want on the bet you can buy yourself the freedom to do it later"

4. "Be a yardstick of quality. Some people aren't used to an environment where excellence is expected."

5. "Everyone you meet is afraid of something, loves something, and has lost something"

6. "I like thinking big. If you're going to be thinking anything, you might as well think big."

7. "Remember that happiness is a way of travel, not a destination."​

HEALTH: 10 Things to keep in mind if you have acid reflux problem




Gastroesophageal reflux disease (GERD) is basically a lifestyle malfunction and can definitely be prevented. You might have acid reflux problem if you get heartburn at the night and wake up the next morning with chr
onic cough, bitterness in the mouth, sore throat and fatigue. This usually happens because of what we eat and drink. So prevention and cure also depend on what goes inside us.
10 things to keep in mind when you have acid reflux problem:
1. Limit your intake of acidic foods: This would include tomatoes, vinegar, oranges, grapefruit, etc.
2. Say no to spicy food: Lower the amount of your consumption of spicy foods. These tend to give heartburns.
3. Don't head to bed post meal: After you have had your meal, avoid lying down. Digestion is quicker and better when you are sitting upright
4. Avoid greasy food: Non-fatty food and lean meat are good to go.
5. Have lesser sour foods: Cut down your excessive consumption of mustard, mint, citrus, vinegar, chocolates, pepper, and tomatoes.
6. Avoid carbonated drinks and alcohol: They tend to trigger reflux.
7. Avoid smoking.
8. Avoid tight clothing: Don't wear snug or tight clothes, go to bed wearing comfortable clothes.
9. Stick to gluten-free diet: A protein that is found in barley, rye, wheat etc might also trigger the symptoms of GERD.
10. Get professional help: Consult a doctor and then take action accordingly. If you are on medication, get yourself checked from time to time. Do not stop taking the medicine that has been prescribed by your doctor, suddenly.​

Here are 7 habits of highly stressed people (and how to avoid them)



1. Drinking excessive amounts of caffeinated beverages

We hear conflicting reports all the time about coffee – some people say we should avoid it like the plague, and other researchers seem to think it's practically the elixir of life. Most people would never dream of giving up coffee, but drinking it excessively can negatively affect your health. Since caffeine is a stimulant, drinking too much of it can make you feel overly anxious and contribute to insomnia, irritability, and digestive issues. Try to limit your intake of caffeinated beverages to 400mg per day, as this amount seems safe for most adults, according to the Mayo Clinic.

2. Seeing the negative in everything

If you always see the glass half-empty, you probably have a high level of stress. Pessimistic people tend to dwell on problems, and this fixation on negativity can really ramp up your stress level.
When the world starts to look dark and depressing, remember to take a step back, breathe, and feel grateful for everything and everyone in your life. Putting things into perspective can really help you find the beauty in life, even in adverse situations.

3. Obsessing over every detail of their lives

Highly stressed people tend to have a Type A personality, wanting to control every aspect of their lives, and work hard to ensure that every little hair falls perfectly into place. However, this obsessive behavior can lead to unnecessary stress and anxiety, and make you unable to adapt to new situations. Remember that you can't control everything, so don't try.
Only focus on things that you can change, and let the rest of the issues work themselves out.

4. Expecting perfection

As an extension of the last point, counting on perfection usually leaves us sorely disappointed. Perfection doesn't exist, and trying to live within these parameters will surely leave you chronically stressed, unhappy, and bitter. Having unrealistic expectations of people and life in general doesn't normally end well, because mistakes happen. The sooner you can accept this, the less stressed and anxious you will feel.
Related article: 5 Reasons to Stop Chasing Perfection
Instead of attempting to control everything and set impossible standards for yourself and others, simply do the best you can, accept everyone else's best effort, and choose to see the beauty in the imperfections.

5. Eating their feelings

Stress eating has practically become an epidemic, as people use food to deal with negative emotions. However, there's a scientific reason behind why people choose to eat unhealthy foods to cope with stress. According to Harvard Health Publications at Harvard Medical School, our bodies release cortisol when we feel stressed, which can ramp up our appetite and lead us to make unhealthy choices. Not surprisingly, most people choose foods heavy in fats and sugars, which inevitably lead to weight gain if eaten in excess.
If you feel overly stressed, try to get to the root cause of the stress first, instead of reaching for unhealthy foods out of habit. The foods may seem comforting, but they only mask the real problem.

6. Overworking themselves

Work stress is also another growing problem, with 8 in 10 Americans stressed about their jobs, according to the third annual Work Stress Survey by Harris Interactive. Poor pay and increasing work hours topped the list of concerns for those surveyed, which should make us really think about our chosen place of employment.
If you work at a job you don't enjoy, plus you have to work long hours, you might think about getting a different job that suits your interests more and offers better work-life balance. On the other hand, if you actually like your job, but still work long hours, you should talk to your boss about cutting back your hours, or have a conversation with yourself if you can't seem to pull yourself away from work at a reasonable hour.

7. Thinking too much

Above all else, this one might take the cake for reasons why people feel stressed. Our world runs on thinking; in our jobs, our home lives, at school, and pretty much everything else. We have to think in order to get virtually everything accomplished, but overthinking can lead to alot of issues later on. Our thoughts become things, they become reality, so we must take care of them if we want to lead a happy, fulfilling life.
Related article: How to Stop Overthinking

The Frog in Water


Put a frog in a vessel of water and start heating the water.

As the temperature of the water rises, the frog is able to adjust its body temperature accordingly.

The frog keeps on adjusting with increase in temperature...

Just when the water is about to reach boiling point, the frog is not able to adjust anymore...

At that point the frog decides to jump out...

The frog tries to jump but is unable to do so, because it has lost all its strength in adjusting with the rising water temperature...

Very soon the frog dies.

What killed the frog?

Many of us would say the boiling water...

But the truth is what killed the frog was its own inability to decide when it had to jump out.

We all need to adjust with people and situations, but we need to be sure when we need to adjust and when we need to confront/face.

There are times when we need to face the situation and take the appropriate action...

If we allow people to exploit us physically, mentally, emotionally or financially, they will continue to do so...

We have to decide when to jump.

Let us jump while we still have the strength.

Think on It !!
I love this message every time I read...👌

Be Careful While shopping


​​
Not sure if this is true or false, posting this in the interest of humanity to be vigilant, not only for the city mentioned in the below story, but also everywhere we shop.
An Indian was detained in Bangkok for stealing a box of cigarettes in a duty-free shop in Bangkok International Airport .
He had paid for chocolates and a carton of cigarettes. The cashier put a packet of cigarettes extra into his bag and he thought it was a free pack.

He was arrested for shop-lifting and the Thai Police extortion price was 30,000 Baht for his release.

He spent two nights in jail and paid 500 Baht for an air-conditioned cell, 200-300 baht for each visitor and

​​
11,000 baht for his final release.

The Police shared the money in front of his eyes. On top of that, he was charged in court and fined 2,000 baht by the magistrate and handcuffed and escorted to his plane.

His passport was stamped "Thief". While there, his relatives requested help from the Indian Embassy and was told that they are helpless, many Asians are victimized similarly daily and letters and phone-calls to the Thai authorities are ignored.
He shared a cell with a Singaporean the first night who paid 60,000 baht for his release. The second night was a Malaysian national who paid 70,000 baht.


Mind you this was not in a shanty shop in downtown Bangkok but in a duty free shop at the Bangkok Int'l Airport . BE WARNED.
The above is 100% correct information because Mr Rajan Khera's customer from India faced exactly the same scenario mentioned above when he was in transit at Bangkok Int'l Airport coming to Taipei.

​​

Why Doesn't Anyone Ever Feel Rich? (Or Even Happy)?


One day I'd like to meet someone who is actually rich. Sometimes I think I've found one but it always turns out I'm wrong. No matter how rich I assumed the person to be... within a few minutes I find out just how "poor" that person really is.
Take the guy who sold his company for more than $40 million. (Well, actually $100 million in total; $40 million is his share.) I was sure he was rich.
Then he told me how for tax and estate planning purposes he had structured the disbursement of funds over 10 years. So sure, on paper he may be "worth" $40 million, but he only gets around $4 million each year. And despite all that nifty financial planning the taxes are still so high he doesn't see nearly that much. It's a bummer.
Or take the guy who just splashed a cool $450 grand on a Lexus LFA with the Nürburgring package. His everyday car is a Porsche 911 Turbo S. I was sure hewas rich.
Then he told me what he wants most in life is a Bugatti Veyron only they cost about $2 million. Sure, he has money, he said, but he doesn't have that kind of money. He thinks about it all the time. It's a bummer.
Or take the guy with the 110-foot yacht. Strictly speaking it's a ship, not a boat, since it's big enough to carry several small boats and a couple of jet skis on a platform at the stern. And it has a pool. I was sure he was rich.
Then he told me how expensive the yacht is just to own: fixed costs like cleaning, upkeep, berth, and crew run over six figures a yearAnd what about the expense of actually taking it for a cruise? He told me firing it up is so expensive he sometimes has to think twice about whether to take it out of the harbor. It's a bummer.
Or take the guy who -- I know it's a cliché, but it's still true -- started a company in his garage, financing it with credit cards and a loan from his father-in-law. A couple decades later his company owns its building (and a few more), employs 500 people, and generates tens of millions in annual revenue. And he put his three kids through Ivy League schools and then gave them significant seed money to start their own businesses. I was sure he was rich.
Then he explained how he still has to work 60- to 70-hour weeks and can maybe take one week of vacation a year. Sure, he would like to have more free time, but running a company that size requires constant and total attention. Why, it could all go away in an instant, he said. And then what would happen to his family? The very thought makes him shudder. It's a bummer.
So I decided to set my sights on a different target. By definition there can't be that many rich people; maybe statistical probability was the problem? So I decided to look for someone who is happy. After all, not everyone can be rich... but anyone can be happy.
I thought I found one when I met an entrepreneur who had just landed her first big customer. Not just a big customer, a truly enabling customer, one who made it possible for her to hire much-needed employees, make long-delayed equipment purchases, and finally get creditors off her back. I figured that surely made her feel happy.
Then she told me how much she hates to recruit and interview … and then actually having to supervise those employees on a daily basis? Ugh. She told me how adding equipment, maintaining a larger inventory, and managing the huge increase in production was such a pain. Don't get her wrong, she told me as she looked around to make sure no one overheard, but she often longs for the good old days when life was a lot simpler. It's kind of a bummer.
Or take the guy who, after years of putting out feelers and constant hints, was finally invited to serve on the board of a startup. The company has potential, he said, but it's not Twitter. Or Facebook. Or even Fancy. Now serving on one of those boards would be cool. This? He thought it would be fun, but it's kind of a bummer.
The guy who just bought a bigger house? Bummed because it takes so much work to clean. The guy who just doubled his income? Bummed because now his taxes are higher. The gal who just landed her dream job? Bummed because now her daily commute is half an hour longer.
Seems no one I meet, no matter how much money or success they've achieved, is actually rich. Not really. And although I'm stretching the premise to make a point, it seems no one I meet, no matter how fulfilling and gratifying their life might be, is actually happy. Not really.
But that's okay. I'll keep looking. Someday I might find someone.
And hopefully that someone is you. 
Source: linkedin

Split Text into Multiple Cells in Excel



How to split text from one cell into multiple cells quickly and easily in Excel.  This includes how to split names, part numbers, really anything you want.  You can split the text based on spaces in the text, commas, periods, or anything you specify.
We will use the Text to Columns feature to do this.

Desired Result:


Steps to Split Text into Multiple Cells

  1. Select the text or entire column of text that you want to split into multiple cells:
  2. Go to the Data tab and click the Text to Columns button:
  3. In the screen that opens up select either Delimited or Fixed width.Delimited means that there is a space or comma or something that you can use to separate the text; the delimiter will be used to determine how to break the text up into multiple cells.  Fixed width means that you will select the break-points where the text in all of the cells will be split.  Usually, you will want to select Delimited.

    Once you have made your choice hit the Next button.
  4. On this screen, you will choose what you want to use as the delimiter.  Since a space is what separates our text into distinctive pieces, I choose the Space option.  Choose whichever option you need or select Other and type in the delimiter that is used for your data.

    You will notice at the bottom of this screen a small preview window.  This will show you how the text will be split based on the delimiter that you selected.  If this does not look right, choose another delimiter until it does look right.
    When finished here, hit the Next button.
  5. Here, you can choose the format for the new data.  You simply select the desired column at the bottom of the window and then change its format in the top left section for Column data format.

    You can also change the destination for the new data in the Destination box.  If you choose another location, the original data will be retained; otherwise, the original data will be overwritten.
    When you are finished here, hit the Finish button.
  6. Here is the result:

    If I changed the destination in step 5, we would retain the original data and it would look like this:

Notes

At any time in the steps above, you can click the Finish button and skip the other steps.  If you do this, Excel will guess the other steps for you.  Often Excel will get the results correct if you do this, but I would not always count on this to work if you have a new data set with which you have not previously worked.
Make sure to download the sample spreadsheet that accompanies this tutorial and try out this feature.
teachexcel


16 Funny Quotes to Start Your Next Business Presentation

​                                

John Brandon is a contributing editor at Inc. magazine covering technology. He writes the Tech Report column for Inc.com.
Contributing editor, Inc.com@jmbrandonbb
2 COMMENTS

IMAGE:
Advertisement
Scrambling to create a business presentation? Here's a tip. Start with a slide showing a series of funny quotes just to warm up the room. It makes people realize your talk is not going to be a total borefest and you plan to keep things lively. Here are my favorite quips that you can borrow--just cut and paste the ones you like into your slides.
1. "Big business never pays a nickel in taxes, according to Ralph Nader, who represents a big consumer organization that never pays a nickel in taxes." Dave Barry
2. "Eagles soar, but weasels don't get sucked into jet engines." Steven Wright
3. "I don't want yes-men around me. I want everyone to tell the truth, even if it costs them their jobs." Samuel Goldwyn
4. "Right now, this is a job. If I advance any higher, this would be my career. And if this were my career, I'd have to throw myself in front of a train." Jim Halpert, The Office
5. "It's much easier for me to make major life, multimillion-dollar decisions than it is to decide on a carpet for my front porch. That's the truth." Oprah Winfrey
6. "Success in almost any field depends more on energy and drive than it does on intelligence. This explains why we have so many stupid leaders." Sloan Wilson
7. "The light at the end of the tunnel has been turned off due to budget cuts." Anonymous
8. "The best way to appreciate your job is to imagine yourself without one." Oscar Wilde
9. "Few great men would have got past personnel." Paul Goodman
10. "The key to being a good manager is keeping the people who hate you away from those who are still undecided." Casey Stengel
11. "The most ineffective workers are systematically moved to the place where they can do the least damage: management." Scott Adams (Dilbert)
12. "Every time you feel yourself being pulled into other people's drama, repeat these word: Not my circus, not my monkeys." Polish Proverb
13. "My boss doesn't believe that money equals happiness. So instead of raises, he gives us Prozac.(depression medicine)" JokeQuote.com
14. "Being powerful is like being a lady. If you have to tell people you are, you aren't." Margaret Thatcher
15. "Only one man in a thousand is a leader of men--the other 999 follow women." Groucho Marx
16. "If I had asked people what they wanted, they would have said faster horses." Attributed to Henry Ford
-funny-quotes-to-start-your-next-business-presentation.html

Excel: Using conditional formatting to highlight dates



 


Share
Share on FacebookShare on TwitterShare on LinkedinShare via OneNoteShare via EmailPrint
This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen, with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. 
Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. The NOW function, which calculates values based on the current date and time, is a great example of this.
Taking this functionality a step further, when you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiates between types of days, like weekends and weekdays.

The basics of conditional formatting for dates

To find conditional formatting for dates, go to
Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring.

You can select the following date options, ranging from yesterday to next month:

These 10 date options generate rules based on the current date. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule.
Below are step-by-step instructions for a few of my favorite conditional formats for dates.

Highlighting weekends

When you design an automated calendar you don't need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function.  Assume that you have the date table–a calendar without conditional formatting:

To change the color of the weekends, open the menu Conditional Formatting > New Rule

In the next dialog box, select the menu Use a formula to determine which cell to format.

In the text box Format values where this formula is true, enter the following WEEKDAY formula to determine whether the cell is a Saturday (6) or Sunday (7):
=WEEKDAY(B$5,2)>5
The parameter 2 means Saturday = 6 and Sunday = 7. This parameter is very useful to test for weekends.

Note: In this case, you must lock the reference of the row so that the conditional format will work correctly in the other cells in this table.
Then, customize the format of your condition by clicking on the Format button and you choose a fill color (orange in this example).

Click OK, then open Conditional Formatting> Manage Rules

Select This Worksheet to see the worksheet rules instead of the default selection. In Applies to, change the range that corresponds to your initial selection when creating your rules to extend it to the whole column.

Now you will see a different color for the weekends. Note: This example shows the result in the Excel Web App.

Highlighting holidays

To enrich the previous workbook, you could also color-code holidays. To do that, you need a column with the holidays you'd like to highlight in your workbook (but not necessarily in the same sheet). In our example, we have US public holidays in column AH (as related to the year in the cell B2).

Again, open the menu Conditional Formatting > New Rule. In this case, we use the formula COUNTIF in order to count if the number of public holidays in the current month is greater than 1.
=COUNTIF($AH$4:$AH$16,B$5)>1
Then, in the dialog box Manage Rules, select the range B4:AF11. If you want to highlight the holidays over the weekends, you move the public holiday rule to the top of the list.

This example in the Excel Web App below shows the result. Change the value of the month and the year to see how the calendar has a different format.

Highlighting delays

In case we want to change the color of cells based on our approach on a date again, we will use conditional formatting to make it work for us.
In the following example, we show:
  • yellow dates between 1 and 2 months
  • orange dates between 2 and 3 months
  • purple dates more than 3 months
We then construct three rules conditional formatting using formula DATEDIF . Respectively for the three cases the following formulas:
=DATEDIF($B2,$E$2,"m")>0
=DATEDIF($B2,$E$2,"m")>1
=DATEDIF($B2,$E$2,"m")>2

In the Excel Web App below, try changing some dates to experiment with the result.

Color scales

Rather than choose a different color set for each period in our timeframe, we will work with the option of color scales to color our cells.
First, go into a new column (column E), calculate the difference in number of days in a year again with the DATEDIF formula and the parameter "yd".
=DATEDIF($D2,TODAY(),"yd")
Then choose the menu Conditional Formatting> New Rule option Format all cells based on their value and choose the following options:
    • Scale = 3 colors
    • Minimum = 0 red
    • Midpoint = 10 yellow
    • Maximum = 30 white

The result is a gradient color scale with nuances from white to red through yellow.  The closer to 0, the more red it will have, the closer to 10 the more yellow, and the closer to 30 the more white.  In the Excel Web App below, try changing some dates to experiment with the result.
Frédéric Le Guen
using-conditional-formatting-to-highlight-dates-in-excel/

Microsoft Outlook: How to Create Tasks and Set Reminders & Follow Up


Create tasks and to-do items

Many people keep a list of things to do — on paper, in a spreadsheet, or by using a combination of paper and electronic methods. In Microsoft Office Outlook 2007 you can combine your various lists into one list, enhanced with reminders and tracking.

In this article

About tasks and to-do items

Create a task from the File menu

Create a task or a to-do item from an e-mail message

Create a to-do item from a contact

Create a task in the To-Do Bar

Create a task in the Daily Task List in Calendar

About tasks and to-do items

To-Do Bar A task is an item that you create in Outlook to track until its completion. A to-do item is any Outlook item — such as a task, an e-mail message, or a contact — that has been flagged for follow-up. By default, all tasks are flagged for follow-up when they are created, even if they have no start date or due date. Therefore, whenever you create a task, or flag an e-mail message or a contact, a to-do item is created automatically.

When you need to quickly indicate that an item requires your attention at a later time, flagging is the best option. When you flag an item, it is displayed with a flag in the Mail view, in Tasks, in the To-Do Bar, and in the Daily Task List in Calendar. Flagging a message or contact does not create a new task. Because the to-do item is still an e-mail message or contact after being flagged, you do not have the ability to assign it as a task to someone else, or indicate its progress or percentage of completeness.

A task can occur once or repeatedly. A recurring task can repeat at regular intervals, or it can repeat based on the date that you mark the task complete. For example, you can create a recurring task to send a status report to your manager on the last Friday of every month, or create a recurring task to get a haircut one month after your last one.

Both tasks and to-do items appear in Tasks, in the To-Do-Bar, and in the Daily Task List in Calendar. No matter which view you are in, the To-Do Bar keeps you informed of your calendar, task, and to-do items.

There are several ways to create a new task in Outlook. You can use the Task command (click New on the File menu), enter a task in the Type a new task text box in the To-Do Bar from any view in Outlook, type in any blank space in the Daily Task List in Calendar, or click and type in the Click here to add a new Task text box at the top of Tasks view. Of these, the fastest way is to use the To-Do Bar.

You can also create a task by dragging an item, such as an e-mail message, to Tasks in the Navigation Pane. A copy of the e-mail message is then created as a task.

Whether you track tasks that are assigned to yourself (such as reminders to respond to e-mail messages), or track tasks that are assigned to other people (such as the progress of someone's project), Outlook tasks are your solution. You can quickly add and update tasks, or mark them as complete. With tasks incorporated into the Calendar view, you have a rich interface for keeping track not only of your appointments, but of the tasks that you need to complete on a given day as well.

Top of Page

Create a task from the File menu

  1. On the File menu, point to New, and then click Task.

    Keyboard shortcut  To create a new task, press CTRL+SHIFT+K.

  2. In the Subject box, type a name for the task.

    Note   You have now entered enough information to create a task. The following steps are optional, but will help you better manage your tasks in Outlook.

  3. On the Task tab, in the Actions group, click Save & Close or continue with the following steps to customize your task.

  4. If you want, set the Start date and the Due date for the task.

    If you specify a Start date, the Due date field is automatically set to the same day. You can change the Due date field to any date that you want.

  5. If you want to make the task recur, on the Task tab, in the Options group, click Recurrence.

  6. In the Task Recurrence dialog box, click the frequency (Daily, Weekly, Monthly or Yearly) with which the task should recur, and then do one of the following:

    • Make the task recur based on a regular interval     In the Recurrence pattern section, select the options for the frequency interval that you want. Do not select Regenerate new task, or the task will not recur at regular intervals.

    • Make the task recur based on completion date     Select Regenerate new task, and in the box, type the amount of time after which a new task must be generated.

      Each time that you mark the task complete, a new task will be created based on your specifications.

      Tip   This is your best choice when you do not want the next reminder for a task to appear until the previous one is marked as complete. If you do not mark the item complete, the next reminder will never appear. For example, if you have a reminder to pay your utility bill on the 15th of each month and you do not mark the occurrence on April 15th as complete, in May you will still see the not yet completed April 15th task. Only after you mark the April 15th task as complete does the May 15th occurrence of the task appear.

  7. Click OK to close the Task Recurrence dialog box.

  8. If you want to add a reminder alert, select the Reminder check box, and then enter the date and time for the reminder.

  9. You can specify a custom sound to be played with your reminder. Click Button Image, click Browse, select the sound file to play, click Open, and then click OK. This changes the reminder sound only for this task.

  10. If you want to track your progress on this task, in the Status, Priority, and % Complete boxes, enter the values that you want.

    The Status and % Complete fields are linked. When you change the value in either field, the value in the other field changes accordingly.

Status

% Complete

Not Started

0

In Progress

1-99

Completed

100

Waiting on someone else   

0-100

Deferred

0-100

  1. If you want to assign a color category to your task, on the Task tab, in the Options group, click Categorize, and then click one of the color categories on the menu. For more color categories, click All Categories.

    The first time that you use a color category, you are prompted to provide a name for the color category that is more meaningful to you. You can create custom color categories, associate custom colors with the color categories, and assign shortcut keys to the color categories. Click OK to return to the Task window.

    Tip   Changed your mind about a color category assignment? Right-click the color or name of the color category, and then click Clear Name of Category or Clear All Categories.

  2. If your task involves a person or organization in your Contacts, you can create a quick link to the contact, by clicking Contacts at the bottom of the window, and then selecting an entry. Click OK to close the Select Contacts dialog box.

    Note   By default, Contacts linking does not appear on the message, contacts, and tasks windows. To turn on Contact linking, on the Task tab, in the Actions group, click Save & Close. On the main Outlook window, on the Tools menu, click Options. On the Preferences tab, click Contact Options, and then on the Contact Options dialog box under Contact Linking, select the Show Contact Linking on all Forms check box. Open your task to continue with this procedure.

  3. If you do not want other people to see a shared task entry, on the Task tab, in the Options group, click Private.

  4. If you want to enter mileage, work hours, and other billing information, on the Task tab, in the Show group, click Details. Type the information in the Total work, Actual work, Mileage, and Billing information text boxes.

  5. On the Task tab, in the Actions group, click Save and Close.

Top of Page

Create a task or a to-do item from an e-mail message

There are several ways to turn an e-mail message into a task or a to-do item.

Do any of the following:

  • Flag an e-mail message for follow-up

    Flagging a message is the best option when you need to quickly mark an item for your attention at a later time. When you flag an item, it is displayed in the Mail view with a flag, in Tasks, in the To-Do Bar, and in the Daily Task List in Calendar. Flagging a message or contact does not create a new task. Because the to-do item still remains an e-mail message or contact after being flagged, you do not have the ability to assign it as a task to someone else, or indicate its progress or percentage of completeness.

    1. In Mail, right-click the flag column for an e-mail message.

    2. Choose the due date.

      Tip   To add a follow-up flag quickly, click the flag column next to the e-mail message. A start date and due date of today are set automatically.

      Note   To change the reminder time, reminder sound, Start date, Due date, or the flag text that appears in the InfoBar, or to clear the reminder flag, right-click the flag column next to the e-mail message, and then click Custom or Add Reminder. Both options open the same dialog box, but when you use Add Reminder, the reminder check box is selected automatically.

      Follow Up dialog box

  • Drag an e-mail message to the To-Do Bar to create a to-do item

    The To-Do Bar must be arranged by Start Date or Due date to use these procedures.

    1. Click an e-mail message to select it, and then drag the message to the task list section of the To-Do Bar.

    2. When you see a red line with arrows at each end positioned where you want to place the task, release the mouse button.

      to-do bar appointment section screenshot

  • Drag an e-mail message to the Tasks button to create a new task

    When you drag an e-mail message to Tasks in the Navigation Pane, you can use all of the features of a task item, and the contents of the e-mail message, except attachments, are copied to the body of the task. Even if the original e-mail message is later deleted, the task, including the copied contents, except attachments, of the e-mail message, is still available.

    1. Click an e-mail message to select it, and then drag it to the Task button on the Navigation Pane.

      Tip   To add the message as an attachment to the task instead of pasting the text into the task body, right-click the message and drag it to the task list. On the shortcut menu, click Copy Here as Task with Attachment.

      A new task item window appears, and a copy of the e-mail contents is pasted into the task body. The subject of the e-mail message becomes the subject of the task. If you want, you can change the subject.

      Note   You have now entered enough information to create a task. The following steps are optional, but will help you better manage your tasks in Outlook.

    2. On the Task tab, in the Actions group, click Save & Close or continue with the following steps to customize your task.

    3. If you want, set the Start date and the Due date for the task.

      If you specify a Start date, the Due date field is automatically set for the same day. You can change the Due date to a date that you want.

    4. If you want to make the task recur, on the Task tab, in the Options group, click Recurrence.

    5. In the Task Recurrence dialog box, click the frequency (Daily, Weekly, Monthly or Yearly) with which the task should recur, and then do one of the following:

      • Make the task recur at regular intervals     In the Recurrence pattern section, select the options for the frequency interval that you want. Do not select Regenerate new taskor the task will not recur at regular intervals.

      • Make the task recur based on completion date     Select Regenerate new task, and in the box, type the amount of time after which a new task must be generated.

        Each time you mark the task complete, a new task will be created based upon your selections.

        Tip   This is your best choice when you do not want the next reminder for a task to appear until the previous one is marked complete. If you do not mark the item complete, the next reminder will never appear. For example, if you have a reminder to pay your utility bill on the 15th of each month and you do not mark the occurrence on April 15th as complete, in May you will still see the April 15th task. Once you mark the April 15th task complete, the May 15th occurrence of the task will appear.

    6. Click OK to close the Task Recurrence dialog box.

    7. If you want to add a reminder, select the Reminder check box to turn on a reminder alert. Enter the date and time you want for the reminder.

    8. You can specify a custom sound to be played with your reminder. Click Button Image, click Browse, select the sound file to play, click Open, and then click OK. This changes the reminder sound only for this task.

    9. If you want to track your progress on this task, in the Status, Priority, and % Complete boxes type or select the options you want.

      The Status and % Complete fields are dependent on each other. By changing the value in one field, the value in the other field changes accordingly.

Status

% Complete

Not Started

0

In Progress

1-99

Completed

100

Waiting on someone else   

0-100

Deferred

0-100

  1. If you want to assign a color category to your task, on the Task tab, in the Options group, click Categorize, and then click one of the entries from the menu. For more color categories, click All Categories.

    The first time you use a color category, you will be prompted to provide a name that is more meaningful to you. You can create custom color categories, associate custom colors with color categories, and assign shortcut keys. Click OK to return to the Task window.

    Tip   Changed your mind about a color category assignment? Right-click the color or name of the color category, and then click Clear Name of Category or Clear All Categories.

  2. If your task involves a person or organization in your Contacts, you can create a quick link to the contact, by clicking Contacts at the bottom of the window, and then selecting an entry. Click OK to close the Select Contacts dialog box.

  3. If you do not want other people to see a shared task entry, on the Task tab, in the Options group, click Private.

  4. If you want to enter mileage, work hours, and other billing information, on the Task tab, in the Show group, click Details. Type the information in the Total work, Actual work, Mileage, and Billing information text boxes.

  5. On the Task tab, in the Save group, click Save and Close.

Top of Page

Create a to-do item from a contact

Flagging a contact is the best option when you need to quickly mark a contact for your attention at a later time. Flagging a contact creates a to-do item, with the text of the flag in the InfoBar. The flagged contact it is also displayed in the Tasks list, To-Do Bar, and in the Calendar Daily Task List. Flagging a contact does not create a new task item. Because the to-do item still remains a contact, you do not have the ability to assign it as a task to someone else, or to indicate its progress or percentage complete.

  1. In Contacts, right-click the contact.

  2. Point to Follow Up on the shortcut menu, and then click the due date.

    Tip   To change the reminder time, reminder sound, Start date, Due date, or the flag text that appears in the InfoBar, or to clear the reminder flag, click Custom or Add Reminder. (Both options open the same dialog box, but when you use Add Reminder, the reminder check box is selected automatically.)

Top of Page

Create a task in the To-Do Bar

The To-Do Bar appears in all Outlook views by default. You can turn the To-Do Bar on or off. In addition, you can choose to display a minimized version of the To-Do Bar, which uses less screen space. When you turn the To-Do Bar on or off, or minimize it in a specific view, the setting applies only to that view. For example, if you turn off the To-Do Bar in the Mail view, it will remain off each time you are in the Mail view, including the next time you start Outlook. However, it remains on in other views such as Calendar, Notes and Tasks.

  • To toggle the To-Do bar on or off, click View, point to To-Do Bar, and then click Normal, Minimized, or Off.

  • To create a new task in the To-Do Bar, click in the Type a new task text box (called the Task Input Panel, type a subject for the task, and then press ENTER.

    Task Input Panel

    By default, the task will be assigned a due date and a start date that are based upon the flag's Set Quick Click setting. When you first install Outlook, this setting is configured as Today.

    If you create a task and change the flag to another Due date choice, any future tasks that you enter in the To-Do Bar will use the new setting. You can always override the choice that is displayed and pick another option. However, when you restart Outlook, the first task entered will default to the Set Quick Click flag setting.

    Tip   To change the default flag setting, right-click the flag column in any view, click Set Quick Click, and then choose the flag setting that you want. The options include No Date. Choosing the No Date flag makes the item appear in the No Date group in the To-Do Bar.

    Note   You have now entered enough information to create a task. The following steps are optional, but will help you better manage your tasks in Outlook.

  • Continue with the following steps to customize your task by double-clicking the task in the To-Do Bar.

  • If you want, set the Start date and the Due date for the task.

    If you specify a Start date, the Due date field is automatically set for the same day. You can change the Due date to a date that you want.

  • If you want to make the task recur, on the Task tab, in the Options group, click Recurrence.

  • In the Task Recurrence dialog box, click the frequency (Daily, Weekly, Monthly or Yearly) with which the task should recur, and then do one of the following:

    • Make the task recur at regular intervals     In the Recurrence pattern section, select the options for the frequency interval that you want. Do not select Regenerate new taskor the task will not recur at regular intervals.

    • Make the task recur based on completion date     Select Regenerate new task, and in the box, type the amount of time after which a new task must be generated.

      Each time you mark the task complete, a new task will be created based upon your selections.

      Tip   This is your best choice when you do not want the next reminder for a task to appear until the previous one is marked complete. If you do not mark the item complete, the next reminder will never appear. For example, if you have a reminder to pay your utility bill on the 15th of each month and you do not mark the occurrence on April 15th as complete, in May you will still see the April 15th task. Once you mark the April 15th task complete, the May 15th occurrence of the task will appear.

  • Click OK to close the Task Recurrence dialog box.

  • If you want to add a reminder, select the Reminder check box to turn on a reminder alert. Enter the date and time you want for the reminder.

  • You can specify a custom sound to be played with your reminder. Click Button Image, click Browse, select the sound file to play, click Open, and then click OK. This changes the reminder sound only for this task.

  • If you want to track your progress on this task, in the Status, Priority, and % Complete boxes type or select the options you want.

    The Status and % Complete fields are dependent on each other. By changing the value in one field, the value in the other field changes accordingly.

Status

% Complete

Not Started

0

In Progress

1-99

Completed

100

Waiting on someone else   

0-100

Deferred

0-100

  1. If you want to assign a color category to your task, on the Task tab, in the Options group, click Categorize, and then click one of the entries from the menu. For more color categories, click All Categories.

    The first time you use a color category, you will be prompted to provide a name that is more meaningful to you. You can create custom color categories, associate custom colors with color categories, and assign shortcut keys. Click OK to return to the Task window.

    Tip   Changed your mind about a color category assignment? Right-click the color or namef the color category, and then click Clear Name of Category or Clear All Categories.

  2. If your task involves a person or organization in your Contacts, you can create a quick link to the contact, by clicking Contacts at the bottom of the window, and then selecting an entry. Click OK to close the Select Contacts dialog box.

  3. If you do not want other people to see a shared task entry, on the Task tab, in the Options group, click Private.

  4. If you want to enter mileage, work hours, and other billing information, on the Task tab, in the Show group, click Details. Type the information in the Total work, Actual work, Mileage, and Billing information text boxes.

  5. On the Task tab, in the Save group, click Save and Close.

Tip   To move a task up or down on the list, click and drag the item to the position that you want. As you drag the task, a red line with arrows indicates where the task will be placed when you release the mouse button.

Top of Page

Create a task in the Daily Task List in Calendar

The Daily Task List appears only in the Outlook Calendar day and week views. To toggle the Daily Task List on or off, in Calendar, click View, point to Daily Task List, and then click Normal, Minimized, or Off.

Daily Task List

To display only the total number of tasks, do one of the following:

  • In Calendar, click View, point to Daily Task List, and then click Minimized.

  • Point to the top edge of the Daily Task List. When the pointer becomes a Size handle icon, drag the edge to the bottom of the window.

Tip   To create new tasks in the Daily Task List, you must use the Normal Daily Task List setting.

  1. In the Daily Task List, as your pointer hovers, Click to add task is displayed.

  2. Click any blank space beneath a day column.

  3. Type a subject for the task, and then press ENTER.

    By default, the task will be assigned a Start date and Due date of the day in the column above the Daily Task List. To change the Start date or Due date of the task, drag the created task to the day that the task is due. Instead of dragging the task, you can open the task and then change the start and due dates. To do so, you can right-click the task, and then click Open, or select the item, press ESC, and then press ENTER.

  4. If you want to make the task recur, on the Task tab, in the Options group, click Recurrence.

  5. In the Task Recurrence dialog box, click the frequency (Daily, Weekly, Monthly or Yearly) with which the task should recur, and then do one of the following:

    • Make the task recur at regular intervals     In the Recurrence pattern section, select the options for the frequency interval that you want. Do not select Regenerate new taskor the task will not recur at regular intervals.

    • Make the task recur based on completion date     Select Regenerate new task, and in the box, type the amount of time after which a new task must be generated.

      Each time you mark the task complete, a new task will be created based upon your selections.

      Tip   This is your best choice when you do not want the next reminder for a task to appear until the previous one is marked complete. If you do not mark the item complete, the next reminder will never appear. For example, if you have a reminder to pay your utility bill on the 15th of each month and you do not mark the occurrence on April 15th as complete, in May you will still see the April 15th task. Once you mark the April 15th task complete, the May 15th occurrence of the task will appear.

  6. Click OK to close the Task Recurrence dialog box.

  7. If you want to add a reminder, select the Reminder check box to turn on a reminder alert. Enter the date and time you want for the reminder.

  8. You can specify a custom sound to be played with your reminder. Click Button Image, click Browse, select the sound file to play, click Open, and then click OK. This changes the reminder sound only for this task.

  9. If you want to track your progress on this task, in the Status, Priority, and % Complete boxes type or select the options you want.

    The Status and % Complete fields are dependent on each other. By changing the value in one field, the value in the other field changes accordingly.

Status

% Complete

Not Started

0

In Progress

1-99

Completed

100

Waiting on someone else   

0-100

Deferred

0-100

  1. If you want to assign a color category to your task, on the Task tab, in the Options group, click Categorize, and then click one of the entries from the menu. For more color categories, click All Categories.

    The first time you use a color category, you will be prompted to provide a name that is more meaningful to you. You can create custom color categories, associate custom colors with color categories, and assign shortcut keys. Click OK to return to the Task window.

    Tip   Changed your mind about a color category assignment? Right-click the color or name of the color category, and then click Clear Name of Category or Clear All Categories.

  2. If your task involves a person or organization in your Contacts, you can create a quick link to the contact, by clicking Contacts at the bottom of the window, and then selecting an entry. Click OK to close the Select Contacts dialog box.

  3. If you do not want other people to see a shared task entry, on the Task tab, in the Options group, click Private.

  4. If you want to enter mileage, work hours, and other billing information, on the Task tab, in the Show group, click Details. Type the information in the Total work, Actual work, Mileage, and Billing information text boxes.

  5. On the Task tab, in the Save group, click Save and Close.

Tip   To move a task up or down on the list, click and drag the item to the position that you want. As you drag the task, a red line with arrows indicates where the task will be placed when you release the mouse button.

Create-tasks-and-to-do-items