Quick Tip: Microsoft Excel: Formatting Headings

Headings are a great way to help your audience understand what date is in your spreadsheet. But sometimes those headings have two, or three, or ten sub-headings. The longer those headings get, the harder it is to get them to look pretty or be legible. I’ll show you in this quick tip how you can format headings in your table, from merging multiple cells together to standing text on its side and more.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Book Review-How Will You Measure Your Life?

The question is simple enough. It seems like a question that I’ve answered before. However, somehow the meaning question – How Will You Measure Your Life? – is one that I, like others, thought I had answered but somewhere got interrupted. I was in the middle of writing the answer of my life and I got distracted. I’m glad that I got back to looking at the question through the lens of Clayton Christensen, James Allworth, and Karen Dillon’s work.

Lost Along the Way

It’s hard to believe that our careers and our lives are like boats adrift on the ocean without solid wind to drive our sails. However, many people find themselves drifting off course with little understanding of how to get back to where they need to go. The Halo Effect spoke of the probabilistic nature of our lives. While someone might have defined insanity as doing the same thing over and over again and expecting a different result, Edison thought differently. Small changes eventually led to the incandescent lightbulb. In Extreme Productivity we spent most of the book hearing about Bob Pozen’s life: how he’s used strategies to get ahead in his life, only to find out at the end that his life is filled with the same random connections and dumb luck that has fueled our own lives.

That isn’t to say that planning a strategy for where we want our lives to go and positioning ourselves in that direction is futile – it’s not. While we may be lousy at predicting what will make us happy (see Stumbling on Happiness), we should try to figure it out – because we’ve still got better odds when we’re shooting for something. In the end our lives, and where we end up, aren’t actually about the destination. It’s about the journey. I mentioned my trip to Mt. Rushmore and the powerful push towards understanding that life is about the journey in my reviews of Changes That Heal and Introducing The Psychology of Success. Sometimes getting a little lost and experiencing the journey isn’t bad – as long as you remember to get back on track at some point.

The Fallacy of Sequencing

Too many people make initial decisions to sequence their life so that they can build a strong foundation for themselves, and then get lost along the way with no clear path about how to get back to what they really want. Do you want to know a secret? I know how much money it will take for you to be happy. It’s roughly twice what you’re making now. I know this because, for all but a handful of people, this is the number that they want.

So as gifted people start their careers to put a financial base underneath themselves, suddenly they find that the stable financial base must be larger and larger. Each time they almost make it, the need for stability gets larger. Adding to that, it’s hard to turn away from people rewarding you with financial incentives if the alternative is less money and higher purpose.

The Fallacy of Planning

If we know that life is about change, probabilities, and that we’ll likely not end up where we intended, why then does it make sense to plan at all? After all, 93 percent of all companies must abandon their original strategy because it proved to not be viable. It would seem that, with these odds, you shouldn’t try for anything at all. However, there is a reason that I learned a long time ago from hunting.

I was learning to shoot with a bow and arrow. I was happy to hit the deer target that had been set up for me. I felt good to be able to hit it at all until my uncle helped me understand the importance of having a narrow target. By having a narrow target (right behind the deer’s shoulder blade) I started to shoot better. Instead of being happy with just hitting the deer, I got specific.

Did I hit my target as often as I hit the deer when that was the target? Nope. However, when I changed my goal and I got specific, I got the ability to use valuable feedback to refine my aim, and as a result I hit the deer more often.

Life is like this. We need to have a specific, narrow target so that we can get realigned. We need feedback from others about what we’re trying to do, so that we can refine it and end up with the right target – for now. So, while you can’t plan out your life, it doesn’t mean that planning is meaningless.

It’s a Job

In How Will You Measure Your Life?, the path wanders through innovation, product marketing, and other topics. One of the interesting stops is learning how people buy products. People buy products to do a job. There’s something that we want and the product – or service – is designed to meet that need. The more we know about the specific need of the person, the more we can design a solution for that problem. The book walks through how to make milkshakes better and recognizes there are two very different needs that milkshakes are hired to do. In the morning, they’re something to keep the commute interesting and provide enough sustenance to prevent mid-morning tummy grumbles. In the afternoons and evenings, it’s something that parents can say yes to after a day of saying no to their child all day.

One product – a milkshake – with two different and, in this case, competing needs. The daily commuter needed a milkshake that they could take their time with and savor during their commute. The parent wanted a milkshake that the child could finish quickly. Two relatively opposite objectives. Finish quicker – or finish slower. This is the challenge with aggregating data. The Black Swan, in conversations about unexpected events, exposes the challenge of averages and their inherent hiding of the details and uniqueness of the data.

Outsourcing Core Competencies

Another sidestep from our measuring our life is the discussion of how some organizations, like Dell, sometimes end up outsourcing so much of what they do that they eventually outsource their core competencies. That is, the thing that made the organization great eventually becomes something that you rely on other organizations to do.

