February 19, 2010

Useful spreadsheet formulas

I have always struggled with applying formulas in spreadsheets. finally I consolidated all the formulas that I consider useful at one place for reference. I hope this can be useful to others as well.

AND - Logical AND Operator
AVERAGE - Averages the number in a range
AVERAGEIF - Average based on some condition
AVERAGEIFS - Average based on multiple conditions
CONCATENATE - Joins strings
COUNTA - Count number of cells that are not empty
COUNTBLANK - Count blank cells
COUNT - Counts the number of cells that contain numbers
COUNTIF - Count based on a certain condition
COUNTIFS - Count based on multiple conditions
DATE - Returns date
DELTA - To check if the two values are equal
EXACT - To check if two strings are equal
FALSE - Returns logical value 'False'
HYPERLINK - Creates a link
IF - Checks a condition
IFERROR - Returns a particular values if there is some error
INT - Rounds a number to the nearest integer
ISBLANK - Checks if the reference is blank
LARGE - Returns the K-th largest value
MAX - Returns the largest number from a Range
MIN - Returns the minimum value from a range
MONTH - Returns the month
N - Converts a non-number value to number
NOT - Logical NOT
NOW - Returns the current date and time
OR - Logical OR
PERCENTILE - Returns K-th percentile
PERMUT - Returns the number of permutation
POWER - Returns the value of a number raised to a power
PRODUCT - Multiplies numbers
QUOTIENT - Returns the integer portion of a division
RAND - Returns a random number
RANK - Returns rank of a number in a range
REPLACE - Replaces a part of string
ROUND - Rounds a number to a given number of digits
ROW - Returns the row number of a reference
ROWS - Returns the number of rows of an array reference
SIGN - Returns the sign of a number
SMALL - Returns k-th small value of a range
SQRT - Returns the square root
SUM - Adds numbers
SUM - Conditional sum
SUMIFS - Sum based on multiple conditions
TEXT - Converts a value to text
TIME - Returns time for the given values
TODAY - Returns current date
TRIM - Removes spaces from start and back of a string
TRUE - Returns logical true
TRUNC - Removes decimal points from a number
TYPE - Returns the type of a value
UPPER - Converts a string to upper case
VALUE - Converts a text string that represents a number to number
VLOOKUP - Looks for a value in the left most column and then returns
corresponding value from other column
WEEKDAY - Returns weekday

January 24, 2010

now, Discover you strengths

Lately I have been so tied up in the regular job stuff, MBA applications and CFA exam that I was hardly doing anything else. Finally, this month I got some time and decided to catch up with my old hobbies like reading, stock trading and blogging. Fortunately, I happened to pick a book which I consider the most enlightening reading so far that I have practically done nothing in past few days but reading the book. The book is 'now, Discover your strengths'.

This book presents an interesting point of view for self-development and people management. The main emphasis of the book is that why is that every time when we talk about personal development or developing skills of employees in an organization, we look only upon the weaknesses and 'skill gaps', but not on the strengths that a person already has. The book is mainly written in the support of a tool named Strengths Finder which is used across the world to find out major strengths/talent themes of individuals by asking them many questions and then analyzing the answers to come up with the main strengths of the person.

The book has described in detail that there are 34 main strengths that an individual can have. An individual can have any combination of these not necessarily all of them and also with varied intensity. According to the author even a slight change in the combination in these talents can alter the behavior and characteristics of the person very significantly and there are many examples given to prove this. The main idea presented in the book is that instead of putting so much of efforts to fill the gaps in the skills and then getting sub-optimal results we should focus on our strengths and use them to get the best results. It is not necessary that everyone should be able to everything hence we should understand what we are good at and what is our natural talent. By just managing our weaknesses and utilizing our key strengths we can achieve higher level of success, is the idea presented in the book.

Others benefit aside, this book at least helped me to identify my key talent themes, which now I am trying to analyze more deeply. I rated all of those 34 talents on a scale of 0 to 3 and then created a matrix. Talents on which I scored 0 or 1 represent that those skills do not come naturally to me. It does not mean that I do not have those skills at all but that the intensity is very low or I have to put conscious efforts to bring those skills in action. Other half of the grid represents the skills which come naturally to me and are my actual strengths. Now the idea is to analyze this second part of the grid and derive some action items to utilize these skills as my strengths and get the best possible results in my professional and personal life. I would strongly recommend that everyone who wants to optimize his/her efforts of personal development should read this book.

December 25, 2009

What is happening!!

