Blog Archive

Excel Tip: IF Function

IF Function
Postby NDH » Thu Jan 02, 2014 5:08 pm
The "IF" function is a simple and powerful one and helps automate decision making in your spreadsheet. The "IF" function checks if the specified condition is true or false, does one thing if it's true, does another if it's false.

The syntax for IF function is:

=IF(logical_test, [value_if_true], [value_if_false])

For example, let's say we have a spreadsheet of a few students and we need to find out quickly who passed the test. We have their Roll Nos. and Marks in columns B & C respectively. In the 'Status' column (Column D), we can create a simple IF function that will tell us whether or not the student passed. (Let's assume 50 or higher is the passing score).

In cell D4, we would enter =IF(C4>49,"PASS","FAIL"). This tells Excel to look in cell C4 (Marks) and test to see if its greater than 49. If it is, excel enters the word "PASS" in cell D4. If the marks obtained are 49 or lower, the word "FAIL" is entered instead.

Simply drag down the cell with the formula, till the last student and get the Pass / Fail Status of each.

IF.jpg

source: Systemfunda.com
 Follow me on Twitter  View my profile on LinkedIn  Like my page on Facebook  Read my articles on my personal blog  Subscribe to my Feed  Visit my Google+ Page

Parenting: Are You Doing Too Much for Your Child?

by Janet Lehman, MSW

As parents, many of us do things for our kids that we were able and expected to do for ourselves when we were children. Our parents didn’t often feel the need to negotiate with our sports coach, solve our every problem, or entertain us in our free time. A big difference from today, when all too often we are over-involved in many areas of our children’s lives. 

Sounds funny, I know.  How can a parent be too involved or do too much for their child?  Isn’t that just being a good parent?  But when we don’t expect our kids to take responsibility for chores or their behavior, and we attempt to smooth away all the bumps and bruises that are a natural part of childhood, we aren’t doing our kids a favor.  Instead, we’re bringing them up to avoid taking personal responsibility and to expect that others will take care of things for them – even when they are really able to take care of themselves We’re teaching our kids that life is full of unmanageable problems, when what we want them to learn are the basic skills to manage those problems.  Stepping back and taking on the role of coach and teacher instead of “do-er” and “fixer” was one of the hardest things I had to do as a parent.  But as my husband James Lehman said, it is also one of the best things you can do to help your child build their social and problem-solving skills and learn responsibility.

When you come home after having to work late and find that your child’s homework isn’t finished (again), ask yourself these questions before doing anything: Whose chore is it? Mine or my child’s? Who should be responsible for getting it done?

Read more: http://www.empoweringparents.com/are-you-doing-too-much-for-your-child.php#ixzz38GqOJZX4

Some Oxymorons

Oxymoron :     An Oxymoron is defined as a phrase in which two words of opposite meanings are brought together ...
 
Here are some funny oxymoron's :
1) Clearly Misunderstood.
2) Exact Estimate.
3) Small Crowd.
4) Act Naturally.
5) Found Missing.
6) Fully Empty.
7) Pretty Ugly.
8) Seriously Funny.
9) Only Choice.
10) Original Copies ...
 
And the best of all :
11) Happily Married :)

Junaid Tahir 
www.DailyTenMinutes.com

 Follow me on Twitter  View my profile on LinkedIn  Like my page on Facebook  Read my articles on my personal blog  Subscribe to my Feed  Visit my Google+ Page

Reducing the Gap between Potential and Performance


First of all let us understand what is Potential and what is Performance. Potential is the ability to execute or accomplish something whereas Performance is the actual work done during specific timelines. This actual amount of this work would either be equal or less than the Potential. For example, a mason has the capability (potential) of laying 1000 bricks a day, however he lays 800 bricks (Potential). In this example, there is a gap of 200 brick which should have been laid by the mason in the ideal scenario.

So let us review some factors which need to be considered in order to reduce the gap between Potential and Performance. The analysis can be applied to different scenarios such as office employee, domestic work or even for self audit.

1-    Stress at work: Managers need to closely observe if any specific employee is disturbed due to any reason (either personal or office politics or any other office stress). The manager needs to discuss it in person so as to reduce or fix the stressful situation. If there areethical issues, its manager responsibility to take necessary actions for the employees trapped in ethical issues.

2-   Skills development: The saw needs to be sharpen now a then. Read this nice story to understand the concept in detail. 

3-   Fair payment: Employee needs to be paid fairly which should be in accordance with their capabilities. Also, the level of embarrassment increases if different employees are not treated evenly. 


4-   Health: Fair amount of rest should be offered to employees in case they are sick. The performance will definitely be degraded if an employee is pushed to work beyond his health limits.