In our personal lives, this has an interesting implication. What are the things in our life that we need to keep because they power our uniqueness, and which do we need to let go because they’re something that someone else can do better, faster, cheaper? An easy question is whether you should do your own lawn maintenance or not. If it’s something that brings you joy or energizes you, the quick answer is keep it.

However, what if you, like me, perceive it to be a chore that must be done? It’s just one more burden of an overburdened life. I can do my lawn maintenance. I am “qualified.” I even have all the tools. However, if I don’t find it enjoyable, should I pay someone to do the work instead of me? Should I outsource this activity so that I can do something else? In my case, the answer is yes. I’d rather write an article a month to cover the cost of doing my lawn maintenance rather than doing it myself.

In the case of lawn maintenance, for me, it’s not a core competency. Writing, on the other hand, is. If I could take a few hours and “crank out” an article and make enough to pay for the lawn maintenance that month, which is a better use of my time? Of course, this assumes that I can get the article assignments.

Breaking the Shell

The chick is struggling to break out of its shell. You can see its struggle. You can imagine yourself in their position. You would want help. Shouldn’t you help the chick break free from its shell? Only if you want to sentence it to death. You see, chicks need the struggle to break out of their shell, just like we as humans need our struggles. (See How Children Succeed for more about our need for challenges.)

It turns out that, if we don’t have challenges, we never develop the toughness that’s necessary for our long-term survival – and for our ability to thrive. If you’ve not been able to struggle, then you’ll grow up believing that others are there to remove all the barriers in your way. It turns out that this self-centered approach to life isn’t good for your contribution to society – or to your happiness.

Happiness Worth Devoting Yourself To

Happiness is hard to come by. Finding lasting joy is a life’s work, and one that many have tried to capture directly or indirectly in their writing. (See Stumbling on Happiness and The Happiness Hypothesis for two direct approaches to finding happiness.) Time and time again, studies reveal that people are in relationships are happier. Married people report being happier on average than their non-married friends. That is to say, those in marriages had an intimate connection with another human being. (See High Orbit – Respecting Grieving for more on Dunbar’s work on social connections.) Certainly, some marriages are dysfunctional and doesn’t provide that connectedness, but on the whole, this connection added happiness to both lives.

If we look back at John Gottman’s work, as described in The Science of Trust, we find that he identifies “Make Life Dreams Come True” as one of the key foundations to sound relationships. How Will You Measure Your Life? describes it as “the path to happiness is about finding someone who you want to make happy, and someone whose happiness is worth devoting yourself to.” One key to how I’ll measure my life is my relationships – with my wife, with my family, and with those who I have the privilege of spending time with. Spiritual Evolution remarks, “Nevertheless, on their deathbeds more people probably rejoice in having raised children than in having achieved precious moments of meditational Nirvana.” The One Thing quotes from The Top Five Regrets of the Dying. Second on that list is “I wish I’d stayed in touch with my friends – too often they failed to give them the time and effort they deserved.”

Jobs for Experiences

When you’re searching for your next opportunity, there are all sorts of variables to consider. You can consider the financial gain you’ll get. The authority that you’ll have. Perhaps it’s stability that you crave and that you’re seeking. (See Who Am I? and The Normal Personality for Reiss’ 16 factor model for understanding peoples’ motivations.) One of the useful and longer-term views is to look at the next opportunity from the lens of whether it will create the experience that you want in your life.

Once you’ve determined what you want in your life, you can start to architect your decisions on the path that is most likely to lead to that goal. You may not become a famous author or a motivational speaker, but if these are your aims, there are steps you can take to get closer. You can join writing workshops to learn the skills necessary to become a better writer. You can take classes to become a better speaker. (Or do something crazy like take a class on stand-up comedy like I discussed in my post I Am a Comedian.)

My Measuring Sticks

For me, I’m not looking to keep score. Somewhere along the line, I missed the class on status being important. I’m quite happy to drive an average car. I’m happy in the home that I share with my family. I’m going to measure my life based on the way that I can positively impact others. My wife, my family, and my friends are the way that I’m going to measure my life.

To get there, I’ve got to continue to make money through work, but I’ll do that too from the lens of trying to help others. That, is how I’m going to measure my life. So How Will You Measure Your Life?

What’s Your Cloud Strategy?

I love learning how people come from different places based on their perspectives. The March 2017 meeting of the Indy CIO Network took up the topic of cloud strategy and the conversation was remarkable.

What Kind of Cloud?

As a pilot, I was trained to identify different kinds of clouds so that I could avoid getting caught in weather that either the pilot (me) or the plane couldn’t handle. I came to appreciate the number of different kinds of cloud formations there were and how knowing what they were could keep me safe.

