Mail Merge in Word 2010

How to Mail Merge in Word 2010

Firstly Navigate to Mailings Tab 

Now Click Step by Step Mail Merge Wizard.

Carefully Choose the type of document you want.

This step will ask you to choose what document to use/type document now.

Now Choose your recipients

Now Choose the Excel worksheet that has your chosen recipients.

Click Open.

Follow the rest of the Mail-Merge Wizard. 

It depends on the options chosen different dialog boxes will show up, making very difficult to provide a step by step for the rest. However; the rest of the steps are self-explanatory.

Lastly Click Finish and Merge on the Mailings Tab when done.

Read more »

Pivot Table tutorial

Pivot Table tutorial for MS Excel 2007 and Excel 2010

Know What Is A Pivot Table?

The Pivot tables are used to summarize, analyze, explore and present your data. A Pivot table is a way to extract data from a long list of information and present it in a more meaningful and user friendly understandable format. For example, lets say that we have the data of student scores in a spreadsheet, you could turn this into a pivot table, and then view only the Math scores for each pupil.

Learn How To Create A Pivot Table In Excel 2010

Here are the steps to create a Pivot table in Excel 2010.
Step 1: First of all, please make sure to select the data range for which you want to make the pivot table.

Step 2: Insert the Pivot Table by going to the Insert tab and then clicking the Pivot Table icon.

Step 3: Select the target cells where you want to place the pivot table. For starters, select the New Worksheet option.

Step 4:  The new worksheet will open and you will be able to see the pivot table that you just created, you can now generate the report from this table and can perform various operations on this table for better visualization and presentation of data. Just for example I calculated the sum of all of the selected cells.

In the right side, you will see the Pivot Table Panel which contains many useful options to work with the Pivot table.

What is New In The Excel 2010 Pivot Table

By way for discussed in the introductory paragraph, Pivot Tables were also present in Microsoft Excel 2007, lets see what new enhancements have been made to the Excel 2010 Pivot tables.
1. It includes a new feature called ShowValues As, right click the Pivot table and choose Show Values As, you will see many new options here. It helps you in trying out several different calculations until you get exactly what you were looking for.

2. It offers many new calculations, almost six new calculations have been added to it.

3. It includes some great visual totals. Visual Totals refer to what totals should be shown when one or more members are filtered. You can turn this feature ON of OFF, simply right click the Pivot Table and choose the Pivot Table Options option here.

We know In the PivotTable Options window, go to the Tools & Filter tab and check/uncheck the Include filtered items in set totals option to enable/disable it.

Here the enhanced pivot table feature of Excel 2010 add feathers to this great product by Microsoft.

Read more »

Word 2010 Line spacing

How to Set Line Spacing in Word 2010, Word 2013

In Word changing the line spacing in a Word 2010 document inserts extra space between all lines of text in a paragraph. Because Word adds the space below each line of text in the paragraph, the last line in the paragraph will also have a little extra space after it in the package.

Setting line spacing

We can easily change the line spacing in the current paragraph or all the paragraphs you've selected as a block:

1. Click the Line Spacing command button.
   
   

   

   Word Line Spacing

   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   A menu listing common line-spacing commands appears.
2. Choose a new line-spacing value from that list.
   The line spacing for the current paragraph or selected paragraphs changes.

Word sets line spacing at 1.15 as its standard, or default. Supposedly, that extra .15 lines of text makes text more readable than using single spacing, or 1.0. In double spacing, or the line spacing value 2.0, one line of text appears with one blank line below it. Triple spacing, 3.0, makes one line of text appear with two blank lines below it.

Ah! The keyboard shortcuts:

• Single-spaced lines: Press Ctrl+1.
• Double-spaced lines: Press Ctrl+2.
• 1-1/2-spaced lines: Press Ctrl+5.
  Use the 5 key on the typewriter area of the computer keyboard. Pressing Ctrl and the 5 key on the numeric keypad activates the Select All command.

There’s no such thing as having no line spacing. If you want to "remove" fancy line spacing, select some text and press Ctrl+1 for single spacing.

Setting specific line spacing options

Now to set the line spacing to a value other than the items shown in the Line Spacing button's menu, you summon the Paragraph dialog box.

We see in the Spacing area of the dialog box, the Line Spacing drop-down list lets you set various line-spacing values: Single, 1.5, and Double, just like the Line Spacing command button menu.

Additional options in the Line Spacing drop-down list require you to also use the At box. Values you set in the At box indicate line spacing:

• At least: The line spacing is set to the specified value, which Word treats as a minimum value. Word can disobey that value and add more space whenever necessary to make room for larger type, different fonts, or graphics on the same line of text.
• Exactly: Word uses the specified line spacing and doesn’t adjust the spacing to accommodate for larger text or graphics.
• Multiple: This option allows you to enter line-spacing values other than those specified in the drop-down list. For example, to set the line spacing to 4, select Multiple from the Line Spacing drop-down list and type 4 in the At box.

Now click the OK button to confirm your settings and close the Paragraph dialog box.

Read more »