Quote of the Day - New Year Comes With New Hopes

 

New Year Comes with new Hopes!!. This actually happens, many new year resolutions, plans, and much more. But the most beautiful thing you can do on your part is to wipe out all grudges from your heart and make it pure for the next year. Forgive Forgive and Forgive !!!

Enjoy! Its New Year. Happy New Year to all of you.

Dil Ya Dimag

Quote of the Day - Change Your Bad Habits NOT Yourself

 

Changing yourself for the sake of others will ultimately hurt you. Change is a good thing always but for constructive purposes not for some nonsense people who thought that you need to be changed even if your are Mr. or Miss Perfect.

Quote of the Day - A Key to Success

Preparations are always good. If you are prepared you are confident, you feel like you can do it and you did most of the time. So be prepared for tomorrow and the success is yours.

Quote of the Day - Be Positive Yar

Optimism is a very good thing. When you think the positive way, you get mental satisfaction and this is what everybody need nowadays because pessimism has just sucked our lives and relationships so be positive and stay Happy !!!!

Quote of the Day - Only a Leader Can Say This

True leaders are not made they just born leaders, Quaid-e-Azam Muhammad Ali Jinnah is one of the born leader who had such a charismatic personalty that can influence anybody and he knew how to snatch your right, how to be liberal but not compromise on justice and above all he knew how to RULE.... We Salute you !!! you are a True Ruler and a Great Leader...

Every Man's Story

Quote of the Day - No Compulsion in Love

There is no compulsion in love. If you love someone and he don't then you can't force him to love you. If he is yours then he is and if he is not then he just Don't !!! :)

Quote of the Day - Heart Only Knows to Love

Heart only knows to love!! No matter it is truth or Lie. Once you start loving someone you can’t stop your heart to love even after knowing that what you are loving is nothing but a LIE !!!

Only Pakistan Things - Original vs China

Quote of the Day - True Bravery

True bravery is forgiveness even when you are in power to take revenge, Imam Hussain (as) gave us the lesson to be brave and forgive but don't seal your lips against cruelty, don't bend your knees in front of the cruel ruler. Have Faith and for Allah you will be the most dearest!!!!

Quote of the Day - It is Just Up to YOU

Definitely !!! It is up to you only that how do you think about yourself. Do you want to Grow Up?? If not then only the apparent change in you body doesn't matter. Live the life just the way you want. 

Quote of the Day - This will Surely Happen

This will surely happens one day! and you feel that others were not just made for you and now you have found the one you have made for and vice versa!! 

Phrases Can Change a Woman’s Mood

Women are innocent creatures of God. Some senseless men call them stupid. But believe me they are very innocent, one small word of care can make them smile. They find happiness in small things. Their men meant all to them. So treat them with care, they are very delicate, by build and by nature as well…..

Dhoom 3

Dhoom Macha Lay Dhoom!

Dhoom 3 in narrow focus!  ;)

Quote of the Day - Blue Without You

Quote of the Day - Poverty Is The Worst Form Of Violence

Poverty Is The Worst Form Of Violence But Who Can Ever Go Against Gods Will. He Knows Better !!!

Quote of the Day - Missing Someone is Falling in Love

Missing you is just like breathing to me !! if i won't i will die :P

Only a True FB Lover Can Do This

Check Out the setting he did to steal the wifi .... Hats Off to Him :P

Mom Why You So Loving ?

The mother-child relationship is paradoxical and, in a sense, tragic. It requires the most intense love on the mother's side, yet this very love must help the child grow away from the mother, and to become fully independent.
LOVE YOU MOM !!

Quote of the Day - Life Must Goes On

It is true that past hurts like hell. But there is a rule that life has to move on. The rule of reality, the rule of life, the rule of God.........

Learning Excel , V lookup

Do you know about  MS EXCEL ? if yes then great but for newbies i would like to write few lines about it first ! So, Excel is an application which has features like calculation, graphic tools, pivot charts and micro programing (VB). Microsoft excel provides special features to present data in smart way, with ease of work. Professional has to work smartly to manage the work load & to convert data in to information.

Here i am  going to teach you about some uncommon tools and some daily use tools for MS Ecxel. 

V lookup:

What is V lookup in excel ? 

This function is used to stack of number‘s in to a desired information. One can easily find data from vertically align tables, which associated with the value entered by the user.

Now we want some specific information from the below mentioned table, we want to find the price in the new spread sheet. We want to search the price of “Air Conditioners” in the below table.  

 

Now we will add our formula in cell H2, you can add it to any other cell or any other spread sheet.

Steps:

1-      Start the formula with sign (=), type the formula name.

2-      Adding Arguments:

a.       Add the first argument in the formula, our argument is “Air Conditioners”, e.g =vlooup(“Air Conditioners”.

b.       Now add 2^nd arguments it is, the range of data “A2:B:20”,                                                       e.g =vlookup(“Air Conditioners”,A2:B20. Note: the vlookup will always search the 1^st column in this range, check the formulas before moving the columns.

c.       The 3^rd argument is the coloumn index number, The 1^st columns in the range is 1 and the 2ns is 2. In this case we have to fine the price of the products so our index columns will be 2, e.g =vlookup(“Air Conditioners”,A2:B20,2

 

d.       The 4^th argument will be to look for “approximate matches or exact matches”, it can be True or False. If you enter True it will search for approximate match and if enter  False it search ofr exact match it. In this case we looked for exact match so enter false and close the parenthesis. e.g  =vlookup(“Air Conditioners”,A2:B20,2,false.

                                and the answer will apper when you will press the enter.

Thank you for reading. What i need you is your comments and sharing ! should you have any questions ? feel free to ask me right here! 

Happy Excel 

NoMan!