Display all the available functions for MS Excel

• Open a blank Excel workbook. 
• Click on the Formulas tab and within the Function Library group dick on the Insert Function icon. 
• From the Insert Function dialog box displayed,  under Or select a category : section,  select a particular category function,  the related functions will displayed. 

Used Functions for MS Excel

• All Excel formulas start with the 'equal'(=) sign. 
• Excel 2010 contains a build -in list of worksheet functions;  which are categorized to make it easy to search for the once you need. 
• Excel has over 300 built-in functions divided into various function categories,  including:

• Financial 
• Date & Time 
• Information 
• Engineering
• Logical 
• Look-up & Reference 
• Database
• Cube 
• Text 
• Matti & Trigonometry 
• Statistical 

Formulas and Functions: for MS Excel

Used Formulas: ,

              A formula is an equation that performs operations on worksheet data.  You can use an Excel 2010 formula to perform mathematical operations,  such as addition and multiplication,  or they can compare worksheet values,  join text,  averaging a student's test results etc.  Formulas can refer to other cells on the same worksheet,  cells on other sheets in the same workbook,  or cells on sheets in other workbooks. In addition,  if you change the data in your speadesheet,  Excel will automatically recalculate the answer without you having to re-enter the formula,  A basic formula format will start with an equals sign (=)followed by one or more operands,  separated by one or more operators. Operandscan be values,  text,  cell reference, ranges, defined names,  or function names.  Operators are symbols used to represent the various arithmetic and comparison operations you can perform on the operands.

    In Microsoft Excel 2010, operators are executed in this order :

1. Parenthesis.   ()
2. Percent. %
3. Exponentiation.  ^
4. Multiplication.  *
5. Division.  /
6. Addition.  +
7. Subtraction.  -
8. Concatenation (putting string together,  like Jenn & ifer) .   &
9. Equal To.  =
10. Greater Than.  >
11. Less Than.   <

• Place the cursor in the cell where the formula will appear, I. e. E5. 
• Enter an =sign.  All Excel formulas start with the 'equal'sign.
• Enter the expression that will produce the result you want.  This can consist of operands,  values,  variables,  and symbols which represent mathematical procedures such as + or - to add and subtract,  e. g. A5+C5.
• When the formula is complete,  press Enter.  The result of the formula will be calculated and displayed in the cell E5. 
• You can see the formula in the Formula bar at the top of the screen the cell pointer on the cell E5. 
• If there is an error in a formula,  an error message is displayed which will begin with a # sign. When writing formulas it is easy to make a mistake.  Here are some common mistakes; 

Edit the Excel header and footer for MS Excel

• From the View tab, in the worksheet Views group,  click the Page Layout icon. 
• Edit or change the elements in the header or footer is you wish. 
• When finish,  just press the Esc key and save your work. 

View header and footer For MS Excel

• Headers and footer are not visible in the normal worksheet view. 
• You can use the Page Layout view to see the header and footers. 
• To view a header or footer or footer before printing the spreadsheet,  use the Print Preview option (File Tab - Print). 

Insert header and footer for MS Excel

• Click the View tab. 
• In the Workbook Views group,  click the Page Layout icon. 
• Click in the area marked Click to be, left, center or right aligned.  In our example as shown above,  it's center aligns. 
• Type the desired text in the appropriate box. 
• You also can use the Header & Footer Tools Design Tab,  Header & Footer Elements group to insert the can use appropriate text. If you wish to go to the footer,  click on Go to Footer icon in the Navigation group. 
• Click the Home tab to apply formatting to the text (font,  bold, underline, or color). 

View for MS Excel

View 

Header and Footer to the Excel 2010 :
              Normally we type in descriptive text to add information to a speadesheet such as titles,  dates,  page numbers,  etc.  A header or footer can appear in three locations on page.  It can be in the top/bottom left corner,  the center,  and the right corner of the page.  With the latest version of Excel 2010, it is much simpler to add a header and/or footer to your worksheet.  Here are the steps:

Centering the Worksheet on the Page MS Excel

