Tuesday, 23 December 2014

[HM:257624] 7 Ways to Build Effective Social Skills



in - on 9/17/2012 05:21:00 AM - No comments


Do you feel awkward in conversations with people? Are you having a difficult time of pinpointing why? Do feel it's impossible to forge lasting and meaningful connections with other kids and adults, no matter the situation? If your answer to any of these questions is "yes", then you need to look at how you attempt to interact with others, and see how your social skills can be improved to get you out there and interacting with people in no time. Here are seven proven tips to improve your social skills and get you out there.

VALIDATE YOUR OWN EMOTIONS Many of the problems that come with poor social skills is the mistaken understanding that we look to others to validate our own emotions and worth. This is incorrect. You and you alone are responsible for the state of your own emotions, no matter what awful things someone might say to you. Be a mature adult (or kid) and take responsibility.

DON'T TRY TO THINK LOGICALLY ABOUT SOCIAL INTERACTIONS People are not rational creatures, they are rationalizing creatures. Most awkward social interaction stems from one person attempting to logically interpret the actions or emotions of the other person, when logical simply doesn't apply. Stop trying to be logical, and much if not all of the frustration you feel will melt away.

AVOID CRITICIZING OTHERS
Socially awkward people often have a problem with learning their mental filter, and controlling their compulsion to say whatever crosses their mind, positive or negative. Learn to control your need to criticize others. Criticism is a bad verbal communication habit.

TALK LESS ABOUT YOURSELF AND MORE ABOUT OTHERS
Social interaction would be easy if everyone simply wanted to talk about the other person. Alas, it rarely works that way. Learn to be interested in other people, and find the best ways to get them interested in learning about you, without volunteering to do it for them.

FOCUS OUTWARDLY
Try to become more of an 
extrovert if you're introverted(even though biologically this is impossible), in all facets of your life, and shift your focus away from yourself and towards the needs of others.

STOP BLAMING OTHERS
Along the lines of the previous point, do not blame others for your own ability to communicate or interact socially. You alone are responsible for fostering 
good social skills in yourself.

AVOID NEGATIVITY
No one likes to be around negative people, and nothing inhibits social interaction or growth more quickly than your own negative attitude. Try to keep the condemnations and complaints to a minimum in any and all conversations.
Social skills can be tough for kids and adults. In this article are seven proven tips to improve your social skills and get you out there socializing well with others.
Follow the seven tips for effective social skills and you'll be easily making friends in no time. You can also learn about a helpful resource called Elite Social Control.

--

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/
 
https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Monday, 22 December 2014

[HM:257623] Why Charity is Important



In today's materialistic society, charity is often seen as low priority. 
 
However the reality is that the community we live in has a huge influence on us personally – it fosters safety, responsibility and sustainability – so it is important that we take our community seriously for the greater good of humanity and for our own personal benefit. 

Most importantly though, you'll gain an appreciation for what REALLY matters – and it's not fame or fortune! 

After-all, there are many high-profiled people who are great believers in charity and the planet. Bill Gates donates millions of dollars to charities, Bob Geldoff and U2's Bono are great crusaders against world poverty, and many other celebrities offer money and their time to a variety of causes. 

Yes, these people have the money to give and their image has done pretty well out of their endeavours – but at the heart of their generosity is the genuine desire to make a difference. And they do. 

But, you don't need lots of money or fame to contribute to the community – we all can. 

It is my honest belief that we should all help those less fortunate than ourselves – and trust me, if you have the resources to be able to read this article on-line, then there are lots of people out there who are less fortunate! 

Whether this help is financial through appropriate donations or through donating your time as a 
volunteerdoesn't really matter, but we should all feel some social responsibility to do something. 


Everyone can do something. YOU can do something. If you don't have the time, DONATE. If you can't afford to donate money, VOLUNTEER and offer your time or services

Making Donations 

As a general guide, aim to donate 10% of your income to charity. You may have heard the phrase, "Charity starts at home" – so make sure your budget can afford it! 