When we’re talking about technology clouds, there are a few options:

  • Infrastructure as a Service (Iaas) – Virtualized machines that you can manage as if they are on premises.
  • Platform as a Service (Paas) – Containers that you can deploy your solutions into to take advantage of larger data centers and other resources that may not be practical to deploy yourself.
  • Software as a Service (SaaS) – A software package licensed with hosting of the application included. This bypasses the hidden maintenance costs of running a server and managing a software package.

With flying, the challenge was always safety; with the technical cloud, it comes down to security.

Security – Better or Worse

On the one hand the availability of cloud-hosted resources would seem to have a worse security profile than something locked away in our respective data centers. After all, availability and security have been natural-born enemies since the beginning of time. It intuitively makes sense that if it’s more available then it’s got to be less secure.

On the other hand, the cloud service vendors generally have better resources than a small- or even medium-sized company might have to purchase intrusion detection and pay security analysts to continuously monitor what’s happening on the systems. So they’re a bigger target in aggregate, but they’re also bringing substantially more resources to bear than we could if we had the services in our network.

From a practical point of view, the surface area – or availability – isn’t all that different between a server hosted in the cloud platform vs. one that’s on your local network. Most organizations recognize the need for employees to work while traveling. As a result, virtual private networks (VPNs) have become common, so most employees really have availability to get to information no matter where they are on the planet – or in the air.

In the end, the kind of security technology being deployed and the rigor of the security policies – including checks and balances – generally means that cloud-hosted systems are more secure, even if this seems at times to be counter-intuitive.

Goals

The group agreed that cloud hosting doesn’t save you direct costs – or at least not much. What the cloud services give you are features that you can’t afford to implement on your own. Whether it’s a service level agreement (SLA) that includes a lot of 9s or elasticity, cloud isn’t about cost savings. It’s about mindshare and capital savings.

In some scenarios, the goal is to increase uptime and geographic diversity to handle outages in a way that just isn’t practical to do internally.

Very High Availability

Some systems just can’t be down. The business cost of being down, both directly and in terms of the brand damage, are just not tolerable. Even when the primary operations are on your environment locally because of proximity or other needs, having the ability to switch to a cloud backup when you’re not able to service customers is essential.

While there are very high profile outages at Microsoft, Amazon, and others, these outages are, generally speaking, quite rare. The amount of redundancy that exists in their environments simply isn’t practical for the mid-sized organization to buy.

The Real Risk and Opportunity

It seems that the real risk and opportunity with developing a cloud strategy is scaring your IT professionals with not having a job. My observation, and those of some of my national peers, has been that it isn’t IT professionals losing their jobs – it’s that their jobs are changing to be more customer-focused and interactive.

So while the fear of being replaced is there, the real opportunity is for our IT staff to become more closely aligned and embedded in the organization, so that IT isn’t seen as something distant and far away, but is instead seen as a partner trying to help the business get things done.

Quick Tip: Microsoft Excel: Counting Values

Every once in a while, data needs to be reviewed after it has been entered. Maybe you need to figure out how many cells have a value in them – or how many are empty. In this quick tip, I’ll show you an easy way to tally up the number of entries in your table by counting values.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Book Review-Start with Why: How Great Leaders Inspire Everyone to Take Action

Lights. Camera. Inaction. Wait, that’s not right. Lights. Camera. Action. We all want action. We want to see people extraordinary and ordinary take action, to do something. We want to see the triumph of human achievement. We want to be inspired to take action. All too often, we’re stuck going through the motions. We step forward each day, not realizing the path we’re on or even why we’re on it. That’s what Simon Sinek wants us to do in his book Start with Why: How Great Leaders Inspire Everyone to Take Action. He wants us to question the “why” of our journey so we leap down the path instead of trudge down it.

Building a Cathedral

There’s an old story recounted in Start with Why that bears repeating (and slightly reinterpreting). A man walks up to a mason who is busy with his trowel, and interrupts him with a question whose answer seems obvious: “What are you doing?” The man in a slightly grumbled voice answers, “I’m slaving away, laying one heavy block after another in the scorching hot sun. The work has gone on for as long as I remember, and I see no end in sight.” The stunned interviewer turns to the guy next to him, who is building the same wall, and asks him what he’s doing. The answer was shocking in its simplicity and powerful in its enthusiasm. He said, “I’m building a cathedral!”

Both men were working on the same wall. They endured the same conditions. They likely received similar pay. Everything about the men was the same, except the attitude of the second man was different. He wasn’t struggling to lift each block and place it. He was inspired. He knew what he was creating. He had the power of his why. He got to participate in the building of a cathedral.

The Rebel Within Us

Have you ever wondered how a motorcycle company that had a bad quality record and a lousy delivery record ended up becoming a cultural icon? The answer lies within us. Have you ever wondered how a computer company could ignite a revolution, lose its way, and begin to inspire us again?