1. Select Page Layout Tab
2. Select the Margins icon 
3. Select Custom Margins 
4. To center within the top and bottom margins,  under Center on page,  select Vertically. 
5. Click OK 

Adjusting the Margins for MS Excel

1. Select the page Layout Tab 
2. Select the Margins icon 
3. Select desired template or customize margins 

Adjusting the Scale : Percentage and Fit to Page MS Excel

1. Select the Page Layout Tab
2. Go to the Scale to Fit Section
3. Adjust page width,  height,  or %of size 

Changing the Paper Size for MS Excel

Changing the Pepar Size :
              The default paper size is 8 1/2 *11 sheets, but you can select other available paper sizes, such as legal (11*14), To select a different paper size :

1. Select the Page Layout Tab
2. Select the Size icon.  From the Size pull-down list, select a size. 

Changing the Orientation for MS Excel

Changing the Orientation :
              Most documents are portrait (tall)  oriented,  but many worksheets may be easier to read in the landscape (wide)  mode-In addition,  changing the orientation can also help to fit a large worksheet to one sheet of paper.  After changing the orientation,  you may need to proceed with Changing the Paper Size.

1. Select the Page Layout tab 
2. Select the Orientation icon
3. Under Orientation, select the desired option (Portrait or Landscape) 

Page layout for MS Excel

Page Layout 
             Excel 2010's page Layout view gives you an instant view of how printed Excel pages will look.  You activate this view by clicking either the Page Layout View button (the center one)  to the immediate left of the Zoom slider on the Status bar,  or the Page Layout View command button on the view tab of the Ribbon. When you switch to Page Layout view,  Excel adds horizontal and vertical rulers to the column letter and row number heading.  In the Work sheet area,  this view shows the margins for each printed page,  with any heading and footers defined for the worksheet,  along with the breaks between each page.
Note: To see all the pages required to print the active worksheet,  drag the slider button m the Zoom slider on the Status bar to the left until you decreases the screen magnification sufficiently to display all the pages of data.
             In order to girl information on a page or change the appearance of the page,  you may want to customize your page layout Several methods of changing the layout,  located in the Page Setup dialog box,  are described here.

• Changing the Orientation changing the Pepar Size 
• Adjusting the Scale & Adjusting the Margins
• Centering the Worksheet on the Page 

Apply Conditional Formatting for MS Excel

Apply Conditional Formatting
This option is used to format the cell depending upon the condition.  Following are the steps

• Select one or more cells in a range,  or table that is on be Apply formatting. 
• On the Home tab,  in the Styles group,  click Conditional Formatting icon. 
• Select Highlight cells Rules and click Between. 
• From the Between dialog box displayed,  choose the formatting you wish to use from the dropdown.  Line default is a Tight Red with Dark Red Text".
• Click OK. 
• The background color of all values that appear more that once in the selected ranges will chow the selected formatting. 

Create a chart for MS Excel

Create a chart 

• Click on any cell within the data containing the information that you wish to display as a chart,  or highlight the exact data area that you wish to display as a chart. 
• On the Insert menu,  in the Charts group,  click the chart type you require.  A gallery of thumbnail images for the related chart subtypes will appear. 
• Click the required chart subtype to create the chart,  or click All Chart Types to open the Insert Chart dialog box and choose from all available chart types. 
• When you have selected a subtype,  a chart will be created as an object in the worksheet and Chart Tools will appear on the Ribbon incorporating Design,  Layout, and Format tabs. 
• For example,  when choose the '3-D Clustered Column' subtype, the chart created as follow :
• Alternatively,  click the Charts group Dialog Box Launcher to open the Insert Chart dialog box and see all the available chart types. 
• You can also change the default chart type in the Insert Chart dialog box by selecting a chart type and clicking the Set as Default Chart button. 

Note : To quickly create a chart of the selected data (based on the default chart type)  as an object in the current worksheet,  press Alt+FI. To create a chart of the selected data as a new sheet press F11. 

Creating Chart from Data in a Worksheet for MS Excel

Creating Chart from Data in a Worksheet 
               Once you have entered the data you want to display as a chart into a worksheet and decided which type of chart you require,  you can create it with just a few mouse clicks.  Use the following illustration to quickly create a chart on the current worksheet.
