Blog Archive

Excel Tip: How to create A drop-down list

You can
w
atch this video to learn it too alternatley you can read this article.

http://www.youtube.com/watch?v=VDwFTSQ-OQA


If you're creating a worksheet that will require user input and you want to minimize data entry errors, use Excel's data validation feature to add a drop-down list. The best part about it is that you don't have to write any macros.

Data validation is an excellent way to ensure that a cell entry is of the proper data type (text, number, or date) and within the proper numeric range. The drop-down list produced with the feature appears when a user clicks the cell.
Here's how to create a drop-down list:
  1. Type the list of valid entries in a single column. If you like, you can hide this column (select Format, Column, Hide).
  2. Select the cell or cells that will display the list of entries.
  3. Choose Data, Validation, and select the Settings tab.
  4. From the Allow drop-down list, select List.
  5. In the Source box, enter a range address or a reference to the items that you entered in step 1.
  6. Make sure the 'In-cell dropdown' box is selected.
  7. Click OK.
If your list is short, you can skip step 1 and type the list entries directly in the Source box in step 5, separating items with a comma.
The Data Validation dialog box has two other tabs. Click Input Message to add a prompt that will appear when a user selects a cell. Click Error Alert to specify a custom error message if the user's entry is invalid.
The handy data validation feature suffers from one serious flaw. If you paste an entry into a cell that uses data validation, the validation isn't performed. And if you select that cell again, the drop-down list no longer appears. Fortunately, you can circumvent this problem by protecting the worksheet: Select Tools, Protection, Protect Sheet.
Alternately you can
w
atch this video to learn it

http://www.youtube.com/watch?v=VDwFTSQ-OQA

Positive Momentum


Even if you're not sure exactly what you'll do next, go ahead and do what you can do first. The way to establish positive momentum is to get started, and to proceed with determination and commitment. 

When you're in motion, momentum is a powerful positive force that can keep you moving forward. But if you're doing nothing, the momentum of idleness will work against you and hold you back.


So by all means, using whatever it takes, get yourself going. Even a little bit of effort and forward progress can begin to change momentum in your favor.

Set a small goal and do the work to reach that goal. Then move immediately on to bigger things.

The process of achievement feels good, even though it may be difficult and challenging. Get yourself enjoying and looking forward to that good feeling of making a difference, and put the momentum of achievement on your side.

There is something good and meaningful you can achieve right now, once you choose to make it happen. Get going, get busy making a difference, and get the power of positive momentum pushing you forward.


Ralph Marston - The Daily Motivator


 

Junaid Tahir 
www.DailyTenMinutes.com

Twitter LinkedIn Facebook Blogger Blog RSS Google Plus Page
Twitter Latest tweet: 18 Ways to Make Your Parents Feel Great http://t.co/IJ5hDFN4rq
Follow @DailyTenMinutes Reply Retweet 14:32 Sep-20

18 Ways to Make Your Parents Feel Great





The parents now a days are quite worred about the behavioral changes in thier childern due to several socio-economical reasons. The gap between parents and us, the youth, is increasing day by day due to which the family bonding is getting weaker and weaker. We, the youth, want liberty in every deed we do. We want our parents not to be disturb us in what-ever we do in what-so-ever manner. We have forgotten the amount of time our parnets have invested in for our brought up. We have forgotten the countless efforts and sacrifices by our parents throughtout our lives. 
Starting from our birth they have taken care of our food (22years * 365 days * 3 times = 24000 times!), our clothes (daily washing, ironing, new purchasing), our education (daily home works, uniform, school/tution fee), religious & moral teaching every day (THE REAL GREAT JOB), computer & toys purchasing and God knows how many other countless efforts they have put in to make us a complete human being to survive in this world. Indeed, all those efforts cannot be covered in this article but the overall emphesis is that its our moral and religious mandatory responsibility to take care of them now.
Below are some small acts of kindness which I request you to consider to show your affection with them and to take care of them:

  1. Give them enough money so that they don't have to ask you.
  2. Share funny and entertaining things with them to make them laugh or smile.
  3. Don't speak loudly. Speak slowly, nicely and softly.
  4. Do not walk in front of them in market or anywhere. They might walk slow being old; stay behind them. Give them respect.
  5. Ask for small tasks again and again. For example, "Abou Jee, do you need water? Should i bring tea for you? Are you hungry, baba" etc 
  6. Closely monitor thier health. visit doctor if required. Have them thorougly checked time to time.
  7. Take care of their medicines. Set reminders on your phone for their medicines and serve them on time.
  8. Take them to the mosque. Walk slowly. Follow their pace.
  9. Take them to the park for walk. If not possible daily, then take them on weekend.
  10. Do not call them by their name. Call them with respect.
  11. Open the door for them with respect
  12. Adapt yourself according to their schedule not vise versa.
  13. Do shopping for them (buy their clothes, shoes, small items like tooth paste).  Buy your mother a nice coffee cup. Take them to market and buy them according to their likings. Buy your parents some nice books; usually people love to read books in old age.
  14. When you come back to home, visit them first in their room.
  15. Respect thier social circle and let them enjoy with their friends.  Article written by Junaid.Tahir
  16. In case of conflict on any issue, try to follow them as much as possible. Remember, they have been sacrificing their money and time in raising you for years and years. Its time to pay back. They have been showing all the patience during your childhood. Its time for you to be patient.
  17. Keep them with you instead of sending them to old houses etc. This will be a big act of ignorance if you do.
  18. When starting the food, serve them first.
