learner2know

How to Use Mail Merge in Microsoft Word Use mail merge to create and print too many letters and other documents to different persons. Mail merge is used to create a set of documents, such as a form letter(interview call/offer letters) that is sent to many candidates.  Each letter has unique information.  For example, in letters to candidates, each letter can be personalized to address each candidate by name.  The mail merge process requires the following steps: Set up the main document.  The main document contains contents which will be used in each document. Connect the document to a data source.  A data source is a file that contains the information to be merged into a document. Normally we can use excel file contains the names and addresses of the recipients of a letter.  Microsoft Office Word generates a copy of the main document for each item, or record, in your data file.  If your data file is a mailing list, these item...

How to use lookup function : VLOOKUP function in Excel Excel Worksheet primarily supports tabulation functions which are very useful for preparing reports and financial data.   Inserting a formula in excel worksheet has the following steps:- Suppose a value to be searched from one sheet and to be shown in another sheet vertical lookup(VLOOKUP) function is used. FORMULA = VLOOKUP(A4,Sheet1!A1:F15,3,False). In this formula when after inserting '=' sign add the word/function name "VLOOKUP"    inside the bracket the first item is "A4". This is the lookup cell value.   Then add the range of cells "Sheet1!A1:F15" to look for this value out of the Range – A1:F15 and add the index number "3" out of which we want to take the value.  The value required is lies in the column index no.3. Finally for an exact match add “False”.