5-   Team work: Encourage all team members to work for a common goal. Associate awards with accomplishment of tasks. 

Conclusion: Improving happiness index and loyalty factor to the company will improve throughput. Think from each members' perspective that when he/she wakes up in the morning, what he thinks before coming to office. Is he enthusiastic about coming to office or just coming for time pass? Is he/she a motivated and a highly engaged employee? Remember, employees are like batters you need to charge them consistently for best performance.

Health: Lower LDL - Cholesterol with these 7 Foods

Low-density lipoprotein (LDL cholesterol) promotes the occurrence of atherosclerosis and is a major risk factor for coronary heart disease. Lowering serum LDL cholesterol levels is a primary objective for high cholesterol treatment. Here are 7 foods to eat to lower LDL cholesterol naturally.

1. A bowl of oatmeal for breakfast. Eating a bowl of oatmeal at breakfast for 8 weeks can make bad blood cholesterol concentration decreased by 10% and increase good cholesterol levels. Oat is rich in soluble and insoluble dietary fiber, it prevents the absorption of cholesterol and fat, thereby lowering cholesterol and reducing fat.

2. Eggplant is a vegetable that can lower cholesterol, and people eat it regularly in the summer season. Eggplant contains nutrients such as protein, carbohydrates, vitamins, calcium, phosphorus and so on. Regular consumption of eggplant can reduce LDL (bad) cholesterol and enhance the resilience of capillaries. The walls of the the blood vessels relax allowing an improvement in blood flow. These positive effects were due to nasunin (a free radical scavenger) and terpene phytonutrients (plant derived nutrients) in eggplant.

3. Eat 3 cloves of garlic at dinner. Eat 3 cloves of garlic a day for as long as 8 weeks, and you can make the concentration of bad cholesterol in the blood drop by 10%. It doesn't matter if it raw or cooked garlic, both have a cholesterol lowering effect. The sulfur compounds in garlic can inhibit liver cholesterol synthesis which can achieves the cholesterol lowering effect.

4. Eat half of an onion a day. Onion is an inexpensive health food. If you eat half of a raw onion a day for as long as 8 weeks then you can make the good blood cholesterol increase by about 20% and reduce bad cholesterol and fatty acid glyceride.

5. Apples are rich in pectin and are good for lowering cholesterol.

6. Eat half a bowl of beans at lunch. Eating half a bowl of beans every day for as long as 8 weeks can decrease bad cholesterol by 20%. Soy foods contain a variety of cholesterol-lowering active ingredients.

7. Eat steamed salmon twice a week. Salmon contains high amount of omega-3 fatty acids. The healthiest way to eat salmon is to steam it. Eat steamed salmon 2 times a week, and after 8 weeks the body's good cholesterol will increase by 10%.

Source: LowerCholseterol


Intelligence of Mahatma Gandhi :)

When Gandhi was studying law at
the University College of London, a professor,
whose last name was Peters, disliked him intensely and always
displayed prejudice and animosity towards him.  Also,
because Gandhi never lowered his head when addressing him ,
as he expected.... there were always "arguments"
and confrontations. One day, Mr. Peters was having
lunch at the dining room of the University, and Gandhi came
along with his tray and sat next to the professor.  The
professor said, "Mr Gandhi, you do not
understand.  A pig and a bird do not sit together to
eat." Gandhi looked at him as a parent
would a rude child and calmly replied, "You do not
worry professor.  I'll fly away," and he went
and sat at another table. Mr. Peters, reddened with rage,
decided to take revenge on the next test paper, but Gandhi
responded brilliantly to all questions.  Mr. Peters,
unhappy and frustrated, asked him the following question.
"Mr Gandhi, if you were walking down the street and
found a package, and within was a bag of wisdom and another
bag with a lot of money, which one would you
take?" Without hesitating, Gandhi
responded, “The one with the money, of
course." Mr. Peters , smiling
sarcastically said, "I, in your place, would have taken
the wisdom, don't you
think?" Gandhi shrugged
indifferently and responded,"Each one takes what he
doesn't have." Mr. Peters, by this time was fit
to be tied.  So great was his anger that he wrote on
Gandhi's exam sheet the word "idiot" and gave
it to Gandhi.    Gandhi took the exam sheet
and sat down at his desk trying very hard to remain calm
while he contemplated his next move. A
few minutes later, Gandhi got up, went to the professor and
said to him in a dignified but sarcastically polite tone,
"Mr. Peters, you signed the sheet, but you did not give
me the
grade."

 Follow me on Twitter  View my profile on LinkedIn  Like my page on Facebook  Read my articles on my personal blog  Subscribe to my Feed  Visit my Google+ Page