In the end, I would recommend making a check list of this email and and paste it on any wall in your room or kitchen and read it often to remember
Please do share if you are doing any other good thing in making your parents feel great :)



Junaid Tahir 
www.DailyTenMinutes.com

Twitter LinkedIn Facebook Blogger Blog RSS Google Plus Page
Twitter Latest tweet: Rules of Life ('Rules for Being Human') http://t.co/X5G8baflry
Follow @DailyTenMinutes Reply Retweet 02:19 Sep-20

World's first 'invisible' Building in Korea

From left, the planned tower with LED system unactivated; the system with 30 per cent power; and with the facade fully powered.

From left, the planned tower with its LED system not activated; with 30 per cent power; and with the facade fully powered.

This post was originally published on Mashable.

A new skyscraper will soon be a part of the skyline in Seoul, South Korea – but you may not be able to see it.

Architects behind the world's first invisible skyscraper were granted a permit to begin construction on the 450-metre building, dubbed Tower Infinity, according to a press release.

Inside Tower Infinity

Inside Tower Infinity.

The building will use an LED facade and cameras on the back to project the surroundings behind the building onto its front. When turned on, the system will make the outlines of the tower indiscernible.

Advertisement

The projections can also broadcast special events or advertisements onto the building.

Even when the projections are turned off, the skyscraper has some built-in transparency. It will be constructed using a great deal of clear glass and has an open floor plan so visitors can look down multiple levels.

The Tower Infinity will primarily be used for entertainment and leisure, according to the press release from US-based GDS Architects. The skyscraper is set to include a water park, movie theatres and restaurants. The tower's observation deck will be the third highest in the world, and is planned to go up outside Seoul's Incheon International Airport.

The project does not have a scheduled completion date.

Mashable is the largest independent news source covering digital culture, social media and technology.

Read more 

 

Junaid Tahir 
www.DailyTenMinutes.com

Twitter LinkedIn Facebook Blogger Blog RSS Google Plus Page
Twitter Latest tweet: Story: The Manager And The Worker http://t.co/B4MP1XwJJL Follow @DailyTenMinutes Reply Retweet 22:22 Sep-18
 

Rules of Life ('Rules for Being Human')

Cherie Carter-Scott 

 


Rule One - You will receive a body. Whether you love it or hate it, it's yours for life, so accept it. What counts is what's inside.

Rule Two - You will be presented with lessons. Life is a constant learning experience, which every day provides opportunities for you to learn more. These lessons specific to you, and learning them 'is the key to discovering and fulfilling the meaning and relevance of your own life'.

Rule Three - There are no mistakes, only lessons. Your development towards wisdom is a process of experimentation, trial and error, so it's inevitable things will not always go to plan or turn out how you'd want. Compassion is the remedy for harsh judgement - of ourselves and others. Forgiveness is not only divine - it's also 'the act of erasing an emotional debt'. Behaving ethically, with integrity, and with humour - especially the ability to laugh at yourself and your own mishaps - are central to the perspective that 'mistakes' are simply lessons we must learn.

