You are searching about Formula To Find The Difference Between Two Numbers In Excel, today we will share with you article about Formula To Find The Difference Between Two Numbers In Excel was compiled and edited by our team from many sources on the internet. Hope this article on the topic Formula To Find The Difference Between Two Numbers In Excel is useful to you.
Bringing Science to the Art of Coaching
Interest in helping leaders to become better coaches is at an all time high. Surveys show that employees want a great deal more coaching than they receive and there are signs that corporate America is finally trying to respond in two ways: first, they are training managers to be better coaches and second, they are using external coaches. With all this investment, what can be done to insure that it pays off with the highest possible return? There is great inconsistency in the quality and effectiveness of coaches, and the field is attracting more people at a rapid rate.
To expand and improve the art of coaching triggers a series of extremely important questions for which we’ve not had good answers. Yet, the future success of coaching may lie in our ability to find answers to these basic questions. The purpose of this paper is to highlight how many of these questions may be addressed in large part by:
- Applying research from a variety of allied disciplines
- Applying lessons learned from other successful initiatives that are closely related to coaching
- Using research conducted in business and public service organizations
THE KEY QUESTIONS
The questions are:
- To what degree does coaching really pay off? Or, is this just one more in a long line of management fads?
- How can we increase the effectiveness of each coaching session?
- How can the process of coaching be made more consistent?
- What is the appropriate goal for coaching, and how much change can we expect?
- What is it about the coaches’ personality or behavior that makes the most positive impact?
THE NEED FOR EVIDENCE
In the book Hard Facts, Dangerous Half-Truths, and Total Nonsense: Profiting from Evidence-Based Management, Pfeffer and Sutton show how companies can improve performance and overcome their competition through evidence-based management. They point out that a very small percent of what managers do is based on any solid data. This analysis appears to have been spawned by the research on medicine from Dr. David Eddy who suggested that in 1985 only 15% of what physicians did had any scientific evidence to support it, and that now that number has risen to somewhere between only 20 to 25%.
Let’s face it. The practice of coaching in our industry is relatively new. Until recently, most coaching happened somewhat informally. Before that, some organizations offered more formal coaching to those leaders who needed “fixing.” It is not surprising, therefore, that corporations and large public agencies have not made much investment in pushing the state of this art into a more scientific realm. As the practice of coaching continues to grow, more and more organizations are attempting to measure the benefits of coaching and calibrate their return on investment. This leads to a heightened interest in improving the process and making results more predictable.
The good news is that there are related disciplines that have conducted extremely relevant research. Corporate coaching practice may benefit from the application of these related disciplines in which greater budgets exist for such research, and where the consequences of success and failure are so enormous. This paper attempts to reach out and tap into that relevant research that addresses our key questions and issues.
QUESTION 1. DOES COACHING REALLY MAKE A DIFFERENCE?
Our research within corporations and public agencies provides useful answers to this first question. Analysis of hundreds of thousands of 360-degree feedback instruments sheds light on the effectiveness of coaching.
When we study leaders who are most effective at coaching, we can see some clear correlations between a leader’s coaching effectiveness and its impact on his or her direct reports. Consistently, our data show strong correlations between a leader’s coaching effectiveness and measures of employee commitment and engagement.
Much has been written on the importance and impact of having highly committed and engaged employees. Studies have shown that an increase in employee satisfaction typically leads to an increase in customer satisfaction, which ultimately impacts the bottom line of the organization. So how do leaders impact employee satisfaction? It appears that one very strong lever that leaders can use is to improve how well they coach and develop their employees.
In a competitive job environment, many organizations focus on attracting and retaining talent. We know that one of the best predictors of people leaving an organization is their indication that they frequently think about quitting. (The only other more powerful predictor of turnover is when people actually announce their intention to leave.)
When we correlate coaching effectiveness with intention to stay, we find that effective coaching more than doubles the likelihood that people won’t even consider leaving the organization.
In our research, we also found that the results produced by the highest performing coaches were correlated with the following outcomes: • Greater willingness to “go the extra mile” for the organization.
- Increased levels of employees reporting that the company is “a good place to work.”
- Increased employee satisfaction with decisions impacting their work.
- Increased feelings of being valued as an employee by the organization.
- More than double the number of employees who were inspired to “put forth a great deal of effort every day.”
- Increased employee’s perception that his/her supervisor was doing a good job.
While this is just a sampling of hard data that confirms the impact of coaching, we hope such data convinces every leader that this is not a current fad lacking serious business consequences. Coaching is not something that should be perceived of as merely “nice to do.”
QUESTION 2. HOW CAN WE INCREASE THE EFFECTIVENESS OF EACH COACHING SESSION?
On this topic we turn to research from the world of counseling and therapy. As we do, however, let’s be extremely clear that we are not suggesting that a manager who conducts a career discussion with an employee is performing the same role as a trained therapist. The differences are huge.
Research from the world of counseling and therapy suggest that two important actions taken by the counselor can have a significant impact on the effectiveness of the therapy:
- Asking the client what he or she would like to discuss.
- Asking the client for feedback at the end of each session.
When these relatively simple actions are implemented, success soars upward. These steps increase the likelihood that the client will take action and also continue working with the therapist.
FOCUSING THE CONVERSATION
The first action implies that the coach should talk about things that are of greatest interest and value to the person being coached. While this concept seems obvious, our experience is that most leaders feel it is their right (or possibly their duty) to set the agenda in coaching conversations. Leaders often talk about issues that are of concern to them or that they believe would be of value to the person being coached, but these are often not in response to any direct question to the person being coached.
To assist coaches in ensuring that the conversation is focused on topics most important to their direct reports, a checklist could be given to the employee, with the request that the employee review the topics on that list and come to the first scheduled coaching discussion with four or five selected topics. This sends several important messages:
- The coach wants the person being coached to feel some control of the process
- The coach respects the employee’s wishes
- This is not just an event, but the beginning of a long-term coaching relationship designed to be of help to the person being coached
By having a series of topics identified with the direct input of the employee, the conversation is now guaranteed to focus on topics that are of genuine interest to the person being coached.
This does not suggest that there shouldn’t be times when the coach should suggest a topic that would be of value to be person being coached. Indeed, we strongly recommend that. However, when topics discussed are ones selected by the person being coached, success generally goes up.
ASKING FOR FEEDBACK
Duncan and Miller conducted research that provides strong evidence that when therapists asked for and received immediate feedback from their patients, attrition rates were cut in half and effectiveness improved 65%. Duncan and Miller’s work can be found at: www.talkingcure.com. The implication for coaches is clear. If coaches open themselves up to personal feedback they will have more effective coaching discussions and they will also become much better coaches. Our own research confirms that the best leaders-as-coaches not only excel at providing feedback, but also excel at asking for feedback. The very nature of asking for feedback allows the coaching relationship to embody the spirit of a collaborative, two-way conversation.
QUESTION 3. HOW CAN THE PROCESS OF COACHING BE MADE MORE CONSISTENT?
The answer to this question may come in part from studying another type of conversation that organizations pay a great deal of attention to: the selection interview. Much research has pointed to the evidence that behavioral interviewing, or performance-based interviewing, can be a predictive method for determining the future success of a job candidate. This technique calls for the interviewer to ask specific questions regarding past activities and behavior, rather than the more vague “tell me about yourself” or “describe your most positive qualities” questions. For example, the behavioral interview asks how people handled a specific situation in the past or it poses a specific hypothetical situation and asks the interviewee how he or she would handle that. The more specific the question, the more reliable and therefore more predictive the answer will be. Interviewers are prepared with a set of scripted questions that elicit more precise answers and do that more consistently with each candidate.
Behavioral interviewing and coaching have several common elements.
- Both consist of an interview/dialog that has a clear purpose.
- These conversations or dialogues usually occur sporadically for the typical business leader.
- There is seldom much formal training on how to conduct these conversations.
- Opportunities for practice are not easy to find; therefore, “practice” usually happens in real time.
- Each of them provides a huge payoff when done extremely well. Both employees and organizations are the beneficiaries.
To apply the lessons learned from behavioral interviewing to the practice of coaching, we might suggest the following:
- Provide leaders with training and the opportunity to practice applying the process and skills necessary to facilitate effective coaching conversations. Ensure that the training focuses on effective questioning and listening skills, designed to thoroughly discover the situation from the coachee’s point of view.
- Provide line managers with a clear structure to follow in coaching conversations. This structure may be as simple as the FUEL formula:
- FRAME THE DISCUSSION, explaining what is hoped for in terms of outcomes, issues of confidentiality, and what role each person will play.
- UNDERSTAND THE CURRENT STATE, which entails clarifying the current situation as seen by the person being coached. (This is where a checklist can help launch the discussion in an optimum direction.)
- EXPLORE THE DESIRED STATE. This involves the coach helping the person to think about what ideally would occur from that person’s point of view.
- LAY OUT A PLAN OF ACTION that will enable the person being coached to achieve that goal.
While such a structure is obviously broad and general, it provides a needed framework for the coach to follow. Coaching improves when the leader-as-coach has a clear track to run on, versus operating in a completely unstructured, free-wheeling approach to the discussion.
QUESTION 4. WHAT IS THE APPROPRIATE GOAL FOR COACHING, AND HOW MUCH CHANGE CAN WE EXPECT?
In the coaching process, the coach is trying to help bring about the greatest amount of positive change in the person being coached. In most cases, positive change is defined by what the person being coached wants to achieve, though it may be defined in part by what the coach sees needing to be changed.
Assuming positive change as our objective and measure, we certainly aren’t the only people with that as our goal. One group that is extremely focused on producing measurable change is counselors working with drug and alcohol addicts. Because of the social and economic significance of their work, along with the number of people engaged in doing it, they have engaged in extensive research. Their findings appear to have enormous relevance to what a corporate coach is attempting to do.
One prominent researcher is James Prochaska at the University of Rhode Island. He and his colleagues collected data on over 6,000 cases of drug and alcohol addiction. His work has been given the somewhat overwhelming title of a “transtheoretical model,” which comes from the fact that he was trying to rise above any one model of therapy to see what universal principles might underlie them all. His conclusion was simple and yet extremely powerful. Change is not one giant leap, but a series of successive steps.
He identified the following stages in the change process:
- Pre-contemplation (I’ve not thought about it, or I’m not ready yet)
- Contemplation (I’m ready to seriously consider some change)
- Preparation (I have a plan)
- Action (I’m now ready to take action)
- Maintenance (I’m willing to keep at it)
Prochaska’s research concluded that counselors who saw their task as moving someone in a giant leap over these five stages had the least success. Those with greatest success saw their role as helping people to move from one stage to the next, while always showing great respect for where the person was in the change process.
It seems to us that this links nicely to the research from the Corporate Leadership Council regarding what organizations could do to effectively develop leaders. One of the two most powerful steps shown from their research was for each leader to have a personal plan of development to which the leader was personally committed.
The implication of that research, as we see it, is that most leaders today don’t possess such a personal plan for their own development of leadership skills. In fact, our research suggests that less than 10% do. Thus, most leaders are at Prochaska’s Stage 1, they are not even thinking about it. (No wonder they don’t become better leaders.) Being given some feedback (often from 360-degree or multi-rater instruments) and receiving help in creating a plan helps moves them from Stage 2 to Stage 3. They then must take personal responsibility and move from Stage 3 to Stage 4 and ultimately to Stage 5. The irony is that organizations desperately need more leaders to be at Stage 5, while the reality is that most have not suited up to even enter the race. As more baby-boomers retire and the quest for talent becomes more intense, this problem will be compounded.
One of the helpful roles a coach plays is to help the person move through each of these changes, monitor the frequent backward lapses and create a greater sense of accountability to make personal change happen.
QUESTION 5. WHAT IS IT ABOUT THE COACHES’ PERSONALITY OR BEHAVIOR THAT MAKES THE MOST POSITIVE IMPACT?
We reiterate here that there are many groups in other helping fields interested in helping people change. These include counselors, psychiatrists, psychologists, priests, pastors, and social workers. Let us hasten again to note that there are major differences between what these helping professionals do and what coaches in industry should be doing. However, there are also some commonalities. All are involved in conducting “motivational interviews” with people.
William Miller and Stephen Rollnick have compiled an enormous body of research on what leads to success in conducting such interviews, including the attitudes and behavior of the person conducting them. Their conclusion is that three key elements create the necessary conditions for successful change to occur. These elements include:
- Collaboration between the people involved in contrast to contention between those parties.
- The “helper” seeks ideas and insights from the person being helped, in contrast to assuming the posture of educating the patient.
- Maintaining the autonomy of the person being helped (meaning the right and capacity for self-development) in contrast to the helper displaying authority over them.
While these again sound deceptively simple, they hold great messages for the coach in a business setting:
- Coaching will not be as apt to succeed if there is tension or contention between the parties. Coaching is not something you can do “to” someone, but it succeeds best when it is done “with” the person.
- If the helper assumes a position of power or status and conveys the message, “I have the answers, and I’m going to teach you these correct ideas,” there will be less success than if the coach continually seeks ideas and insights from within the individual. Indeed, the greatest success comes when the client’s view of coaching issues, the potential solutions, and the ideas about the best process for change all come together to form a theory for the client, and that the helper uses the client’s theory of change to assist the client in moving through the change process. In this context, the helper serves to reinforce the client’s theory for change, apply experience to it, help to interpret it, and generally use the client’s thinking in place of the helper’s own agenda.
- The more the coach plays the “I’m the boss” card, the less effective the coaching will be. Yes, there are times, especially if it involves a performance issue, that this may be inevitable or appropriate. Difficult discussions regarding performance issues should occur less than 15% of the time in the grand scheme of corporate coaching.
Finally, the work of these two researchers identifies an interesting phenomenon. The greatest improvement they observed did not occur during sessions they had with their patients, but in between sessions. The translation of that into corporate coaching seems obvious. We’ve long known that most of what people learn is absorbed casually and informally on the job, but virtually nothing has been done to enhance that and recognize its power. Helping people to be more observant about what takes place daily on the job, and to attempt new behaviors in the course of daily work would appear to be some obvious applications of this insight.
Another important insight from this research is that the greatest gains come in the early stages of any counseling relationship. Short-term therapy is becoming increasingly popular in the world of counseling. Corporate coaches should anticipate that some of the greatest gains will occur within the first sessions of coaching on a given topic, and that there will normally be a leveling off in the change process on that topic.
Coaching, like the broader disciplines of leadership and management, will always contain many characteristics of an art form. No two people will practice it exactly the same way. The applications are so complex and different, merely being responsive to the situation calls for new and different behavior. It will never be a pure science.
The world of coaching in business organizations and large public agencies can gain a great deal from embracing good ideas and practices from every source, including the major helping professions. Only in that way will it ever achieve its potential contribution to every organization.
Video about Formula To Find The Difference Between Two Numbers In Excel
You can see more content about Formula To Find The Difference Between Two Numbers In Excel on our youtube channel: Click Here
Question about Formula To Find The Difference Between Two Numbers In Excel
If you have any questions about Formula To Find The Difference Between Two Numbers In Excel, please let us know, all your questions or suggestions will help us improve in the following articles!
The article Formula To Find The Difference Between Two Numbers In Excel was compiled by me and my team from many sources. If you find the article Formula To Find The Difference Between Two Numbers In Excel helpful to you, please support the team Like or Share!
Rate Articles Formula To Find The Difference Between Two Numbers In Excel
Rate: 4-5 stars
Search keywords Formula To Find The Difference Between Two Numbers In Excel
Formula To Find The Difference Between Two Numbers In Excel
way Formula To Find The Difference Between Two Numbers In Excel
tutorial Formula To Find The Difference Between Two Numbers In Excel
Formula To Find The Difference Between Two Numbers In Excel free
#Bringing #Science #Art #Coaching