At the heart of this power is the need for us to be rebellious. We need the ability to find a way to differentiate ourselves. It’s wired into our DNA as a way of ensuring that we can find a mate and reproduce, thus copying our genes. We need rebellion so that we can stand out from the herd and be found. (See
Fascinate
for more on the motivator of rebellion.) Harley-Davidson motorcycles capitalized on this rebellious nature in their branding, and they became popular motorcycles, in part because it felt like a bit of sanctioned rebellion to own one.

Apple’s ads have routinely attacked the status quo. Whether it’s the classic 1984 super bowl ad or their “I’m a Mac” campaign, they focused on the need to be an individual and stand free from the pack.

Sanctioned Rebellion

It’s a bit of an oxymoron. It’s internally inconsistent to say that you’re rebellious within the acceptable boundaries. If rebellion allows us to stand out and be found by a potential mate, why hasn’t society broken down? The problem with rebellion is that it gets you mates – or it gets you fates. That is, those who can be picked out as outliers are often the ones who are separated from the herd and eaten. So how do you be rebellious enough to get a mate but not so much that you’re separated from the herd?

The LA riots following the trial of four officers for beating Rodney King were certainly a period of rebellion. Whether this was a necessary or appropriate response or not, it left 50 people dead, 2,000 injured, and damage to over 1,000 buildings with estimated costs exceeding $1 billion. During this time of rioting, there was arson, looting, beatings, and other forms of lawlessness. However, if you look carefully at the photographs of the riots, you notice something odd. Looters and arsonists parking in between the lines in parking spots in the parking lots. Even at the peak of anger and rebellion, at least some of the looters didn’t want to disregard the social expectation to park between the lines.

We want rebellion, we want change, and in this case the actors wanted to cause harm. However, they weren’t willing to tear down the fabric of their reality and abandon everything they had known. Even in their moments of lawlessness they needed the structure of society.

Why did the riots happen? The perceived injustice at the freeing of four white police officers who beat a black man that was caught on tape. (I agree that it was an injustice but that’s not the point.) For a moment, a small voice in the crowd spoke a “why” to an angry crowd. The “why” was simply “something has to change.” This resonated so clearly that the message spread and the riots were started.

The Secret to Success

The bookshelves are filled with books that purport to have the keys to business success, yet over 80% of businesses will shut their doors within their first five years. It’s not that business owners aren’t reading the books – it’s that there’s no one answer. (Though I’ll say that most business leaders don’t spend enough time trying to learn more about new techniques to make them successful.)

In Search of Excellence and Built to Last both seek to find a formula for making large businesses successful over the long term. The Halo Effect describes the works of Peters and Waterman as well as Collins as better stories. There aren’t secrets here. The companies that In Search of Excellence identifies as “winners” aren’t necessarily winners anymore. The same can be said about the companies identified as “visionary” in Built to Last. Of businesses on the Fortune 500 list in 1955, 88% were gone by 2014. While there are some companies that have survived the test of time, they’re in the very serious minority. Even well-established companies like Barings Bank can come down in an instant when people forget this “why”.

Sinek implies that the secret to success isn’t in what organizations do or even in how they do it, but that they have a central “why” that helps to align the employees around the same mission. It’s like the focusing power of a Fresnel lens on a lighthouse. It keeps all the stray light into the main beam just like having a mission has. But lots of organizations have mission statements – what makes organizations really succeed?

Maybe it’s Lencioni’s observations in The Advantage about the need to overcommunicate. Maybe mission statements for most are, as The Heretic’s Guide to Best Practices suggests, simple platitudes.

Mission not Message

Many great leaders are recognized for their great messages (see Great Speeches for Better Speaking). There are numerous books that focus on refining your message and communicating more effectively. (Buy-in, Crucial Conversations, Dialogue: The Art of Thinking Together, Influencer, Infographics, Pitch Anything, Platform, Presentation Zen, Slide:ology, TED Talks, The Art of Explanation, and Trust Me: Four Steps to Authenticity and Charisma are a few.) However, what helps organizations succeed over the long term isn’t the messaging. Manipulations – and messaging – can be effective in the short term, but in the long term they’re not enough to make something last. The problem is that each manipulation leads to the next, just like an addict who needs the next fix to get past the crash from the last one.

When the mission is right – and the people are really aligned with the message – extraordinary things can happen. Heroic Leadership tells the tale of the Jesuits and their insistence on keeping the mission above the people and above the doctrine of the religion. This mission, to bring Christ’s love to others through their words and particularly their deeds, has allowed the organization to continue for over 450 years despite numerous challenges. While the Jesuits might be an extreme case, having a mission makes it much easier to make everyday decisions. By knowing what you believe – your “why” – you have a guide for all the minute decisions that have to be made every day.

Influencing Behavior

Leaders are necessarily purveyors of control. Their goal is to shape the direction of others – to lead them in the direction that the leader chooses. Their tools are sometimes described as manipulation, but sometimes their tools are inspiration. Manipulation (sometimes called motivation to avoid the negative connotations) is the tool of choice for many leaders. It’s the quick fix of a candy bar with none of the sustaining effects of a well-balanced meal.