Rule Four - The lesson is repeated until learned. Lessons repeat until learned. What manifest as problems and challenges, irritations and frustrations are more lessons - they will repeat until you see them as such and learn from them. Your own awareness and your ability to change are requisites of executing this rule. Also fundamental is the acceptance that you are not a victim of fate or circumstance - 'causality' must be acknowledged; that is to say: things happen to you because of how you are and what you do. To blame anyone or anything else for your misfortunes is an escape and a denial; you yourself are responsible for you, and what happens to you. Patience is required - change doesn't happen overnight, so give change time to happen.

Rule Five - Learning does not end. While you are alive there are always lessons to be learned. Surrender to the 'rhythm of life', don't struggle against it. Commit to the process of constant learning and change - be humble enough to always acknowledge your own weaknesses, and be flexible enough to adapt from what you may be accustomed to, because rigidity will deny you the freedom of new possibilities.

Rule Six - "There" is no better than "here". The other side of the hill may be greener than your own, but being there is not the key to endless happiness. Be grateful for and enjoy what you have, and where you are on your journey. Appreciate the abundance of what's good in your life, rather than measure and amass things that do not actually lead to happiness. Living in the present helps you attain peace.

Rule Seven - Others are only mirrors of you. You love or hate something about another person according to what love or hate about yourself. Be tolerant; accept others as they are, and strive for clarity of self-awareness; strive to truly understand and have an objective perception of your own self, your thoughts and feelings. Negative experiences are opportunities to heal the wounds that you carry. Support others, and by doing so you support yourself. Where you are unable to support others it is a sign that you are not adequately attending to your own needs.

Rule Eight - What you make of your life is up to you. You have all the tools and resources you need. What you do with them is up to you. Take responsibility for yourself. Learn to let go when you cannot change things. Don't get angry about things - bitter memories clutter your mind. Courage resides in all of us - use it when you need to do what's right for you. We all possess a strong natural power and adventurous spirit, which you should draw on to embrace what lies ahead.

Rule Nine - Your answers lie inside of you. Trust your instincts and your innermost feelings, whether you hear them as a little voice or a flash of inspiration. Listen to feelings as well as sounds. Look, listen, and trust. Draw on your natural inspiration.

Rule Ten - You will forget all this at birth. We are all born with all of these capabilities - our early experiences lead us into a physical world, away from our spiritual selves, so that we become doubtful, cynical and lacking belief and confidence. The ten Rules are not commandments, they are universal truths that apply to us all. When you lose your way, call upon them. Have faith in the strength of your spirit. Aspire to be wise - wisdom the ultimate path of your life, and it knows no limits other than those you impose on yourself.


 

Junaid Tahir 
www.DailyTenMinutes.com

Twitter LinkedIn Facebook Blogger Blog RSS Google Plus Page
Twitter Latest tweet: Microsoft Excel 2007 keyboard shortcuts http://t.co/A5NQSMhaoW Follow @DailyTenMinutes Reply Retweet 12:47 Sep-18
 

Story: The Manager And The Worker


One day a construction supervisor from 6th floor of building was calling a worker working on the ground floor. Because of construction noice, the worker on ground floor did not hear his supervisor calling.

Then, to draw the attention of worker, the supervisor threw a 10 rupee note from up which fell right around in front of the worker.

The worker picked up the 10 rupee note, put it in his pocket & continued with his work.

Again to draw the attention of worker, the supervisor now threw 500 rupee note & the worker did the same, picked 500 rupee note, put it in his pocket & started doing his job.

Now to draw attention of the worker, the supervisor picked a small stone & threw on worker. The stone hit exactly the worker head. This time the worker looked up & the supervisor communicated with the worker.

This story is same as of our life. Lord from up wants to communicate with us, but we are busy doing our worldly jobs. Then God gives us small gifts & we just keep it without seeing from where we got it.

Then God gives us amounts (gifts) & we are the same. Just keep the gifts without seeing from where it came & without thanking God. We just say we are LUCKY.

Then when we are hit with a small stone, which we call problems, then we look up & we communicate with God.

So every time we get gifts, we should thank God immediately, and not wait till we are hit by a small stone, and then communicate with God
.

Twitter Dialogue with David - The Person in Anxiety and Depression:   With around 1500 daily visitors on Da... http://t.co/Iv8jFeEYyZFollow @JunaidTahir Reply Retweet 15:54 Jun-06