Open Excel 2010 and create a worksheet as illustrated below. 

Creating Charts for MS Excel

Creating Charts :
                Charts group is one of the most useful groups of Microsoft Excel 3010 and it has been improved and came around with some new features which were not available with the Excel 2007. The Excel 2010 charts have a great new look.  That is why today Excel is one of the most commonly used application for creating charts.   Before you can create a chart,  you must have some numbers (data)  that stored in the cells in an Excel worksheet Normally,  the data that a chart uses can be resides in a single worksheet;  or us3 data that's stored in other worksheets. 

Insert Tab for MS Excel

Insert Tab :
             The Insert tab of Excel 2010 Ribbon is one of the most interesting one to discover and it had so many visually attractive feature that will allow users of Excel 2010 to produce amazingly professional looking graphs and tables.  The insert button consists of Tables,  Illustrations, Charts, Sparkling's, Filter,  Links,  Text,  Symbols groups and all these group consists of many icons that have been designed to provide a perfect Excel 2010 experience 

Unmerge cells for MS Excel

Unmerge cells:

• Click on the cell B2 (the cell that merged before). 
• On the Home tab,  in the Alignment group,  click on the down arrow next to the Merge and Center icon. 
• Select Unmerge Cells.  The cell B2 is now separated into 3 cells. 

Merge cells for MS Excel

Merge cells:

• Type the words "Items Price" into cell B2 of a spreadsheet. 
• Highlight the cells B2,  B3 and B4
• On the Home tab,  in the Alignment group,  locate the Merge and Center icon. 
• Click the down arrow to see the following options :
• Click on Merge & Center.  The three cells will then become one - B2,  to be exact!

Merge and Unmerge Cells (Columns) for MS Excel

Merge and Unmerge Cells (Columns) :
Studies the spreadsheet below before we start our tutorial on merge cells in Excel 2010 :
          If you look at Row 2, you'll see that the "Items  Price " heading stretches across three cells.  This is not three separate cells,  with a color change for each individual cell.  The B2, B3 and EH cells were merged. 

Merge several cells for MS Excel

Merge several cells 

• Select the cell that you wish to merge to become one cell. 
• On the Home tab,  in the Alignment group,  dick the Merge & Center icon.  Shrink the text into one cell
• Type the data you requirebinto the cell and press Enter,  
• Right-click on the selectedvcells,  click Format Cells. 

From the Format Cells dialog box displayed,  dick on the Alignment tab.
Under the Text control section,  tick the Shrink to fit check box and click on OK. 

Wrap multiple lines of data in a cell for MS Excel

Wrap multiple lines of data in a cell

• Type the text The Ultimate Guide to Excel 2010 into the cell C5 and press Enter.  The entry will appear as one long line that does not fit into the cell. 
• Select the cell C5 and then on 5he Home tab,  in the Alignment group,  click the Wrap Text tonight.  The text will wrap as follow :

Change the orientation of data cells for MS Excel

Change the orientation of data cells
Select the cell,  or cells,  you wish to change.
On the Home tab,  in the Alignment group,  click the
Orientation icon.  You will see a drop down menu allowing you to format the cell orientation.
Select any one of the command. Experiment with applying some of the other orientation effects.

Align data between the top and bottom of a cell

Align data between the top and bottom of a cell.

• Select the cell or cells,  you wish to align, 
• On the Home tab,  in the Alignment group,  click the Top Align icon to align data in the top position of the cell. 
• Click on the Middle Align icon to centralized data vertically in the cell. 
• Click the Bottom Align icon to align data in the bottom position of the cell. 

Align data between the left and right sides of a cell for MS Excel

Align data between the left and right sides of a cell 

• Select the cell,  or cells,  you wish to align. 
• On the Home tab in the Alignment group,  click the Align Text Left icon to align data with the left edge of the cell. 
• Click on the Center icon to center data in the cell. 
• Click on the Align Text Right icon to align data with the right edge of the cell. 

Home Tab for MS Excel