There are plenty of books and professionals who purvey these quick fixes to your leadership problems. For instance, books like 365 Ways to Motivate and Reward Your Employees with Little or No Money are a list of techniques for motivating employees with ways that don’t need money – and you don’t have to really think about. I’m not discouraging the use of the book. It’s a useful tool, but only as a way to supplement an inspired workforce fed on a well-balanced inspirational meal. Candy is fine as a snack or a treat, but it’s not sustainable.

Manipulation

Manipulation can also take a less positive turn in the form of fear. Fear is without a doubt a powerful motivator. However, fear has a long list of negative consequences, spelled out in Why Zebras Don’t Get Ulcers.
Fear doesn’t have to be the boss screaming at you about how bad you’re doing or how worthless you are – though those are good examples of bad behavior. Sometimes the fear is expressed in the power of a forced exchange.

Too many Americans live paycheck-to-paycheck with no reserve for losing their jobs. Depending upon the way you count it, somewhere between 40% and 62% of Americans don’t have the ability to live without their steady paycheck. As a result, leaders can – and sometimes do – threaten folks with their job as a form of manipulation. It’s a forced exchange, money for compliance, and people don’t believe there are any other options for them. This is a form of manipulation rooted in fear – just less overtly.

There are, at the same time, manipulations which are neutral or even positive. We may all have been manipulated into wearing seatbelts – but that’s an OK manipulation because it is for our best interests (see Unsafe at Any Speed). Nudge wouldn’t call this “libertarian paternalism”, because there’s no reasonable choice.

Choices are sometimes hard for folks to make. Despite Glaser’s articulate explanation of Choice Theory, there are still many choices where there are conflicting drives and desires. Motivational Interviewing is one technique for managing these conflicted situations and are in effect a manipulation no more or less than having a chiropractor manipulate your joints.

The problem with manipulation is that there are going to be some people who are hard to control with manipulation. Perhaps they’re resistant to fear tactics. Perhaps they can see the manipulation coming. In any case, not everyone is so easily manipulated and therefore, they make manipulation hard to do.

Inspiration

The heart of inspiration isn’t our rational minds. The heart of inspiration is our heart – or in the language of Jonathan Haidt – our elephant. (See The Happiness Hypothesis for the Rider-Elephant-Path model.) Inspiration is an emotional response. It’s something that Demand describes as magnetic. It has emotional appeal. Inspiration is looking forward into the best possible future and placing a stake in the ground that this is the place we want to be.

Gratitude and Humility

One of the most inspiring traits for me are the dual traits of gratitude and humility. Being filled with gratitude is a humbling experience. It reminds you that whatever power you have should be held in service to others. (See Humilitas for this definition of humility.) Robert Greenleaf implored us to be Servant Leaders. And while his advice was great personal advice for being a better leader, it has the effect of inspiring everyone in the organization towards the humility of the leader and the mission they uphold.

If we look back at the Jesuits through the lens of Heroic Leadership, we see that St. Ignatius of Loyla was a leader with such deeply-held convictions and humility that inspired the Jesuits to be better people. The character of the leader is the inspiration that some people follow.

Many years ago, while at a National Speakers Association convention, I heard for the first time a powerful phrase. It was simply “The Privilege of the Platform.” It was said to remind the speakers there that the stage (platform) that they were standing on, and the fact that so many people were generously giving their attention, was a privilege. It was a bit of humility in an otherwise ostentatious group.

Showing Up for Inspiration

When Martin Luther King, Jr. stood at the feet of the Lincoln Memorial and gave his famous “I have a dream” speech, how many people came out for Dr. King? Officially, the number of people who turned up was 250,000. However, how many of them came up for Dr. King? In truth, we don’t know; but what we do know is most the folks who came to hear that speech came for themselves. They wanted to be identified as the kind of people who cared about civil rights, equality, and free speech. Their attendance that day said more about them and what they wanted to do rather than the following of Dr. King.

Herein is a fundamental truth. Leaders inspire people not to their cause but to live out the causes that are already within them and to attract to themselves those who have similar values.

Marketing the What

When you’re reading marketing books, there is a lot of push towards helping people with what you do. (Guerilla Marketing, Duct Tape Marketing, and The New Rules of Marketing and PR are good examples.) They’re all about helping organizations and individuals understand what you can do for them. A good sales process is about helping the prospect understand how you can make their life better. You’re looking for the pain that you can solve. (You can look at The Challenger Sale for more on the sales process.) However, what Sinek is proposing is that this is backwards. He concludes that people need to know why you’re doing what you’re doing before they know what you’re doing or how you’re doing it, so they can decide whether they care, want to pay attention, are similarly motivated as you.

