Please help, computer experts and MS-Office experts?

Question

What are the commands V LOOK UP & H LOOK UP, PIVOT TABLE in MS-excel and how to use them. Also, what is this mail merge or import & macro option in all the MS-Office programmes. Please help and eleborate, i am a novice when it comes to computers.

Answer 1

I'll say refer to MS-Help that is as good as any of the help offered here.

Answer 2

V Lookup

In Excel, the VLookup function searches for value in the left-most column of table_array and returns the value in the same row based on the index_number.

The syntax for the VLookup function is:

VLookup( value, table_array, index_number, not_exact_match )

value is the value to search for in the first column of the table_array.

table_array is two or more columns of data that is sorted in ascending order.

index_number is the column number in table_array from which the matching value must be returned. The first column is 1.

not_exact_match determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the VLookup function will look for the next largest value that is less than value.

Note:

If index_number is less than 1, the VLookup function will return #VALUE!.

If index_number is greater than the number of columns in table_array, the VLookup function will return #REF!.

If you enter FALSE for the not_exact_match parameter and no exact match is found, then the VLookup function will return #N/A.

H Lookup

The HLOOKUP function

HLOOKUP allows to look for a value in a row based on a certain value in another row. So you look up for "John" in row 1 and you get his address in row 2.

HLOOKUP (working with rows)

IMPORTANT NOTE: The values within which you are looking up MUST BE IN ASCENDING ORDER (1, 2, 3, 4... or a, b, c, d). This is one of the reasons I switched to the magic function and INDEX/MATCH.

Here is a basic HLOOKUP formula: =HLOOKUP(2,A1:G32,4, FALSE)

Mail Merge

The Data Merge Manager in Microsoft Word automatically creates unique, multiple versions of a customized form letter.

Word creates a mail merge by inserting information from a data document (Word or Excel format) into another text document which contains the form letter information. A mail merge uses two documents: a MAIN document and a DATA SOURCE document.

The MAIN document is the form letter-- it contains all the text, formatting, punctuation, styles, etc. that you want to have identical in each letter. It also contains special FIELD NAMES (or "field variables") which indicate where the data from the DATA SOURCE is to be inserted. The FIELD NAME is a place holder which contains the name of the FIELD surrounded by open bracket image and close bracket image symbols, called delimiters.

The DATA SOURCE document contains all the specific records of the generic FIELD NAMES that will make up the unique documents (for example: names, addresses, departments). This information replaces the FIELD NAMES when the merge is finally completed.

The merge takes each record from the DATA SOURCE and inserts it into its own copy of the MAIN document. This generates a new document composed of personalized versions of the form letter.


Pivot Table

for this thing, I suggest you togo to below link

http://www.cpearson.com/excel/pivots.htm

I hope all the stuff I given must not only useful for you but even for them who doesn't know about this and never asked also.

Answer 3

Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find.
The V in VLOOKUP stands for "Vertical."
The H in HLOOKUP stands for "Horizontal."

A PivotTable report is an interactive table that quickly combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the details for areas of interest.

To create a PivotTable report, you run the PivotTable and PivotChart Wizard. In the wizard, you select the source data you want from your worksheet list or external database. The wizard then provides you with a worksheet area for the report and a list of the available fields. As you drag the fields from the list window to the outlined areas, Microsoft Excel summarizes and calculates the report for you automatically.

After you create a PivotTable report, you can customize it to focus on the information you want: change the layout, change the format, or drill down to display more detailed data.

Answer 4

i dont know much about the others but through mail merge you can type a letter in MS-WORD and save it and u can send it to more than a single person at a time.for this u have to first type the letter, ofcourse and then go to the mail-merg option somewhere in the taskbar and choose the fields u want to keep and rest u can check out yourself.

Answer 5

Syntax for VLOOKUP is
--------------------------

=VLOOKUP("searchingitem",searchingrange,displaycellindex,FALSE)

searchingitem -----------------which word ur going to search in excel sheet

searchingrange-------------range of ur search

displaycellindex --------------------which one is going to display

FALSE-------------------default value

take the example
---------------------
A B C D
Johnnew colonyballnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam

IN The above example data's are available in a1 to d8 cells

now we are using vlookup in e1 cell means

select e1 cell and type =VLOOKUP("12",a1:d8,1,FALSE)

then in your e1 cell 12 is appear

explanation
---------------
VLOOKUP Is searching 12 in specified area of 1st column,ie A if it is appear then result comes 12


2rd example
----------------
select e1 cell and type =VLOOKUP("12",a1:d8,2,FALSE)

then in your e1 cell new colony is appear

explanation
---------------
VLOOKUP Is searching 12 in specified area of 1st column,ie A if it is appear then take the value of the next cell of the same row and display in e1 cell


Syntax for HLOOKUP is
--------------------------

=HLOOKUP("searchingitem",searchingrange,displaycellindex,FALSE)

searchingitem -----------------which word ur going to search in excel sheet

searchingrange-------------range of ur search

displaycellindex --------------------which one is going to display

FALSE-------------------default value

take the example
---------------------
A B C D
Johnnew colonyballnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam
12new colonyJohnnandhanam

IN The above example data's are available in a1 to d8 cells

now we are using vlookup in e1 cell means

select e1 cell and type =HLOOKUP("12",a1:d8,1,FALSE)

then in your e1 cell 12 is appear

explanation
---------------
HLOOKUP Is searching 12 in specified area of 1st column,ie A if it is appear then result comes 12


2rd example
----------------
select e1 cell and type =HLOOKUP("12",a1:d8,2,FALSE)

then in your e1 cell 12 is appear

explanation
---------------
HLOOKUP Is searching 12 in specified area of 1st column,ie A if it is appear then take the value of the next cell of the same COLUMN and display in e1 cell


please go and visit this website,all about excel is available in this site

Answer 6

http://www.mrexcel.com/articles.shtml
too long to ellaborate. you need to learn how to read. start it today