Category: Everything else

I am a huge fan of the hug. I’ve been a huge fan for a long while.

The hand shake is a nice way of greeting people – especially ones you’ve never met. Bill Clinton innovated by making sure he used his other hand to touch people on the elbow making it a touch more personal. The hand shake is safe and that’s its greatest strength.

The hug, on the other hand, is unsafe. It’s the sort of betrayals that came with the hug that gave birth to the phrase “being stabbed in the back.” The hug is a wonderful show of love and trust in any relationship simply because it requires us to be vulnerable for those few seconds as we give ourselves completely to them.

The hug will never be the norm in politics or business – both low trust environments. But, in our personal lives, let’s remember to hug away!

And when we hug, let’s make sure we give what I call a “full on” hug i.e. a tight frontal embrace – anything less than this doesn’t qualify.

And guys, just hug already. Macho doesn’t build great relationships.. affection sure does.

Better pictures to follow soon (hopefully). I just had to get a quick snap at home to share with all of you.

A new life begins.. :)

During his days as a Professor, a student ran up to Albert Einstein after an exam and said -“Professor, I’m not sure if you realized that the questions you asked were exactly the same as the ones you asked last year.”

Einstein famously replied – “Yes, but the answers have changed.”

Safety is self delusional. We need a healthy amount of self delusion to be happy. But, too much stifles us. It’s tempting to always look at what’s been tried and tested.

The trouble with tried and tested is that it neglects context. What worked yesterday is unlikely to work today. The knock-on-door-and-push-the-sale car sales men of yesteryear are all but gone. Selling today works with different rules – trust and permission being the foremost among them.

Standing still isn’t different from moving backwards. In some ways, it’s worse.. it’s often easier to change the direction of a moving object than to make it move in the first place.

..will always have a critic. You will always be too young, old, early, late, fast, or slow.

We tend to be very autobiographical and self righteous in our opinions about decisions. We love our own paths, our own stories, and wouldn’t do it any different for the most part.

2 rules for all decisions –
1. You will never please everyone you care about. So, just make decisions you can live with and hope for the best.
2. Keep making decisions. The proportion of bad ones will decrease with time and with decision making, it is more about avoiding disastrous decisions than about getting it perfectly right.

Refresher: We’ve set up a basic spreadsheet (available for download here) in part 1 where we covered setting up a spreadsheet for analysis.

For the next 2 editions, we will put the spreadsheet down for a bit before picking them up as I find more time and bandwidth (I’m getting married in 3 days). As a result, today’s post will be about excel shortcuts.

There are an important principles that I use when working with Excel and PowerPoint -With Excel, you want to minimize use of the mouse and become a keyboard ninja and with PowerPoint, you want to do the opposite. We will cover mouse related to dos in a post on recommended quick access bars for Excel and PowerPoint. Today’s post is about keyboard shortcuts.

The following 11 shortcuts are those I’ve used the most and those I’ll recommend you learn. I’m assuming you are well versed with the basic ones like ctrl+s/c/v, etc., to save, copy, and paste.

1. Ctrl+Up/Down/Left/Right: Move to the end of a row, column.

2. Ctrl+Shift+Up/Down/Left/Right: Select till the end of a row, column.

3. Shift+Space/Ctrl+Space: Select a row/column

4. Shift+”-“/Ctrl+”-“: Delete row/column

5. Ctrl+Shift+”+”: Shift rows/columns up, down, left, right

6. Ctrl+Shift+$/%: Format numbers in $, %

7. Alt+E+S and “down” twice: Paste as values – invaluable when working with multiple pivots (Alt+E+S brings forth the paste menu)

8. F4: Absolute and relative referencing – as critical as they get

9. F2: Toggle in and out of formulas from text editing to moving the selected box

10. Ctrl+Shift+>/<: Increase or decrease font – more relevant for PowerPoint than Excel

11. Ctrl+D: Populate i.e. use it to populate an entire column based on the first value

The point to remember here is that it’s impossible to be efficient with your time on Excel without working with shortcuts. So, if you’re planning on significant work on excel – crunching data, building models, analysing surveys, etc.,  I would highly recommend you spend some time getting fully on board with shortcuts. As an added resource, do check out Chandoo’s post on 10 must-have shortcuts.

As these are off the top of my head now, I might come back and add a few. If you have any shortcuts that you use a lot and feel I’m missing, I look forward to those in the comments.

---

Series introduction, Part 1

Some things are not meant to be.

I was supposed to get on a flight last night and wasn’t notified that it was cancelled (Pro tip: Never ever ever ever fly Air India). As I was stuck in a really bad and unusual traffic jam that added an extra hour to the usual 20 minute journey to the airport, I was unable to buy a replacement ticket since all flights heading home take off around the same time.

I just had to laugh. It just wasn’t meant to be. In hindsight, while the experience wasn’t great, it wasn’t all that bad. Spent time with friends, submitted a request for a refund with proof of no information about the cancellation(the first request was denied by Air India!), submitted a claim on my travel insurance for the first time, etc. Yes, I’ve lost some sleep and I’m missing an event I was supposed to attend but this just seemed to be the work of forces beyond my control.