Here Sinek provides some compelling examples of messages that start with why, flow through how, and end up with what you can do for a customer. Certainly, there are places where this makes sense. However, as I pondered his writing with some thought experiments, I wondered “why” a landscaper did what he did – and whether that would resonate with customers. Perhaps he wants to create relaxing spaces for everyone or he wants to be able to work outside. In either case, I don’t know that I care if I’m hiring him to mow my lawn. (Which is the work that most landscapers do because it’s steady and pays the bills.)

In my own case, I know that my “why” for technology is to make the complicated simple. In our healthcare work, we do work to prevent people from being harmed. However, my friend Paul Culmsee would challenge me that these sounds like platitudes. In his book The Heretic’s Guide to Best Practices, he challenges us to reasonably disagree with a statement as a test to ensure it’s not a platitude. I’ve found some technologists who really do try to make the simple complicated – and I know from our conversations that he has as well, so there I think I’m safe.

The harder one is preventing people from being harmed. The Hippocratic oath is to do no harm. We do occasionally see providers who aren’t working in their patients’ best interests, and instead are performing useless procedures because they’re being paid fee-for-service and therefore making money only when performing services.

Does knowing what drives me cause anyone to work with me more (or less)? I don’t know. It feels like knowing this isn’t a strong motivating factor one way or the other.

Customers and Competitors

One interesting difference between our customers and our competitors is that competitors tend to see the differences between themselves and their competitors. They’re keenly aware of the differences in the offerings and what that means to the customer. This is the curse of knowledge happening. They know so much about the situation that they’re literally disconnected from the view of the customer. (See The Art of Explanation for more on the curse of knowledge.)

Customers are, however, much less sophisticated. They see a solution to their problem, and they tend to underestimate the value of the differences between products, because the differences are too nuanced and subtle for them to really understand.

Similarly, competitors, innovators, and trail blazers can’t ask customers what they want, because they don’t know. Ford is reported to have said that, had he surveyed his customers, they would have said they wanted a faster horse – not an automobile. Clearly an automobile is better than a faster horse, but the customers had no frame of reference for asking for it.

Lifting You Up

The true power of “why” isn’t in whether you can attract more customers or even in being a better leader. The true power of “why” is in giving you the willpower or grit to continue when your day-to-day life is grinding you down. (See Grit for grit and Willpower for willpower.)

I’m getting a clear picture of my “why” – of why I do what I do what I do. I don’t know whether it will help me be more successful or whether it will just bring me more peace. However, I know that I want to Start with Why and let things come as they are going to come.

How to Not Get Sucked in and Everything You Know is Wrong

In my volunteer work, I recently put together a set of presentations for leaders that I wanted to make available for others as the program matures. That meant going into the studio and recording the sessions for posterity. The sessions are “Everything You Know is Wrong” (30 min) and “How to Not Get Sucked in” (20 min).

“Everything You Know is Wrong” is designed to address the certainty with which we believe that we know what we know. In the volunteer work we’re doing, we have teenagers who are sharing their perspective on their home situation and their life. I wanted volunteers to be suspicious of what the teenagers are saying, and more broadly about the certainty with which they believe what they know.

“How to Not Get Sucked In” is the main event and it explains how you can volunteer without becoming too attached and too sucked into someone else’s world. I explain what compassion is – and, more importantly, what it isn’t – so everyone can know how to keep from getting sucked in.

Auto-Fill-Formulas

Quick Tip: Microsoft Excel: Auto Fill Formulas with Dollar Signs

This quick tip will allow you to set down your calculator. Not only can Excel calculate formulas with your data, you can use Auto Fill to repeat those formulas across the spreadsheet, even if you’re working with currency. I’ll show you how you can Auto Fill formulas with dollar signs in Microsoft Excel, and let it do the heavy lifting for you.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Book Review-Warning: Psychiatry Can Be Hazardous to Your Mental Health

It’s an odd title for a book. Why would a psychologist title a book Warning: Psychiatry Can Be Hazardous to Your Mental Health? The answer lies in the belief that drugs are not the answer to all of the mental health problems of the day, and that in truth many – if not all – of the mental health problems that we have today can be traced back to a single source: unhappiness. While happiness itself is hard to define and even harder to find, the lack of happiness seems to manifest problems in our mental states as well as our physical bodies.

Dr. Glaser has written several books including two books that I’ve previously reviewed: Schools Without Failure and Choice Theory. Fundamentally, Dr. Glaser believes that we all have choices to make, and it’s understanding those choices that frees us from the bonds of unhappiness. Here, he extends his views into the ills of psychiatric drugs.

Placebo

I’ve addressed before the powerful effects of placebos and my belief that they’re driven by hope. (See The Heart and Soul of Change.) Dr. Glaser shares that, in some studies, patients who were getting better immediately relapse when they’re given the news that they’ve been receiving a placebo. It’s too difficult for them to accept that they were getting better based on their beliefs not on an external drug. Placebos work because we believe that what is being done has the capacity to heal us, to make us better, and to make it alright. If we just take the blue pill, we’ll find that we’re alright soon enough.