I don't want to watch any news channel and don't want to read any news paper, why? Because there is hardly anything positive and inspiring being told. So much of negative energy around. Just after a day when a former DGP is convicted of molesting a 14 year old girl now the current 85 years old Governor of AP is being shown in bed with three young women. What is happening in this country?

Police and Politicians who are already famous for corruption are now exploring a new frontier. This is utterly shameful and demotivating for me a citizen of this country. The other even disheartening side of this story is that these people just get away after many many years of trail. Where is the justice?

October 6, 2009

LBS Done - What a relief !!

This has been a marathon task to apply for LBS MBA for me. Since the day application was opened, I have been working on it almost every day and it has been almost a month now. However, finally it's almost done today. The only thing that is remaining is recommendation which will b e done next couple for days. The experience has many interesting things about it.

First, I got to know a lot of details about LBS and found myself really excited about LBS MBA. For now this is my only dream to get the admit call from LBS! Second and probably the most interesting part is the Essays and many other tiny questions asked in the application form. These questions made me do the real thinking about myself, my career, my aspirations, my resources and many more things over and over again. During the process, I recalled so many things from my past which were lying here and there, somewhere in my memories.

Last but not the least my friends! I have been torturing them for past many weeks by discussing about LBS and the application every time I meet or call them. I thank them for all the pain they suffered because of my excitement! During multiple discussions with them I got numerous ideas and comments which helped to improve my application. I am thankful to them irrespective of the result of the application. Special thanks to Bhaskar and Nimesh for reviewing the application word by word and providing critical comments!

September 11, 2009

Running Windows 7 !!

Being a lazy tech savvy person I had been contemplating the option of migrating to Windows 7 for past few weeks. Many of my colleagues have already started using it and have been giving rave reviews about the new OS by Microsoft. The installation was just a few click away for me but was just postponing it out of no reason. So finally when my Vista got broke down yesterday I decided to migrate to Win 7. I am delighted to see the performance of Win 7. It's really fast and the new UI is also attractive and user friendly. As I am not a typical geek who will go on telling about core technical features such as memory management etc etc but in a nutshell it is a really nice experience to use Win 7.

In the line are Office 14, VSTT 10 and other products!

September 7, 2009

Long, Lazy and sad weekend

Finally it's over. For past four days I am having a weekend and now I am really bored of it. Because of the unfortunate demise of Andhra Pradesh CM Late YSR, two days off was called on Thursday and the whole city came to a standstill. All the markets and offices were closed down immediately and most of the people preferred to stay in their homes. The environment was really gloomy with lots of processions by the people after hearing the tragic death of the leader. People had to struggle a little bit for necessities such as food, milk and transport. The two days off followed by the regular weekend and rains continuously accompanied the boredom and gloom.

Over this long weekend I tried so many things to keep myself occupied. Did a lot of CFA study, which helped me to cover a good chunk of the course. My friends dabbled with cooking multiple times and I also pitched in doing this and that side stuff! As usual my lovely balcony proved to be a good support for me, where I spent a lot of time doing bird watching!, enjoying rains and having long discussion sessions with my relatively new flatmate Bhaskar on various topics from life to career, from girls to childhood etc etc. I started a new book titled 'A Better India, A Better World' authored by Iconic Business figure Mr. N R Narayana Murthy(without finishing the previous one, You Are Here which is a masala material). Did a lot of social networking on Orkut, LinkedIn, Facebook etc etc. Though I am not much into movies and all but this weekend watched three movies including 'Aage se Right' and the entire blame for this movie goes to Uma. Now that the weekend is over I am happy that the life will be back on track from tomorrow and interestingly I have decided to hit the gym(once again!).

August 29, 2009

US MBA is out so the tension is!

Since the beginning I was sure that I wont be applying to US MBA programs at least not now. So I explored all the other possible regions barring Australia. In most of the regions outside US there are limited number of good B-Schools, so the selection is not very tough. Based on priorities and constraints one can easily distinguish among the MBA programs. For instance IMD requires very high ex and engineers are not much preferred there. Canada does not provides co-signer free loans, same with France. In Europe, most of the programs are of one year and require high work ex, which is not suitable for me. So in this manner, I managed to shortlist some colleges from Europe and Asia. However, as most of these applications are not yet open and as some of my friends urged me not to ignore US completely and apply to at least a couple of colleges there, I spent three whole nights researching about the US MBA programs.

As expected the researching US MBA programs proved to be very tiresome, confusing and frustrating. There are so many colleges and most of them are good! Interestingly irrespective of the ranking of the programs they have almost similar entry criteria/ class profile: 22 Months program, 150K USD total expense, 5 years of average work experience, average CGPA 3.4-3.6. After so much of study, analysis and discussions, finally I have decided not to apply to the US Programs at least not this year.