Home Tab:
Formatting and Customizing Data 
Discover the Excel Cell Alignment Options 
The options allow you to change alignment of the text in a cell or cells,  text orientation,  merge several cells together and so no.
For more alignment options,  you can click on the Alignment group dialog box launcher to display the Format Cells dialog box.

Save a workbook (first time)

Save a workbook (first time) 

• From File Tab,  dick Eave OR click the save button on the Quick Access Toolbar. 
• From the Save as dialog box displayed,  ensure that you browse to the folder/diak drive that you would Like to save the file. 

Speed up your data entry

Speed up your data entry 
               Enter key : Pressing the key will enters the data and moves the active cell highlight down to the next cell in the current column.
Tab key : Pressing the key will enters the data and moves the active cell highlight to the next cell in the current row.
Arrow keys: Pressing the key will enters the data and moves the active cell highlight to the next cell in the direction of the specific arrow key pressed.
Esc key: Pressing the key will cancel the current data entry.  Starting with Excel,  we will create a result sheet.  We create the results sheet which will look like.
File Tab:

Table : File Tab Menu 

Enter Data into the Excel Worksheet for MS Excel

Enter Data into the Excel Worksheet:
Enter text into a worksheet 

• Select the cell in which you want to enter the text. 
• Type in the text/data into the cell. 
• Press the Enter key.  Text entries are left aligned by default. 

Excel 2010 ribbon

Excel 2010 ribbon 

• Home : Use this tab when creating,  formatting,  and editing a spreadsheet, 
• Insert: Use this tab when adding particular elements (including graphics,  PivotTables,  charts, hyperlink,  and headers and footers)  to a spreadsheet, 
• Page Layout : Use tab when preparing a spreadsheet for printing or reordering graphics on the sheet 
• Formulas : Use this tab when adding formulas and functions to a spreadsheet or checking a worksheet for formula errors, 
• Data;  Use this tab when importing,  querying,  outlining,  and subtotalling the data placed into a worksheets data list. 
• X Review: Use this tab when proofing,  protecting,  and marking up a spreadsheet for review by other. 
• View : Use this tab when changing the display of the Worksheet area and the data it contains. Excel 2010's user interface is based on the ribbon,  which is a bar across the top of the window that contains tabbed pages of commands and icons/buttons.
• Ribbon: The whole bar,  including all of the tabs. 
• File Tab: On the far left side of the Ribbon,  the file Tab let's you perform tasks that are common across any Office applications.
• Quick Access Toolbar : Located on top of the Excel screen above the File Tab, 
• Tab: Excel's main tasks are brought together and display aim the commands commonly needed Clicking a tab name once activates the tab. 
• Group : A section of a tab that organizes related command buttons into submission. For example,  the Home tab has the following groups;  Clipboard, Don't,  Assignment, Never,  Styles,  Cells,  and Editing. 
• Dialog box launvher: A small icon in the bottom-right comer of a group,  from which you can opens dialog box related to that group. 

Modes for MS Excel

Modes :
There are 2 modes of a cell :

1. Edit Mode. 
2. Selection Mode. 

Following are the ways to bring a cell from select to edit mode:

Double Click on the Cell OR press function Key OR Single Click on Formula Bar. 

Sheet Tabs for MS Excel

Sheet Tabs. 
               File Tab : When clicked,  this button opens the File menu, from which you can open,  save,  print,  and exit as well as the Excel Options button that enables you to change Excel's default settings.

• Quick Access Toolbar : A small toolbar next to the File Tab contains shortcuts for some of the most common commands such as Save,  Undo,  and Redo buttons.  You also can customize quick access toolbar. 
• Ribbon: A combination of old versions menu bar and toolbar;  arranged into a series of tabs ranging from Home through View.  Each tab contains buttons,  lists and commands. 
• Name boc: Displayed the address of the current active cell where you work in the shows you the current cell's contents, 
• Worksheet area: This area contains all the cells of the current worksheet identified by column headings,  using letters along the top,  and row heading,  using numbers along the left edge with tabs for selecting new worksheets. 
• Sheet tabs : Excel 2010 contains 3 blank worksheet tabs by default.  Click on the intended table will go to the particular worksheet. 
• Status bar : Reports information about the worksheet and provides shortcuts for changing the view and the zoom. 
• Zoom control: Use to zoom the Excel screen in or  out by dragging the slider. 