While ethicists that I know don’t believe that we should always give patients a placebo and tell them it’s an experimental new therapy that might work in their case, I’m not so sure. Perhaps my ethical boundaries get a bit blurry when we’re talking about eliminating human suffering. Perhaps I’m underestimating the damage to trust that it would do to tell someone they’re in an experimental program. However, I’ve got a strong desire to experiment with how effective I could get placebos to be by infusing patients with hope.

Efficacy

Efficacy is interesting in clinical studies. In order to be significant, there needs to be a sufficient difference between the control group receiving the placebo and the study group that’s receiving treatment. Unfortunately for psychiatric drug manufacturers the placebo effect is quite large. This means that drugs have to show a very high degree of efficacy in order to have a significant effect.

Some studies for some drugs have shown these larger effects, but the effects aren’t nearly as large as people would like you to believe. While drug companies can claim that 50-60% of people taking their wonder drug got better, they neglect to mention that 47-50% of people got better on placebo. Basically, there’s a maximum of a 13% difference – and a mean of 6.5%. A lot of money is being spent on small chances at making things better.

Long Term Effects

What is worse is that the long-term effects of these drugs are known to be potentially very bad. For instance, 25% of people treated for five years with schizophrenia medications will develop tardive dyskinesia, which is characterized by repetitive, involuntary, purposeless movements. Stopping medications won’t stop tardive dyskinesia. Once the damage has been done, it can’t be reversed.

Selective serotonin reuptake inhibitors (SSRIs) are another class of drugs that, while widely-used, have questionable long-term impact and incredibly short (6 weeks!) studies of their efficacy. (See Science and Pseudoscience in Clinical Psychology for more about SSRIs.) Some animal studies have shown the prolonged exposure to SSRIs causes the brain to down-regulate the number of serotonin receptors that the brain has.

Study Sources

It gets worse. The studies that we do have to prove marginal effectiveness of these drugs are sponsored in most cases by the very pharmaceutical companies that want to sell the drugs to the market. While this is in some ways to be expected, because they have the financial advantage if it sells well, it also raises the very real concern about undue influence in the study results.

If you don’t believe it can happen, consider the incorrect link assigned between vaccinations and autism. It was an article in The Lancet has since been retracted: the collaborators on the article indicated that they weren’t aware of the lead author’s ties to a group trying to prove that vaccines were harmful. The lead author, Andrew Wakefield, has lost his license to practice medicine and in professional circles has been thoroughly discredited. However, the myth of the correlation between vaccinations and autism persists. Millions of children each year aren’t vaccinated due to one bad author and the one bad study.

Study Issues

Even if you accept honorable intentions, it’s estimated that 40% of peer-reviewed published research articles contain statistical errors. That’s just statistical errors. That doesn’t account for any leakage of information, accidental bias, or other introductions into the study which unduly influenced the results. If you run enough studies over a long enough period of time, you’ll eventually find a way to prove what you want to prove. Some hidden variable will appear in the data and you won’t be able to factor it out. (See The Black Swan for more on unexpected events.)

Having been in and around the publication of a few studies myself, I can say that all too often what is in the study design and what makes it into the paper is a small fraction of the important factors that led to the results. The reason that folks want multiple studies confirming the same thing is that too often studies are proven to be false or insufficient to demonstrate the effect that was expected.

A Better Alternative

So while insurance companies pay for the prescriptions to these psychological drugs for years and years, rarely do they pay for more than a few therapy sessions. While there is support for a limit to the number of sessions for effectiveness, the insurance minimums are often too short to provide any real impact. Instead the insurance company will pay for drugs for years and years.

Again, my proximity has led me to the awareness that insurance companies don’t expect members to be in the plan long enough to take on substantial upfront costs – like counseling – when low-level, long-term costs are sufficient. In short, they’re willing to keep people on drugs that mask the symptoms rather than solve the root cause, because their cost over the time they expect to retain the member is lower. (Talk about disincentives.)

If people could resolve their unhappiness, they wouldn’t need continuous drugs. In fact, George Brooks found that medication wasn’t enough to allow schizophrenic patients to leave the hospital. They needed psychosocial rehabilitation – at the end of which the drugs were no longer needed.

Let’s Get Together, Yea, Yea, Yea

The theme song for The Parent Trap says, “Let’s get together, yea, yea, yea” and it hides a certain truth: that we are social creatures, and that much of our happiness is gained in our relationships with other people, whether it’s understanding the different levels at which people relate as I discussed in High Orbit – Respecting Grieving or The Gifts of Imperfection.