10 Ways You Should Not Describe Yourself

Picture this: You meet someone new. "What do you do?" he asks.
"I'm an architect," you say.
"Oh, really?" he answers. "Have you designed any buildings I've seen?"
"Maybe," you reply. "We did the new library at the university..."
"Oh wow," he says. "I've seen it. That's a beautiful building..."
And you're off. Maybe he's a potential client, maybe not... but either way you've made a great impression.
You sound awesome.

Now picture this: You meet someone new. "What do you do?" he asks.
"I'm a passionate, innovative, dynamic provider of architectural services who uses a collaborative approach to create and deliver outstanding customer experiences."
And he's off, never to be seen again... because you sound like a pompous ass.

Do you--whether on your website, or more likely on social media accounts--describe yourself differently than you do in person?

Do you use hacky clichés and overblown superlatives and breathless adjectives?

Do you write things about yourself you would never have the nerve to actually say?
If so, it's time for a change.

Here are some words that are great when used by other people to describe you, but you should never use to describe yourself:

"Motivated."

Check out Chris Rock's response (not safe for work or the politically correct) to people who say they take care of their kids. Then substitute the word "motivated." Never take credit for things you are supposed to do--or be.

"Authority."

If you have to say you're an authority, you aren't. Show your expertise instead. "Presenter at SXSW" or "Delivered TED Talk at Long Beach 2010" indicates a level of authority. Unless you can prove it, "social media marketing authority" just means you spend a ton of time on Twitter.

"Global provider."

The vast majority of businesses can sell goods or services worldwide; the ones that can't--like restaurants--are obvious. (See?) Only use "global provider" if that capability is not assumed or obvious; otherwise you just sound like a really small company trying to appear really big.

"Innovative."

Most companies claim to be innovative. Most people claim to be innovative. Most are not. (I'm not.) That's okay, because innovation isn't a requirement for success.
If you are innovative, don't say it. Prove it. Describe the products you've developed. Describe the processes you've modified. Give us something real so your innovation is unspoken but evident... which is always the best kind of evident to be.

"Creative."

See particular words often enough and they no longer make an impact. "Creative" is one of them. (Go to LinkedIn and check out some profiles; "creative" will appear in the majority.)
"Creative" is just one example. Others include extensive, effective, proven, dynamic, influential, team player, collaborative... some of those terms truly may describe you, but since they're also being used to describe everyone else they've lost their impact.

"Curator."

Museums have curators. Libraries have curators. Tweeting links to stuff you find interesting doesn't make you a curator... or an authority or a guru.

"Passionate."

Say you're incredibly passionate about incorporating an elegant design aesthetic in everyday objects and--to me at least--you sound a little scary. Same if you're passionate about developing long-term customer solutions. Try focus, concentration, or specialization instead. Save the passion for your loved one.

"Unique."

Fingerprints are unique. Snowflakes are unique. You are unique--but your business probably isn't. Don't pretend to be, because customers don't care about unique; they care about "better." Show how you're better than the competition and in the minds of customers you will be unique.

 "Guru."

People who try to be clever for the sake of being clever are anything but. Don't be a self-proclaimed ninja, sage, connoisseur, guerilla, wonk, egghead... it's awesome when your customers affectionately describe you in that way, but when you do it it's apparent you're trying way too hard.

"Incredibly..."

Check out some random bios and you'll find plenty of further-modified descriptors: "Incredibly passionate," "profoundly insightful," "extremely captivating..." isn't it enough to be insightful or captivating? Do you have to be incredibly passionate?
If you must use over-the-top adjectives to describe yourself, at least spare us the further modification. Trust us; we already get it


-- http://www.inc.com/jeff-haden/10-ways-you-should-never-describe-yourself.html?nav=pop
 Follow me on Twitter  View my profile on LinkedIn  Like my page on Facebook  Read my articles on my personal blog  Subscribe to my Feed  Visit my Google+ Page

13 Things to Remember All the Times

1-    No one can ruin your day without your permission.
2-   Most of the people will be about as happy as they decide to be.
3-   Other can stop you temporarily but YOU can do it permanently.
4-   Success stops when you do.
5-   You will never have it all together.
6-   Life is journey not a destination. Enjoy the trip.
7-   The best way to escape your problem is to solve it.
8-   If you don't start, it is certain you won't reach.
9-   He or She whoever laughs , lasts.
10- Life is what is coming, not what was.
11-  Success is getting up one more time
12- When things go wrong, don't go with them.
13- Yesterday was the deadline for all complaints.