Some things to keep in mind when choosing a charity:
  • Pick a cause that you believe in the most – all charities are worthwhile, but which ones are YOU passionate about?
  • Look around your, there are thousands of poor people desrve to be helped out, there are so many families which are not having food, money for education, warm clothes, fan for cooling, shelter to stay, basic comodities. Go help them, help them on weekly, monthly basis. Consider the ways they can get their jobs back so that they are not depenedant on anyone anymore Work on the preventive actions to reduce poverty and poorness.
  • Payment terms – do they have a 'subscription' donation system where you're set up to make regular donations? Do they have a minimum donation acceptable? Do they accept all payment options? Do they provide a written receipt (they should!)? An of course, is this all acceptable to your finances.
  • Can you claim donations for this particular charity as a Tax Deduction? What are the particular tax laws in your country?
  • What does the charity do with the money – are you concerned that too much of the money is spent on administration fees and staff costs?
  • Of the charities you've investigated, which one gives the biggest 'Bang for your buck'?

And of course, encourage your children to give some of their money to charity too - little kids love putting money in donation boxes, and you may be surprised how well older children understand the concept of giving to charity



--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/
 
https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[HM:257622] Ten Stupid Policies Great People Leave Companies

Article cover image
Liz Ryan

Liz RyanInfluencer

CEO and Founder, Human Workplace

Ten Stupid Rules That Drive Great Employees Away


We met a guy named Vijay at a conference where he and I were speaking. About six months later, we heard from him.

"So I wanted to let you know, I'm out of here," said Vijay on the phone.

"What's the story?" we asked. "When we met you, you loved your job."

"I loved the job I thought I had, which is the job I interviewed for," said Vijay.

"That job never materialized. The company is trying to change its stripes, but it's hard."

"Let me guess," said my teammate Molly. "They told you 'It takes time to turn an ocean liner around.'"

Vijay laughed. "Those are the exact words my boss used! He's been trying to turn the vessel around for five years. That's too slow. I don't have that much time. I have things to do and places to go!"

"You couldn't see a path forward at your job?" I asked.

"I could see the path forward, and it's full of rocks and snakepits and quicksand," said Vijay.

"No good," we said. "Congratulations on your job search!"

"This place has a great brand name, but inside the company it's a weenie atmosphere," said Vijay.

"It's rules, rules, and more rules all over the place. Nothing but reasons why NOT to try something new. Life is too short!"

Vijay got a great job seven weeks later. It's sad to see great people like Vijay leaving companies.

I'm sure Vijay's CEO doesn't realize that his company makes it impossible for people to do the jobs they were hired for.

It's a new millennium - fifteen years into the new millennium, in fact. We don't have to manage our teams the way we did in 1962.

My dad put up with stupid corporate rules because his employer offered him a career path, job security forever and an awesome pension plan that my folks still rely on today, thirty years after my dad retired.

All that stuff is history. Employers who keep Mad-Men-era policies in place will keep driving their best people away until they spot the connection between policies, passion, performance and profits. Here's how it works:

The more policies, the less passion you'll get from your team.

The less passion, the less exciting the team's performance will be.

The less exciting the performance, the lower your profits will be.

Eureka!

Maybe this reminder will induce you to nuke one or more of these ten Talent-Repelling Policies if you're a manager. If you're not a manager, that doesn't mean you have to stay silent and complain to your cat about the stupid rules at work. You can speak up, at a staff meeting or directly with your manager.

Find your voice and speak! You were hired for your brains, weren't you?

Here's our list of Ten Stupid Rules that Drive Great Employees Away.

Stupid Attendance Policies

Salaried people don't need attendance policies. That's why they're on salary. If you're still dinging people for getting to work ten minutes late when they commonly stay an hour late every day, you don't deserve them on your team.

Stupid Frequent-Flyer Policies