One really good aspect of application process is that it is improving my general knowledge enormously! I read about Spain, Hong Kong, Singapore, Canada, Australia, Europe and US. Got to know about history of many major educational institutions in the world. Studied economies of various countries. I also got an idea about cultural and political aspects of some regions. While researching about post MBA career opportunities, I came to know so many facts about large companies and there operations in different countries. I have reached out to my seniors, friends and friends of friends across the world to get the first hand information about different regions and colleges. The whole process have been a great introspection journey so far and an awesome learning experience.

August 16, 2009

Life never had been so busy and interesting

Every minute of the life seems to be calculated and booked now. There are so many things in which I am involved these days that I just cant keep track of everything and in a way I am enjoying it. Interestingly the timing is so perfect that in the past one year, since I joined Microsoft, these days I am having the most demanding project. The deadline is nearing and there is lot of sh*t to clear. Then this apping season is driving me nuts and I am still not able to finalize my non-Asian apps. On top of it, I am aspiring for CFA Level 1 and will be appearing for the exam in the coming December. The preparation is already on and going well also. I hope I will clear this comfortably. Further, recently I gave couple of NCFM exams as well which also required some amount of study. In my previous posts I wrote about AWF and On-line Volunteering but unfortunately could not find time for that. To add to this I am suffering from the regular seasonal flu for past one week which also wasted some of my time. On the personal front I have an awesome bunch of friends out here in Hyderabad and now one-by-one they are settling down so lots of parties & discussions are going on for that also. Plan A and Plan B, I have to keep balance between both of them, walking on a fine line. In the middle of all this I am thankful to the God(if there is any!) that I have a really nice manager who listens, understands and cooperates. Interstingly he is also very exited in my career plans!! Thats really really awesome!!

August 15, 2009

Apping : The Dilemma Continues...

Now I am really in the middle of of this. The apps are here once more and sleepless nights have started making their appearances once more. Though this time the flavor is different as I am applying to the schools out side India, till last year it was IIMs, IIFT etc etc. I never expected the amount of brain storming that goes behind applying for MBA abroad. There are 10s of parameters to consider for each of the colleges. In the spreadsheet, which I am maintaining, I have listed 40 odd parameters for each of the possible options and the more I research the more complex it looks.

Earlier I had peace of mind when I was planning to apply to only Asian schools but then I started considering European ones then Canadian and now lately Americans as well. Decision for Asian schools is straight forward. There aren't many schools with international repute so you can straight away consider the top ones: NUS, NTU, HKU, HKUST and ISB. CEIBS is out of question because of the Chinese factor. In EU I am planning to go for IESE and may be LBS. Others such as HEC, IE, INSEAD and IMD have some drawbacks such as one year programs, unavailability of loans, very high entry criteria etc. Canadian ones now look out of the scope as loans are not available easily and also because I don't find Canadian economy much interesting or diverse. America is like a bee-hive for me. I was always scared of considering America because of multiple reasons such as tough entry criteria, high investment, TOEFL requirements and because I prefer Europe to America as my destination. However after my friends repetitively urged me not to ignore America completely I have finally started considering it and it claimed first sleepless night today on the Independence Day.

June 28, 2009

Web-Marketing for Arab West Foundation

In my previous post I wrote about Online Volunteering. I approached couple of organizations and offered to volunteer. I got an immediate response from Arab West Foundation(AWF). AWF is a not-for-profit organisation (and registered in the Netherlands as Stitching Arab West Understanding). Its purpose is to encourage and promote tolerance, understanding and dialogue between Muslims and non-Muslims and Arab and Western communities, societies and countries.

The organization is involved in various activities such assisting students and interns who want to study about Islamic Culture, Establishing dialogue between the Muslim world and west at various forums but the most important activity they are involved in is translation of various Arab Media news items and reports into English and providing access to these archives to western universities and libraries. Through this AWF wants to enhance the understanding of Muslim World among the western countries.

So the job which is offered to me is web marketing of Arab West Report, which is the main product of AWF. As part of the job I have to contact various libraries and have them subscribe the publication of the report. I will also be contacting resellers who buy such content in bulk and then sell this to the real buyers. One other interesting work will be to popularize AWF through Internet and establishing links with other related organization. I am working directly with the CEO of the AWF, Dr. Kees Hulsman

Though there is no religious or political motivation of doing this however I am really excited to see how things turn out as I believe there will be a lot of learning and exposure.