Category: Everything else

My writing coach had an important tip for me – “Write like you want to convince someone.” Art and judgments go hand in hand, I learnt. You have to pick a side and speak with your biases. If you’re not willing to take a stand and describe what you believe, then you’re just being a hypocrite.

Shawn Coyne has a great post up on Steven Pressfield’s blog today called “Art and Polarity.” Below are the excerpts .

---

The other day I overhead this conversation:

Man #1: “I ran into Frank Smith (not his real name) at the beach yesterday…”

Man #2: “Isn’t that the guy who cheated on his wife, got a DWI, and said all of those nasty things about Jill’s daughter in law?”

Man #1: “…Well…yes…but I try not to judge.”

I run into this “I don’t judge” stuff a lot and it infuriates me on many levels. But as this is a blog about what it takes to create art, I’ll just address why this “moral position” is at best hypocritical and at worst a force as undermining and dark as Resistance.

Not saying something is uncaring. Not saying something means that you do not want to put your ass on the line and take the risk that you’ll be shunned for your opinion. It has everything to do with you. Nothing to do with the other person.

I’m aware that the world is not black and white. There are shades of gray between the two poles of every value. On the spectrum of “Truth and Deceit,” telling a white lie when your cousin asks if she looks good in her bathing suit is not the same as running a billion dollar Ponzi scheme. I get it.

And yes, most of the time, keeping our big mouths shut is the right thing to do. We’re all guilty of misdemeanors and don’t need Earnest Ernies pointing out our shortcomings. And when we do confront someone about their actions, we need to do it with tact and care. That’s empathy.

But this “non-judgment, I toe the middle line” attitude is dangerous. There is no middle line.  Not judging is a judgment.  And it pushes people away from each other—I best not make a mistake and judge anyone or no one will like me…best to keep quiet and be agreeable—instead of bringing them together—I thought I was the only one who thought Animal House was genius…

The man I overheard who doesn’t “judge” the adulterous, alcoholic driving, rumormonger sends a message to the world that destructive actions are excusable. It is what it is… There is no right and wrong. Nonsense.

But it is his passive aggressive dressing down of the other guy for “judging” someone guilty of antisocial behavior that is even worse. It masks his cowardice as virtue. And to not judge whether something is right or wrong is the furthest thing from a virtue.

You must choose a position in this world on innumerable moral questions and stand by your judgments. Woody Allen made this point in six lines of dialogue. Ken Kesey riffed on it for an entire novel. It’s important.

If you are an aspiring artist and you wish to avoid “judgments,” you’ll find that you have nothing to say.

---

As Seth Godin pointed out in his recent book, Steve Jobs was known to take strong views on one side one day and then flip to the other the next. The magic of Steve Jobs wasn’t that he was right.. it was that he was sure. He built products that resonated with his principles and refused to compromise – you can say what you want about Apple’s products but you have to admit that they aren’t a mish-mash of design principles.

There is a lot of gray in this world but there’s a fair bit of black and white too. If we’re running away from seeing the black and white using the gray as an excuse, then we’re only kidding ourselves.

When a player in Benjamin Zander’s orchestra makes a mistake (or on occasions Zander himself), Ben makes it a point to stop and say, with a beaming smile, “HOW fascinating!”

The best managers I’ve worked with are those who don’t rub it in when I make a mistake. If you care about the work you’re doing, then the very experience of making a mistake tends to hurt just enough.

Things get interesting when we then ask ourselves – how do we manage ourselves? Research reveals that we are all largely horrible managers. We are too hard on ourselves and shoot ourselves in the foot for our mistakes when it is completely unnecessary. Why else do most attempts at building willpower and creating great habits fall apart 6 days after the new year?

So, just for today, if you catch yourself or someone around make a mistake , erase the “oh sh*t” reaction, give a big smile and say.. “HOW fascinating!”

And hey, if it works, it might be worth continuing the practice tomorrow as well.

Pivot tables are the Excel gods’ greatest gifts. There is no better analysis tool within Excel.

As today’s example (download here), I’ve highlighted how you can analyze the amount of discounts and rebates that each customer receives within seconds. Insert pivot table, select the rows and columns that you want summarized and you are done! Just copy out the values for any analysis or chart. (We’ll be covering charting in a separate post)

3 things you must know about pivot tables –

1. The applications of pivots are huge. If you use Excel to track your accounts/expenses or your company’s expenses, you are just a step away from using pivots to view your data in many different ways.