Business travel is a grind. It takes years off your life. It's not easy being on the road and leaving your life behind. Your employees earn every frequent-flyer mile their business travel entitles them to. Those miles are theirs, not their employer's.

Any company stingy enough to steal its employees' frequent-flyer miles is not an employer that can grow your flame or take you to the next step on your path. Get them to change that Scrooge-y policy, or run away.

Stupid Dress Code Rules

We write dress code policies because we'd die of embarrassment having to talk to an employee face-to-face about his or her excessively club-by or beach-y attire. Too bad for us. We're managers, and sticky human topics are part of the job.

Get rid of the insultingly detailed dress code policy and simply remind your employees to dress for business.

You can add "If you're on the fence about whether or not to wear a particular ensemble or article of clothing to work, err on the side of caution and don't wear it."

Bell Curve Performance Reviews

Performance reviews in general are a bureaucratic waste of time, but the ones that force managers to fit their teammates into pre-set slots on a Bell Curve are disgusting and unworthy of the brilliant people on your staff.

If you truly don't trust your managers to hire wonderful employees, why did you make them managers? Bell curve performance reviews only encourage the hiring and retention of so-so employees, or worse. Get rid of them in 2015 and celebrate your team's briliiance!

Stupid Bereavement-Leave Policies

There are still employers that require their employees to bring in funeral notices in order to be eligible for a few days' paid bereavement leave. That's shocking and horrifying.

No doubt some employee way back when falsified a family death to get some time off, and ever since then the company has been writing its policies to prevent such a fraud from re-occurring.

That's idiotic, and heartless. It's never smart to write policies directed toward people you wish you hadn't hired. Trust your employees, and they'll trust you back.

Stupid Approvals for Everything

We'd expect any employer to require approval from higher-ups before you're allowed to spend a lot of money or hire someone new. We'd expect some required approval before you launch a project or put someone on probation.

Do we really need a manager's written approval for an employee to replace his ID badge?

We have taken nearly all the latitude away from the talented adults we hire. That's stupid and a waste of shareholder's money. More bureaucracy only slows us down.

Can we trust the people we chose to join our team to do simple things like order a new stapler without requiring a manager's written permission? If not, can we call ourselves leaders?

Stupid Disciplinary Rules

The idea of discipline comes from the military. We don't think that it would ever be appropriate to put our kids' piano teacher or our plumber on probation, so why would we do that to the employees on our teams? The idea of progressive discipline makes no sense in the Knowledge Economy we operate in now.

We are all adults. If someone goofs up, we can have a conversation about it. We can figure out where things broke down. If we don't trust a person to represent our brand, what good will probation or a written warning do?

Don't listen to people who say "We have to do this stupid stuff in order to fire people if they don't improve." That's completely false. I was a Fortune 500 HR SVP and I'm an expert witness in employment matters now. Anyone who sighs "We're forced to follow these old rules" is either lying to himself, to you, or both.

Stupid Feedback Mechanisms

Employee Engagement is a crock and a slap in the face to your teammates, most of whom would be happy to tell you to your face what your company is doing right and wrong. All you have to do is walk up to them and ask them, face to face, and listen to what they have to say.

Annual employee engagement surveys are a weenie's answer to the question "How are we doing, and how's the team?"

Do you ask your wife to fill out a survey and tell you how you're doing as a husband? She'd have a sharp answer for you if you proposed that approach.

Why should the valued collaborators you work with see things any differently? Lose the engagement survey and make it easy for your teammates to tell you what's working and what isn't, in the moment.

Stupid Hiring Processes

It's easy to fill job openings when you do these three things:

  • Write job descriptions in English or your local language rather than corporate zombiespeak.
  • Treat job applicants like valued collaborators rather than interchangeable machine parts or pieces of meat.
  • Make the interview process fast and friendly, and remember that job candidates need to be sold as vigorously as your customers do.

It's hard to fill job openings when you use Black Hole applicant-tracking systems to screen resumes by means of keyword searching.