Shortcut Keys 

Open for MS Excel

Open 
Click on the Start button, point to All Programs then Microsoft Office and click on Microsoft Office Excel 2010
Excel sheet consists of rows and columns.
               One sheet consists of 16,484 columns named as A,B,C.........,XFD and 10,48,576rows named as 1,2,3,....,,,.,...44354 Intersection of row and column is known as cell is labeled by giving the columnname followed by row name. For example : A67 is cell formed when A column intersected with 67" row. 

Introduction for MS EXCEL

Introduction 
             The Microsoft Office Excel 2010 is a member of the Microsoft Office 2010 suite of programs.  It is a powerful tool for analyzing,  sharing,  and managing information to help you make more informed decisions -
        The first impression when you open the program - brand -new Ribbon use interface being introduced to replaced the old menus,
As part of the new and improved Excel 2010 user interface,  the program includes all sorts of graphical improvements such as Live Preview,  Page Layout and full of pop-up galleries that make spreadsheet formatting and charting a real easy.
Objective :
After going through this unit,  you will be able to

• Understand the features of excel
• Navigation worksheets 
• Make different type of entries in a worksheet 
• Create text,  Numbers & data series
• Manipulate cells 
• Create small budgets/sales reports 

Assignments for MS Word

Assignments :

A)  Create a new document with the following text. 
                  Many people who use HTML to create We pages or other documents find notepad 3 useful tool for writing in HTML.  Because Notepad supports only very basic formatting,  you cannot accidently save special formatting in documents that need to remain pure text.  This is specially useful when creating HTML documents for a Web page because special characters or other formatting may not appear in your published Web page.

1. Change the Heading "HTML and Web Pages" to bold,    ,
2. Apply Alignment to contain so that the text is justified. 
3. Bold all occurrence of the word HTML in the document. 
4. Give each line spacing 1.5
5. Save the document as Testi. doc of your computer D:\drive own folder, 

B)  Open the document Text. doc created in the previous exercise and 

1. Save the Document as "Test2. doc"
2. Change the font of the Text to "Verdana"
3. Change the Line Spacing to 2.0 Line 
4. This Paragraph in the Square and suitable color. 
5. Center aligns in the Heading. 
6. Save the Document. 

C)  Creating the Following Table:

Display on the Customize status bar menu for MS Word

Display on the Customize statistics bar menu 

• The menu's option are endless (selected)  when 3 check mark appears next to them. 
• The items at the top of the menu (from Formatted Page Number to Word Count) display information about your document. 
• The options from Caps Lock down through Macro Recording are used to turn off or on those features. 

The last three option on the menu control whether the View or Zoom shortcuts appear on the status bar
Note : You can try to check or select the available options in the Customize Status Bar and see the changes to your documents 

Word Status Bar for MS Word

Word Status Bar 
               The Word status bar is the area at the bottom of the Word window that gives information and some controls on the current document.  It displays information about what page you are on,  line number on the page,  total words in the document, etc.  It also shows other information about which editing toggles you have turned on or you can turn it off if you don't need the information provided shows on the status bar Right-clicking the status bar produces the helpful Customize Status Bar menu.  The Customize Status Bar menu does two things :

• It controls what you see on the status bar,  informational toolbars as well as certain controls.  It let's you turn on or off some Word features. 

Make changes to the letters for MS Word

Make changes to the letters 

• From the Finish group, click the Finish & Merge icon and from the menu appears, select Edit Individual Documents...
• From the Merge to New Document dialog box displayed, make the appropriate selection. 
• Once finish, click OK. 
• Cake the appropriate changes in the new document that appears and save the documents

Create a Mail Merge letter in word for MS Word

Create a mail merge letter in word :