2. The best way to become proficient in pivot tables is to do many of them. As you begin exploring them, you will come across many options to display your data differently to suit your needs. Just make sure you check out “Pivot Table Tools” and go through them.

3. If your job involves analyzing millions of rows or perhaps creating interesting pivot charts, you might want to consider a microsoft add in called “PowerPivot.” I haven’t used this myself but have heard good things.

Bottom line: If you’ve got a large set of data, don’t bother too with formulas. Just use pivot tables. They are very easy and you can get any kind of cut you want within seconds. You don’t have to be a superstar analyst to use them – they take 10 minutes to learn and will save you more time than you can imagine.

---

Series introduction, Part 1 (Set up), Part 2 (Shortcuts), Part 3(SUMIFS, COUNTIFS), Part 4 (INDEX+MATCH)

Decisions come in all sizes and we make a whole lot of them. For a long time, I’ve wondered how you make good decisions – well, more good decisions than bad ones. If decision making is a skill, there ought to be a framework and a process for getting better. Here are my steps.

First, define “good.” In my case, “good” is not looking back 6 months down the line and saying “Damn it. I knew better.”

Second, figure out a process before you arrive at a big decision. Mine involves 3 steps –

1. Do your research and form an opinion.

2. Seek counsel – align why’s and how’s. This means going to wiser friends and figuring out how they would approach a problem. The first step is figuring out who would be best placed to help – this is done by understanding their motives/”why” and “how” they would approach it. More often than not, folks you go to for counsel/advice are aligned on “why” because they get you and why you do things and would probably do things similarly. So, the next step is to test if their approach is something you would be comfortable with.

3. Understand the other end of the stick. This is something I don’t do nearly as well as I should. Once you know a path forward, try and sit beside a strong thinker and understand what the decision implies. Every decision closes some doors and it helps understanding what the consequences of your decision could be (financial, emotional, etc.)

Third, whatever your decision, just run it by yourself and pay attention to that feeling at the pit of your stomach. Sometimes your gut rejects the most logical of decisions and gives you an unpleasant feeling. My learning has been to listen to it.

And finally, treat your decision like Gandhi did – as an experiment. It might not work. And that’s okay. Track the results and use the feedback you receive from life to tailor your decision making next time around. Like most things, it’s an iterative process but it’s a process worth paying attention to because there are few skills as valuable as learning to make decisions you can live with.

Dan Ariely had a great tip when we asked him about productivity – “I basically try not to waste time. What I do is when I get tired of one task, I move to another one. I think often when people get tired of one thing, they think “let me go to Facebook, and I’ll get some energy and I’ll go back to this.” When I get tired of one thing I just switch to something else. I think the amount of hours I end up working is much higher because of that.”

I am one of those who checks my RSS feeds/email when I get tired of a task. My aim for the week is to implement Dan’s approach. I find that a pre-requisite for this approach is a well planned list that includes a slew of work and personal tasks. That way, you just need to toggle back to the list and pick up the next one when you are tired of the current one.

More to follow.

Success does beget success. When Malcolm Gladwell studied the development of IQ in kids in primary school, he noted that the differences between kids from affluent families and the rest became marked after a summer break. While most kids bummed around during their vacations, kids from affluent families were taught to spend time productively, learn new skills, and continue their education.

So, what do affluent families inadvertently teach kids? Willpower.

I believe affluent families do 2 things right –

1. They teach kids to learn the most important application of willpower – forming rock solid habits. They figure out basic routines like exercise, reading great books, etc., in a way that kids have this ingrained.

2. They have kids exercising their willpower muscle from an early age. When a man on the streets in India comes into some money, he immediately spends it on alcohol. If the same man learnt to delay gratification, he could build significant wealth over a lifetime. The concept that he’s missing is delayed gratification. That only comes with willpower muscle training. Kids in affluent families “get” this concept.

If we plan to be successful as people, parents, and educators, we need to understand that the most important concept we can teach the next generation is how to understand and flex the willpower muscle. Of course, to do that, we must understand it ourselves. There are 2 great willpower books out there – Willpower by Roy Baumeister and The Willpower Instinct by Kelly Mcgonigal. I’ve read and loved the former and have the latter on my reading queue. I hope you get to it. It might just be the most important thing you ever do..

This week’s book learning is from How Will You Measure Your Life? by Clayton Christensen.

A fast food joint asked its customers how it could make milkshake better so they could improve sales. With customer feedback, they made it sweeter and nuttier but it led to no change in sales.