I don’t know if I have always been a huge control freak but I probably did have delusions about the kind of control I had over my life. But, over the past few months, I have repeatedly come up against situations, big and small, that have ripped this illusion to shreds. I haven’t been able to out-work or out-hustle myself out of them and I’ve found myself going back to a maxim of a wiser friend – “Perhaps life is trying to teach me something here..”

And it has. I’m glad I wasted no energy on anger (moaning is not allowed anyway – I have the privilege to FLY for god’s sake! How ridiculously fortunate..). I laughed, shrugged, and moved on.

I’ve learnt these past few months that you can push things, but only so much. Knowing when to push and when to quit is an art that we hone over the course of the lifetime. I’ve always tended to push too much rather than too little. I guess I’ve been more impatient and less wise as a consequence. But, my quote for the day says “wisdom is nothing more than healed pain.” Perhaps life is just teaching me to be wise?

Either way, the ability to just shrug at an annoyance, laugh, and move on has not come easy for me (sounds like such a small and easy thing, I know!). And I’ll take that learning.. and some wisdom if you will. 

Life is always teaching us something. We just have to be open to the lesson..

Lifehacker had a nice post on “why we should rethink the 8 hour workday.”

I particularly liked the takeaways.

• Manually increase the relevance of a task. Now, a lot of us still might struggle to find the focus, especially if no one set a deadline to it. Overriding your attention system and adding your own deadline, together with a reward, has shown some of the most significant improvements for task completion, according to researcher Keisuke Fukuda.
• Split your day into 90 min windows. Instead of looking at a 8 or 10-hour workday, split it down and say you’ve got four, five, or however many 90-minute windows. That way you’ll have just four or five tasks that you can get done every day much more easily.
• Plan your rest so you actually rest. “The fittest person is not the one who runs the fastest, but the one who has optimized their rest time,” says Tony Schwartz. A lot of the time, we’re so busy planning our workday that we forget about rest. Plan beforehand what you will do your rest. Here are some ideas: Nap, read, meditate, get a snack.
• Zero notifications. One of the best ideas I’ve ever had was to follow my colleague Joel’s advice on Zero Notifications. Having absolutely no counter on my phone or computer changing from 0 to 1 and always breaking my focus has been a huge help. If you haven’t tried this yet, try to turn off every digital element that could become an alert.

This week’s book learning is part 5 of a 5 part series on Personal Finance and Investing inspired by 3 books – The Investors Manifesto by William J Bernstein, I Will Teach You to Be Rich by Ramit Sethi, and The Millionaire Teacher by Andrew Hallam. (Part 1, 2, 3, 4)

For yourself
– Live like a millionaire. The average millionaire always buys a 2nd hand car as depreciation is maximum in year 1. Millionaires buy Japanese models as they have the best resale value.
They don’t spend on watches or fancy homes. They live in suburbs as it’s cheaper to own homes. If you’re ever in need of inspiration, read up on Warren Buffet

– Invest in plain vanilla index funds. They are a consistent 8/10. They will NEVER be a 10/10 but will never be a 1/10 either.
Index funds can be bought for cheap off Vanguard (if you live in the US, Canada, UK, or Australia). For Singapore residents, DBS Vickers provides index funds – they are slightly more expensive than Vanguard but work well as long as you invest more than $3,000 at a time

– Focus on the important stuff. Ignore minutiae like tax optimization until you earn in the millions

For your heirs
– The best gift to your heirs is not cold hard cash. Rather its the ability to save, spend wisely, and invest prudently
– Teach your kid to equate money to work from when they are young i.e. if they want $10 worth of stuff, are they willing to mop the floor at the supermarket for 2 hours?

Giving back and summing up
– Also, remember to give back a small portion of what you earn. Ramit Sethi did this by starting out a scholarship for young entrepreneurs. You can, too..
– Bill Bernstein sums it all up with sage advice – Live simply and save as much as you can for as long as you can.

Sketch by EB

I hope you found the series useful!

The right to moan works with opposite rules as compared to all other rights. While all other kinds of rights are given to us, the right to moan is taken away from us the moment we have access to water, food, electricity, and a basic level of physical security. It’s a tough life without these and my heart goes out to all those whose lives involve a daily fight of survival.

If you, like 3 billion or so others are on this side of the fence, you’ve lost your right to moan. I’m sorry. No moaning. That’s the way it works around here.

So, the next time you are about to moan, do the following –

1. Caveat your moan with “I am lucky to have an awesome life. I don’t have to fight for the basics but, that said, I do have my own set of challenges and these are to be kept in perspective as my life is..well.. awesome.”

2. Then say (to yourself) “I have lost the right to moan.”

3. And repeat “I have lost the right to moan.”

No moans = more happiness. And if we aren’t spending our lives being happy, what else are we doing here anyway?