• Open a blank Word 2010 document, 
• From the Mailing tab,  in the Start Mail Marge group,  click on start Mail Marge icon and from the Start Mail Marge sub-par menu appears,  select Letters. 
• Then,  from the Mailing tab,  in the Start Mail Merge group,  click Select Recipients icon ana 1 select Use Existing list..,
• From the Select Data Source dialog box displayed,  browse and select the file you will use for your list. 
• Click Open button.., 
• To edit the recipient(s) you want to include in your mail merge,  in the Start Mail Merge group, click Edit Recipient List icon. 
• Select the recipients, W recipient is selected if the checkbook beside their entry is selected. 
• Click OK button to dose the Mail Merge Recipients dialog box. 
• If you have not already done so,  in your document,  type the text of your letters. 
• Position the insertion point at the place in your document where you want to insert the merge fields. 
• From the Write and Insert Fields group,  click the insert Merge Field arrow and select the desired first from the menu appears. 
• When finished,  click Preview Results icon in the Preview Results group, A preview of your first recipient's letter,  appears. 
• To preview your document with other recipient's information,  in the Preview Results group,  click the Next or Previous Record arrows icons. 
• To print the letters,  in the finish group,  click finish and Merge icon and from the drop-down menu,  click print Documents....
• From the Merge to printer dialog box displayed,  select All to print letters for all of your records. 
• To print a letter for only the record displayed,  select Current record.  To print letters for only certain records , type a range in the text boxes. 
• Click the OK button. 
• From the Print dialog box displayed,  make any necessary adjustment. 
• Click OK,      ,

Create a Mail Merge letter in Word 2010 for MS Word

Mail Merge allows you to set up one letter , which server as your main document.  Using data from another source or database,  you can print this letter with different information for each record in Dia database. 

Mailings: for MS Word

Mail Merge in Word:
               Word 2010 provides easy access to all the commands necessary for creating a mail Marge.  These commands are available in the Mailings tab on the Ribbon.  You can Marge a mailing list to letters,  email messages,  envelopes,  and labels.  The following will show you the overall process of creating mailmerge in Microsoft Word 2010.

Step 1: Accessing Word 2010 Mail Marge commands.. 

• Open a blank Word 2010 document. 
• From the Mailing tab,  in the Start Mail Merge group,  click on Start Mail Merge icon and from the menu appear,  select the desired options to create your mail Marge. 

Step 2: Choosing a Document Type 

• Your opt fonts for selecting 3 document type include the following :
• Letters: allows you to alter one latter and sent it to multiple people (assume we select to option for demonstration purpose). 
• E-mail Messages: allows you to personalize letters designed to be sent to multiple people via e-mail.  For instructions on how to perform this type of merge,  refer to Creating Mail Merge Envelopes. 
• Labels : allows you to print labels addressed to multiple people.  For instructions on how to perform this type of large,  refer to Creating Mail Merge Labels. 
• Directory :allows you to gather varied but related information into a list such as a collection of lists regarding department directory,  can includes list names,  phone numbers,  etc. 

Step 3: Choosing the Recipients 

• From the Mailing tab,  in the Start Mail Merge group,  click on Start Mail Merge icon and from the menu appear,  select the desired options to select revipients:
• Type New List: Unless you already have a list created for mail merging.  You have to build a new one by typing each recipient.  For more information,  please refer another article on Mail Merge Recipients. 
• Use Existing List :When you've been through this before or you have handy a database list you want to use, this option makes the most sense. After choosing the list from the Select Data refer another article on Mail Merge Recipients. 
• Select from Outlook Contacts :Uses your existing Outlook contacts as recipients.  Unless your PC is on a network with the proper kind of Microsoft Server software installed,  you can forget this option. 

Step 4: Write and Insert Fields 

• Place the insertion pointer where you want a field to appear. 
• From the Mailing tab,  in the Write and Lanett Fields group,  click the desired options to add text and variable information to your document.  Frequently used options include :
• Address Block : to specify the format of your recipients names,  whether to insert the company name and postal address,  and the format of the postal address. 
• Greeting Line;  to format how the greeting line will appear (e. g.,  Dear Sir or Madam,). 
• Insert Merge Field: to insert fields for a variety of common options (such as the first or last name, phone number,  or state of each recipient).