That's the world's worst way to hire people. Any employer that complains about talent shortages is barking up the wrong tree. Humanize your recruiting process and watch the talented people flow in!

Stupid Forced Ranking

Forced ranking, sometimes call Stack Ranking, is a process of lining up your employees and comparing them to one another, Best to Worst. It's easily the stupidest idea corporate and institutional weenies have ever come up with.

You can't stay and work for a company that treats like you like a two-by-four stacked up against other pieces of lumber, not when there are wonderful organizations that could use your help!

Your teammates deserve better. People are unique and whole in themselves. There is nothing to compare between one person and another -- thank goodness! Smart employers have always known this. Any organization that doesn't get it doesn't deserve your talents. Get on your path and find the people who do!

Questions and Answers

Why are there hot dogs chasing people in the header image?

They are weenies driving smart and capable employees away. Weenie policies have the same effect. Capable people don't want to put up with being treated like children or criminals, so they leave to go work somewhere else.

Why do companies install so many stupid rules and policies?

Fear is the reason. Fearful managers don't trust themselves to hire people they could trust to do the right thing. There is a tremendous amount of fear in many corporations, institutions and startups. Small companies are not immune to fear.

How do you make an organization more trusting and less fearful?

Talk about fear and trust. They are business issues. Don't pretend there is no energy in the place or that every single person can't feel the energy. Ask your team at every opportunity, in group meetings and one-on-one "How are you doing? What's new? How can I help?"

Do you have to be a manager to tackle workplace energy, and fear and trust?

No! There are lots more non-managers in any organization than there are managers. We all feed Godzilla, the bureaucratic monster, or we all starve him. Tell the truth at work. Say "I'm not sure I know how to complete this project" when you are uncertain.

Break the ice on the topics of fear and trust. Tell your boss "Some of these policies suck away a lot of time and energy and hold us back. How can we revise them or get rid of them?" Blaming managers for the bad energy at work is the worst thing you can do. It depletes your mojo and reinforces the idea that you are powerless at work unless you're a manager.

Are you powerless? You don't look powerless to me!

https://www.linkedin.com/pulse/

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/
 
https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[HM:257621] Microsoft Excel: Top 10 Formulas for Aspiring Analysts


​Few weeks ago, someone asked me "What are the top 10 formulas?" That got me thinking.

While each of us have our own list of favorite, most frequently used formulas, there is no standard list of top 10 formulas for everyone. So, today let me attempt that.

If you want to become a data or business analyst then you must develop good understanding of Excel formulas & become fluent in them.

A good analyst should be familiar with below 10 formulas to begin with.

1. SUMIFS Formula

SUMIFS Formula is used to sum a range of values subject to various conditionsIf you listen very carefully, you can hear thousands of managers around the world screaming… "How many x we did in region A, product B, customer type C in month M?"  right now.

To answer this question without the song and dance of excessive filtering & selecting, you must learn SUMIFS formula.

This magical formula can sum up a set of values that meet several conditions.

The syntax of SUMIFS is like this:

=SUMIFS( what you want to sumup, condition column 1, condition, condition column 2, condition….)

Example:

=SUMIFS(sales, regions, "A", products, "B", customer types, "C", month, "M")

Learn more about SUMIFS formula.

2. VLOOKUP Formula

Pop quiz time ….

Which of the below things would bring world to a grinding halt?

A. Stop digging earth for more oil
B. Let US jump off the fiscal cliff or hit debt ceiling
C. Suddenly VLOOKUP formula stops working in all computers, world-wide, forever

If you answered A or B, then its high time you removed your head from sand and saw the world.

The answer is C (Well, if all coffee machines in the world unite & miraculously malfunction that would make a mayhem. But thankfully that option is not there)

VLOOKUP formula - Syntax, explanation & exampleVLOOKUP formula lets you search for a value in a table and return a corresponding value. For example you can ask What is the name of the customer with ID=C00023 or How much is the product price for product code =p0089 and VLOOKUP would give you the answers.

The syntax for VLOOKUP is simple.