A Science magazine article indicates that isolation “is as significant to mortality rates as smoking, high blood pressure, high cholesterol, obesity, and lack of physical exercise.” (See The Psychology of Hope for more.) Clearly we have to be in relationship with other people to be healthy physically.

Don’t Worry Be Happy Now

It would be great if it were as easy as deciding to be happy and suddenly you would become happy. It would be amazing to be able to make the decision to transform your life from one of stress and anxiety to one of peace and tranquility. In truth, this is sort of the case. Ultimately it’s a decision to view the world differently and choose different behaviors; however, the process is neither simple nor easy. It’s not as easy to, as Bobby McFerrin says, “don’t worry, be happy now,” but it is possible.

The process sometimes requires the assistance of drugs in the short term to lift someone out of the pit of depression. The drugs provide enough support for someone to do the work to change their perspective. Once sufficiently lifted from the clutches of depression, Dr. Glaser believes in his Choice Theory, which states that it’s our attempt to control others that makes us unhappy.

In short, if we can just allow other people to be separate people, and not try to control them, then we’ll be much happier. Though this is easier said than done, it is something that can be transformational.

Transformational Breakthrough or Emotional Breakdown

Looking from the outside in, it’s quite difficult to distinguish between a transformational breakthrough and an emotional breakdown. The observable behaviors are the same. We see a rapid transformation in someone. Often, there is a lot of weeping and gnashing of teeth in both scenarios. It’s not a pleasant experience. However, after a transformational breakthrough, the clouds part and the skies are bright and shiny. With an emotional breakdown, there’s no clearing of the skies, and often the person feels stuck.

It’s very little wonder that a psychiatrist can’t tell the difference between a transformation and a breakdown. In the appendices, Dr. Glaser provides space for some other authors to share their stories. In one of the stories, a professional shares how he was himself on the wrong side of the profession. He was almost committed by his colleagues and spouse into institutions, and he was able to experience what it is really like to be a patient. His only recourse was to voluntarily commit himself so that he could leave on his own.

The triggering event in this case was really about questioning the path to recovery of patients. In questioning the status quo and transforming his thinking, he was considered to have a mental disease. His colleagues and spouse couldn’t see that he was gaining a new level of understanding – perhaps because this would have meant that they were missing something.

Conversion Disorder

Glaser believes that our psychological ills – our unhappiness or lack of mental health – causes our bodies to react in negative ways. This is consistent with the research of Spolsky in Why Zebra’s Don’t Get Ulcers. His belief is that many – if not all – of the diagnoses in the DSM-V (DSM-IV at the time of his writing) can be explained by the fact that people are unhappy, and the diagnoses in DSM-V are simply manifestations of that unhappiness.

Many of the non-specific cause illnesses he attributes to a lack of mental health. He suggests that, as people learn to be happier, their physical symptoms will eventually subside. While I am certainly not qualified to speak for every physical condition, I can say that I’ve personally seen remarkable changes with people who have become happier. Their physical issues are reduced.

At the heart of these changes and the increased happiness is a connection with others.

Group Think

One of the interesting structural decisions for the book was that it follows the path of a couple who were struggling with their own selfish and controlling needs through their recovery and sharing their discoveries with a group of their friends in a book club. The structure of the book is different than most in that it follows a story arc from the initial awareness of the ideas to how those same ideas apply to others in different situations.

Ultimately the book seeks to create groups – self-supporting, no-fee groups – that speak about Choice Theory and how it can positively transform lives. While I don’t believe this movement ever gained ground, it is a noble idea. The idea that groups – much like the concept of an AA group – could help improve the health of its members and provide them with the connections they need to become healthier is certainly an idea worth trying.

In fact, just reading and pondering on the thoughts inside of Warning: Psychiatry Can Be Hazardous to Your Mental Health is a worthy endeavor as well. After all, difficult or not, you do have a choice to be happy.

trainer

Article: The Actors in Training Development

There’s a lot of attention on new delivery models, the desire to create shorter courses and the attempt to apply metrics to the training process. However, relatively little is being said about the fundamentals of the content development process. While there are absolutely differences in the way content is generated from one medium to another and from one organization to another, there are more similarities than there are differences. This article is the first in a series that will walk through the roles in the process, including how the process fits together and how the individual roles add to the result.

The start of the TrainingIndustry.com series, the Actors in Training Development. Read more…

deploy-devops

Article: Anatomy of a Software Development Role: DevOps

It’s been nearly a dozen years since I first wrote “Cracking the Code: Breaking Down the Software Development Roles” and the associated specific role articles. The world has changed substantially in the last dozen years, but strangely, relatively little has changed in the roles for software development—except in the transformation of the deployment role into what is now being called “DevOps”—a contraction of Development-Operations. In short, we’ve changed how we operationalize the deployment of our code into our environments and into customer systems. It’s time to address the changes that have come to the world of software deployment.

Part of the developer.com series, Anatomy of a Software Development Role. Read more…