Clay Christensen and team were then called to solve the problem. They approached the problem by asking the question – what job did the customers hire the milkshake to do?

Careful observation revealed there were 2 types of jobs –
– Morning customers hired it to make their long commutes interesting. A milkshake was as filling as a donut or bagel, less messy, and easier to hold in their cars
– Evening customers were typically fathers who saw this was an opportunity to finally say “Yes” to their kid’s request (after many “no you can’t do this/that”). But they observed that, thanks to the thin straws, kids took too long to finish their milkshakes resulting in irritated fathers.

So, they implemented 2 changes –
– Morning milkshakes were made more viscous to last longer and included small pieces of fruit to surprise customers
– Evening milkshakes were made thinner and were provided with thick straws so kids could drink it faster

The outlet exceeded their new sales targets!

Clayton Christensen’s book is packed with many great insights. Next week, we’ll look at how Ikea understands and implements the “what job am I hired to do?” principle.

When I started out with blogging, I used to re-blog a fair bit. It was the easy thing to do as thinking of a new idea/learning every day was not easy. These days, I have the opposite problems – too many ideas and too few days. But, every once a while, I come across a post that I feel deserves to be re-blogged and today was one of them.

The honor usually goes to Seth Godin but today, it’s a wonderful post from my friend Kevin Marshall (who built the Gawk.it search widget you see on the sidebar). Hope you enjoy his post as much as I did.

---

I often find myself thinking about my great grandfather (so much so that I used his first name as my oldest son‘s middle name as a small way to honor him and the following train of thought).

He passed away before I was born, so I never met him and I honestly don’t know very much about him. I don’t know what he did for a living, what his hobbies were, who his friends were, what his dreams and aspirations were…nothing.

Yet, I know that he existed and that I wouldn’t if he hadn’t. I know that he was a regular guy and so he most likely had good days, bad days, and more than anything average days.

And I imagine, or rather project, that his day-to-day stuff probably seemed really important and ‘required’ to him…because that is how most of us operate throughout our days. Yet I, just two generations removed within his very own family, appear to be mostly un-effected (or at least completely unaware) of any it.

This general thought has *really* bothered me over the years.

And it bothers me more when I extrapolate those thoughts out to the billions of other people who have lived through history…most completely forgotten (even by their own families).

I understand that only a few people from any given generation will be remembered by history…but given this, the fact that we all spend so much time, worry, and energy on what happens in our day-to-day seems kind of silly and somewhat useless to me.

And that is why, no matter what is going on in my own little corner of the world, I don’t let things get me too down or stressed out. I try to always keep my personal priorities and goals clear and in the front of my mind. Because in just a few short years, very little of any of it will be remembered or matter to the world at large.

This general flow of thought has long been one of the reasons I *rarely* have a bad day, and instead and am generally happy and in a good mood.

---

Wonderful thought for the weekend Kevin. Thank you.

Great!

If you aren’t coming face to face with your limits every once in a while, how would you be able to push them?

VLOOKUP is one of the most popular excel formulas that exists. Looking up and finding data is one of the most common uses of excel and VLOOKUP is many an excel user’s go-to formula. VLOOKUP has one very annoying limitation however; it can only search to the right of the table.

INDEX+MATCH solves this problem and also does a better job. On average, INDEX+MATCH has been found to be 5-10% faster than VLOOKUP and when you are working with huge sets of data, this stuff begins to make a difference.

Basic use

I would suggest you spend 5 minutes learning the syntax of INDEX+MATCH by heart as it will save you a ton of time.

Index(“column with data you want”, MATCH(“data you have”, “column which contains this data”,0))

Demonstration: I have demonstrated this in the INDEX+MATCH sheet in today’s spreadsheet. Please download it here or please feel free to send me an email with your dropbox ID and I’ll be happy to share the folder.

(Tip: When you open the sheet, press CTRL+~ to see al formulas in the sheet. Same combination to reverse the view)

Advanced use

INDEX+MATCH is a very powerful combination and has numerous advanced uses. I have illustrated one advanced use – you can use it to extract all unique values from a list.

Another useful use is to have embed an INDEX+MATCH within an INDEX+MATCH to search both horizontally and vertically. You’ll find these applications on google as and when you need it.

The point to remember here is that INDEX+MATCH is the way to go when building excel models. Learn how to use them and you’ll find multiple uses for this very powerful combination.

Look forward to your questions in the comments.

---

Series introduction, Part 1 (Set up), Part 2 (Shortcuts), Part 3(SUMIFS, COUNTIFS)