VLookup Function - Use VLookup - How to use VLookup

 VLookup Function - Use VLookup - How to use VLookup

Another exiting tutorial in Microsoft Excel which “how to use VLookup function”. “VLookup function” is most uses and most useful function. With the help of VLookup Function we can find a value by vertical table. “VLookup Function” means “V” means “Vertical” and “Lookup” means “search or find” so now I hope you all understand from this Excel function. Now let’s practically work on this function. Follow these steps to use VLookup function.

1) Start “Microsoft Excel 2007”.
2) Now select “6 columns” and “2 rows” as given below.

3) Now go to “Home” menu and click on “Marge and center” command as given below.

4) Now write “Computer items and their prices” in this cell and then “bold”, “color” and make “border” of the cell as given below.

5) Now make two other columns by name of “Items” and “Prices” and fill the information as given below.

6) Now also make another two columns by name of “Items” and “Prices” at below of “Items” and “Prices” table as given below.

 
7) Now type an “items name” at the below of second Items column as given below.

  
8) Now type the below function at the below of “Prices” as given below.
      =VLookup(F24,F9:G18,2,0)

 

9)       Now press “Enter”. 
10)  We have “F24” in function which is cell number of “Processor” at the below of Items then second is “F9:G18” which is the complete selected area of “Items” and “Prices” at the above table and the third is “2”, which means that our value available in second column of the selected table and the last one is “0”, we use “0” value for the “exact value”, “Exact value” means that as we typed we want that value.
11)  Now as we type “RAM” at the place of “Processor”, our value will directly change as given below.

    

Read More

Word to Pdf - Word doc to pdf - Convert word to pdf

 Word to Pdf - Word doc to pdf - Convert word to pdf

Hello friends how are you? I hope you all will fine. Friends, today I am going to teach you a very interesting and most wanted tutorial which is “how to covert Microsoft Word document to PDF”. I will work on 2 methods, I know a lot of methods but if I teach more method then our tutorial will become boring so therefore I teach only 2 methods for you all. To convert your “Microsoft Word” file to “PDF”, follow these steps which are given below.

1)  First download “deskPDF” software from below address.
        deskPDF 
 2) After downloaded, install “deskPDF” software.

 First Method:-


1) Now start “Microsoft Word 2007”.
2)  Click on “Office button” then Click on “Open” command or Press “Ctrl+O” from keyboard. Then choose your “Microsoft Word” document which you want to convert to PDF file. After selected of your document click on “Open” button.
3)  After open of you document, Click on “Office button” then click on “Print” command and lastly choose “Print” from “Print menu” or press “Ctrl+P” from keyboard as given below.

4) Now select “deskPDF” from “Name” then click “OK” as given below. 
 

5) After click on “OK” button, preparing process will start wait a few second. After process, “Save” menu will appear; now write a name in front of “File name” and then click “Save” as given below.

Second Method:-

1) “Right click” on your “Microsoft Word” document and then choose “Convert with deskPDF” option as given below.  

 

Read More

Create a chart - How to create a chart - How can i make a chart in Excel

Create a chart - How to create a chart - How can i make a chart in Excel

Hello friends how are you after a long time. I was busy in these days so sorry for this. Today is a new tutorial in “Microsoft Excel” which is “how to create a chart”. We will create “Student marks chart”. So let’s start it. Follow the below steps to “create a chart”.

1)  Start “Microsoft Excel 2007”.
2) Now fill your information as given below.

3) Now “bold”, “color” and make “border” of your information text which is given below.

4) Now select your all information text as given below.

  
5) Now go to “insert” menu and then choose a “chart style” from “chart” menu as given as given below.

This was our tutorial of the day I hope you all will like it

  

Read More