=VLOOKUP(what you want to lookup, table, column from which you want the output, is your table sorted? )

Example:

=VLOOKUP("C00023″, customers, 2, false)

Lookup customer ID C00023 in the first column of customers table and return the value from 2nd column. Assume that customers table is not sorted.

Click here to learn more about VLOOKUP Formula.

Bonus: Comprehensive guide to lookup formulas.

3. INDEX+MATCH Formulas

For every 10 people using VLOOKUP, there is someone realizing its most annoying limitation. VLOOKUP formula can only search on left most column.

That means, if a table of customers has customer ID in left column and name in right column, when using VLOOKUP, you can search for customer ID only.

You cannot ask questions like what is the customer ID of "Samuel Jackson" ?

VLOOKUP would choke and bring your Excel world to a grinding halt.

Thankfully, INDEX+MATCH formulas come to rescue. These 2 beautiful formulas help us lookup on any column and return corresponding value from any other column.

Syntax:

=INDEX(list of values, MATCH(what you want to lookup, lookup column, is your lookup column sorted?))

Example:

=INDEX(customer IDs, MATCH("Samuel Jackson", Customer names, 0) )

Click here to learn more about INDEX & MATCH formulas.

4. IF Formula

Q: What do you call a business that does not make a single decision?

A: Government!

Jokes aside, every business needs to make decisions, even governments!!! So, how do we model these decisions in Excel.

Using IF formulas of course.

For example, lets say your company decides to give 10% pay hike to all people reading Chandoo.org & 5% hike to rest. Now, how would you express this in Excel?

Simple, we write =IF(employee reads Chandoo.org, "10% hike", "5% hike")

The syntax of IF formula is simple:

=IF (condition to test, output for TRUE, output for FALSE)

Click here to learn more about IF formulas.

5. Nesting Formulas

Unfortunately, businesses do not make simple decisions. They always complicate things. I mean, have you ever read income tax rules?!? Your head starts spinning by the time you reach 2nd paragraph.

To model such complex decisions & situations, you need to nest formulas.

Nesting refers to including one formula with in another formula.

An example situation: Give 12% hike to employees who read Chandoo.org at least 3 days a week, Give 10% hike to those who read Chandoo.org at least once a week, for the rest give 5% hike.

Excel Formula: =IF(number of times employee reads chandoo.org in a week >=3, "12% hike", IF( number of times employee reads chandoo.org in a week >0, "10% hike", "5% hike"))

You see what we did above? We used IF formula inside another IF formula. This is nothing but nesting.

You can nest any formula inside another formula almost any number of times.

Nesting formulas helps us express complex business logic & rules with ease. As an analyst, you must learn the art of nesting.

Lots of nested formula examples & explanations here.

6. Basic Arithmetic Expressions

=(((123+456)*(789+987)) > ((123-456)/(789-987)))^3 & " time I saw a tiger"
If you read the above expression and not had to scratch your head once, then you are on way to become an awesome analyst.

Most people jump in to Excel formulas without first learning various basic operators & expressions. Fortunately, learning these requires very little time. Most of us have gone thru basic arithmetic & expressions in school. Here is a summary if you were caught napping in Math 101.

Operator What it does Example
+ – * / Basic arithmetic operators. Perform addition, subtraction, multiplication & division 2+3, 7-2, 9*12, 108/3, 2+3*4-2
^ Power of opetator. Raises something to the power of other value. 2^3, 9^0.5, PI()^2, EXP(1)^0.5
( ) To define precedence in calculations. Anything included in paranthesis is calcuated first. (2+3)*(4+5) calcuates 2+3 first, then 4+5 and multiplies both results.
& To combine 2 text values "You are " & "awesome" returns "You are awesome"
% To divide with 100. 2/4% will give 50 as result. Note: (2/4)% will give 0.5% as result.
: Used to specify ranges A1:B20 refers to the range from cell A1 to B20
$ To lock a reference column or row or both $A$1 refers to cell A1 all the time. $A1 refers to column A, relative row based on where you use it. For more refer to absolute vs. relative references in Excel.
[ ] Used to structurally refer to columns in table ourSales[month] refers to the month column in the ourSales table. Works only in Excel 2007 or above. Know more about Excel Tables.
@ Used to structurally refer to current row values in a table ourSales[@month] refers to current row's month value in oursales table.
{ } To specify an inline array of values {1,2,3,4,5} – refers to a the list of values 1,2,3,4,5
< > <= >= Comparison operators. Output will always be boolean – ie TRUE or FALSE. 2>3 will be FALSE. 99<101 will be TRUE.
= <> Equality operators. Check whether 2 values are equal or not equal. Output will TRUE or FALSE 2=2, "hello"="hello", 4<>5 will all return TRUE.
* ? Used as wild cards in certain formulas like COUNTIF etc. COUNTIF(A1:A10, "a*") counts the values in range A1:A10 starting with a. For more on this refer to COUNTIF & SUMIF in Excel
SPACE Intersection operator. Returns the range at intersection of 2 ranges A1:C4 B2:D5 refers to the intersection or range A1:C4 and B2:D5 and returns B2:C4. Caution: The output will be an array, so you must use it in another formula which takes arrays, like SUM, COUNT etc.

7. Text formulas

While there are more than two dozen text formulas in Excel including the mysterious BHATTEXT (which is used to convert numbers to Thai Bhats, apparently designed by Excel team so that they could order Thai take out food #), you do not need to learn all of them. By learning few very useful TEXT formulas, you can save a ton of time when cleaning data or extracting portions from mountains of text.

As an aspiring analyst, at-least acquaint your self with below formulas:

  • LEFT, RIGHT & MID – to extract portions of text from left, right & middle.
  • TRIM – to remove un-necessary spaces from beginning, middle & end of a text.
  • SUBSTITUTE – to replace portions of text with something else.
  • LEN – to calculate the length of a text
  • TEXT – to convert a value to TEXT formatting
  • FIND – to find whether something is present in a text, if so at what position

You can find several examples of all these formulas & their users in our site. Just search.

8. NETWORKDAYS & WORKDAY Formulas

"There aren't enough days in the weekend" – Somebody

Whether a weekend has enough days or not, as working analyst, you must cope with the working day calculations. For example, if a project takes 180 working days to complete and starts on 16th of January 2013, how would you find the end date?

Thankfully, we do not have to invent a formula for this. Excel has something exactly for this. WORKDAY formula takes a start date & working days and tells you what the end date would be.

Like wise NETWORKDAYS formula tells us how many working days are there between any 2 given dates.

NETWORKDAYS formula tells us the number of working days between a start and end date

Both these formulas accept a list of additional holidays to consider as well.

  • NETWORKDAYS: calculate the number of working days between 2 dates (assuming Saturday, Sunday weekend)
  • NETWORKDAYS.INTL: Same as NETWORKDAYS, but lets you use custom weekends [Excel 2010+ only]
  • WORKDAY: Calculate the end date from a start date & number of working days
  • WORKDAY.INTL: Same as WORKDAY, but lets you use custom weekends. [Excel 2010+ only]

More on working with Date & Time values in Excel.

9. SMALL & LARGE Formulas

Almost nobody asks about "Who was the second person to climb Mt. Everest, or walk on moon or finish 100 mtrs race the fastest?".

And yet, all businesses ask questions like "Who is our 2nd most valuable customer?, third vendor from bottom on invoice delinquency? 4th famous coffee shop in Jamaica?"

So as analysts our job is to answer these questions with out wasting too much time. That is where SMALL, LARGE formulas come in handy.

  • SMALL: Used to find nth smallest value from a list. Use it like =SMALL(range of values, n).
  • LARGE: Used to find nth largest value from a list.
  • MIN: Gives the minimum value of a list.
  • MAX: Gives the maximum value of a list.
  • RANK: Finds the rank of a value in a list. Use it like =RANK(value, in this list, order)

10. IFERROR Formula

Errors, lousy canteen food & dysfunctional coffee machines are eternal truths of corporate life. While you can always brown bag your lunch & bring a flask of finely brewed coffee to work, there is no escaping when your VLOOKUP #N/As. Or is there?

Well, you can always use the lovely IFERROR formula to handle errors in your formulas.

IFERROR Formula - Syntax & Help

Syntax:

IFERROR(formula, what to do in case of error)

Use it like:

IFERROR(VLOOKUP(….), "Value not found!")

Click here to learn more about IFERROR Formula.

3 Bonus Formulas

If you can master the above 10 formulas, you will be ahead of 80% of all Excel analysts. Here are 3 more important formulas that can come handy when doing some serious data analysis work.

  • OFFSET formula: to generate dynamic ranges from a starting point and use them elsewhere (in charts, formulas etc.).
  • SUMPRODUCT formula: Unleash the full power of Excel array processing by using SUMPRODUCT.
  • SUBTOTAL formula: Calculate totals, counts & averages etc. on a range with filters.

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/
 
https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[HM:257620] Analytical Thinking - How to Analyze Thoughts


By Junaid Tahir

Why Should I Analyze My Thoughts:
Quality of thoughts determines the level of peace of mind. Negative thoughts result in negative acts which in turn causes distraction in emotions, unstable behavior, frequent mood swings, family complications, lack of trustworthiness, financial mistakes, professional brawls and so on. Healthy thoughts result in more positive outcomes, high happiness index, better health and so on. So all in all your thoughts are defining your present and your future.

There are several reasons for negative thoughts including but not limited to your circumstances, your brought up, financial situations, family conflicts, job and family complications. While you may not be able to fix these reasons, it is highly recommended to analyze your thoughts and mitigate the negative impact as much as possible. If you remove the impurities from your thoughts you would be able to have a positive, focused and prosperous mind.

How to Analyze My Thoughts:
If you have seen a big aquarium, you must have noticed that the fish keep wandering here and there continuously. From right to left, bottom to up, here and there; all day long. They don't seem to be getting any specific advantage while doing so. Same is the case with human mind. When your head is on the pillow, your brain starts wandering here and there. Several times it is processing the thoughts which shouldn't be the point of concern at all. Though fish do not know this but you can control your wandering of brain by picking up a specific thought/subject and ask these questions:
a)    Why am I thinking about this subject? Is this subject related to others? Why am I thinking negative about someone? I should mind my own business.  
b)    What exactly is the issue? Is this something impacting (or going to impact) me or my family? Can I define my issue/question in one sentence clearly so that I can focus on the solution?
c)    How: can I resolve this issues? Is this doable? If not, can I take advice from others?. If I have the solution then what are the steps which needs to be taken?



How Can I Improve the standard of my Thoughts:
a)    Avoid thinking about unnecessary things specially related to others. Mind your own business. Posses a focused mind.
b)    Stop comparing yourself to others. It's an insult to yourself. You are a unique soul and you are independent on your living, your decisions and your destiny.
c)    Don't think of monetary gains too much. Excessive love for money and assets is the root of most of stresses. Work on your real wealth.
d)    Develop the habit of forgiving and letting things go off. If you are keeping the grudge in your brains for longer durations, you are killing yourself. Stress is a slow poison which deepens its roots your brain and destroy your physical and mental health.
e)    Read quality quotes or articles on positivity and try to absorb the message. This will kill the germs of negativity.
f)    Practice the habit of gratitude. Stop complaining, criticizing and blaming. When a negative thought comes in, convert it to positive by looking at the positive side of the issue.
g)    Instead of thinking about your 'wants' too much, think about your needs. This will reduce the magnitude of your focus because usually needs are limited but wants are too many. Adapt simple life style as it reduces unnecessary socio-economical issues.  

Some recommended articles:

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/
 
https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.