Step 5:Previewing Your Documents 

• The Mail Merge task pane presents you with an opportunity to review what the merged document will look like.  This way,  you can go back and make any last -minute changes to fine - tune your merge. 
• From the Mailing tab,  in the Preview Results group,  click the Preview Results icon, 
• You can browse through the document for the other entries by clicking the Previous or Next button. 

Step 6: Completing a Word 2010 Mail Merge 

             The last step to complete the merge is to accept the preview of how the merge will look and direct Word to perform the merge.  You can print the merged documents or,  prior to printing,  you can edit individual documents. 

Add a custom Word watermark For MS Word

Add a custom Word watermark 

• Open Word 2010. 
• Click the Page Background group,  click the Watermark button to open the Printed Watermark dialog box. 
• From the dialog box,  you have 3 options to choose :

1. No watermark - to remove the current watermark. 
2. Picture watermark - to use a picture as the watermark.  You need to click on the Select Picture button and choose a picture to be your document watermark. 
3. Text watermark - to create a custom text watermark (let say we choose this). 

• Language : Click the drop-down menu to modify the watermark's language. 
• Text : Enter your desired watermark text. 
• Font: Change the watermark font from the drop-down menu. 
• Size: Change the watermark size to ensure it appears correctly on paper.  Default is Auto. 
• Color : Click the drop-down menu to change the watermark color. 
• Check or unchech "Semitransparent" to wash out or prevent washing out the watermark text. 
• Layout: To determine whether the watermark should appear diagonally or horizontally. 
• Click the OK button when finish, 

Default Word watermark for MS Word

Default Word watermark 

• Open Word 2010. 
• Click the Page Layout tab in the Word 2010 ribbon. 
• In the Page Background group,  click the Watermark icon to open a menu. 
• From the menu,  you can click on any available watermarks and you will see thee watermark is inserted in your document. 

Word Document Watermark for MS Word

A document watermark is just a simple text appear at the background of your Word documents. Word 2010 has many option for creating watermarks.  Although default watermark types are provided,  you can create watermarks with your own custom text or image.  You can also tweak the watermark will stand out from the document.

Change the theme graphic effects for MS Word

Charge the theme graphic effects 

• On the Page Layout tab,  in the Themes group,  click Effects icon.  The drop-down list displays a gallery of effects combinations. The current effects combination is highlighted. 
• Point to each combination to see how One effects will or chart inserted on the document page. 
• Click -the effects combination you want. 

Create a new theme font set for MS Word

Create a new theme font set 

• On the Page Layout tab,  in the Themes group,  click Fonts icon. 
• Click Create New Theme Fonts at the bottom of the drop-down list. 
• From the Create New Theme Fonts dialog box,  click either or both the Heading font: and Body font: down arrows to select a new font combination. 
• Type a new name for the font combination you'Ve selected in the Name: text box,  and click the Save button.  

Apply a theme to the document for MS Word

Apply a theme to the document 

• On the Page Layout tab,  in the Themes group,  click Theme icon to display a gallery of themes. 
• Click the theme you want,  and it will be applied to the current document. 

Page Layout / Word Themes for MS Word

Page Layout 

Word Themes 
A theme in Word consists of three elements;
Colors: Each theme consists of a set of four colors for text and background,  six colors for accents,  and two colors for hyperlinks.  You can change any single color element or all of them.
Fonts : Two fonts are chosen as part of the theme - one for the heading font use for headings and a second for the body font used for general text entry.  The default fonts used in Word for a new document are Calibre for body text and Cambria for headings.
Design effects: These effects are applied to any graphics, pictures,  charts or design elements in your document.  The effects can include lines :borders),  fills,  and effects such as 3D,  shading,  graduation,  drop-shadows,  and other design subtleties. 

Add a clip art in Word document for MS Word

Add a clip art in Word document 

• Place your insertion point in the paragraph or table where you want to insert the clip art. 
• From the insert tab,  in the lllustrations group,  click the Clip Art icon.  The Clip Art taste pane opens in the right-hand side of the window. 
• In the Search for: text box,  type a keyword that related to the clip art that you want to find.  For expletive,  type tiger in the box. 
• Click the Search in : down arrow,  and refine your search to specific collections.  You can check the Everywhere box. 

Note : The Web Collections allow you to search thousands of clips available at Microsoft Office Online site (You need to have an Internet connection for this).

• Click the Results should be: down arrow , and clear all files types other than clip art. 
• Click Go button.  In a few moments,  thumbnails of the search results will appear. 
• Click the thumbnail to insert it in your document. 

Wrap a Word picture with text for MS Word

Wrap a word Picture with text 

• Place a picture in a document,  and drag a picture to any location on a page even if other content shifts on the page
• Click the picture to select it. 
• From the Picture Tools Format tab,  in the Arrange group,  click the Position icon, 
• Under the With Text Wrapping section,  choose and click on any wrapping style,  except in Line with Text, 
• The picture is exposition the the selected location.  You can now freely drag the picture to anywhere in the document. 

Charge a picture file size for MS Word

Change a picture file size

• Open and select the pictures whose file size you want to reduce, 
• From the Picture Tools Format tab,  in the Adjust group,  click the Compress pictures icon. 
• From the Compress Picture dialog box displayed,  user the Apply to section,  choose Selected pictures if that you want (versus applying it to all the pictures in the document). 
• Under the Change resolution section,  choose whether the target output should be printing the document,  viewing it on the web/screen, or no change. The greater the spirit,  the higher the resolution. 
• Under the Options section,  choose whether to compress picture and / or whether to delete cropped areas of pictures. 
• Once finish,  sick OK to close the Compress Pictures dialog box. 

Crop a picture for MS Word

Crop a picture 

• Open and select the picture you want to crop. 
• From the Picture Tools Format tab,  in the size group,  click the Crop icon
• The picture redisplays wi5h eight sizing handles on the corners and sides,  and the mouse pointer becomes a cropping icon when outside the picture. 

Add a picture to your word document Steps: for MS Word

Add a picture to your word document Steps :

• Place your insertion point in the document where you want to place the picture. 
• From the Insert tab,  in the workstations group,  click the Picture icon. 
• From the Insert Picture dialog box displayed,  browse to the location where the picture you want to insert,  and select it. 
• Click Insert button.  The picture is inserted in the document. 
• From the Picture Tools Format tab,  you can adjust custom setting,  such as adjusting brightness and contrast with choosing to display the image with various borders and effects,  Note : If the Picture Tools Format tab is not showing,  click the picture to select it 
• Once you have added the picture,  you can remove areas from a picture that you do not want by using the Crop tool.

Add Picture for MS Word

Add Picture :

             Once the picture inserted in your document it can be manipulated in a number of ways such as resize it,  and move them into the exact positions that you want,  wrap a picture with text,  and so on. 

This tutorial will guide you on how to insert a picture to your document and some basic manipulations. 

Draw a Table (method 3)

• Click the Insert tab of the Ribbon .
• In the Table group,  click the Table Icon.  Word displays a drop-down list, 
• Click on Draw Table from the list of options. Word charges to Print Layout view (If you are not already in that view) and charges the mouse pointer to define so it looks like a pencil. 
• Use the mouse pointer to define the outside borders of your table,  much as you would draw in a drawing program. Use the pencil to draw the columns and rows into the table-Press Esc when you are done. 

Insert a Table ( method 2) for MS Word

• Click the Insert tab of the Ribbon. 
• In the Table group,  click the Table icon. 
• From the drop-down list displayed,  click th3 Insert Table command. 
• From the Insert Table dialog box displayed, in the Table size section,  specify the Number of columns and Number of rows of the table. 
• Click OK. 
• As an alternative to using the convenient Insert Table command,  you can use Word's draw a table feature. 

Insert a Table (method 1) for MS Word

• Click the Insert tab of the Ribbon. 
• In the Table group,  click the Table icon .Word displays a drop-down list. 
• Drag the intended table columns and rows from the table grid. For example,  5×5 table's.  The table will automatically insert into the document.