Share
Microsoft Office Tools

Course Outline

Week 1
Week 2
Week 3
Week 4

Word


  • Create a table
  • Merging cells
  • Add formula
  • Borders & shades
  • Writing a CV and cover letter
Week 5

SponsoredAdvertise

Explanations to week content

Create a table


Method 1


  1. Click on the insert tab
  2. Click on table
  3. Hover over the number of columns and rows for the table. When you get the desired number of columns and rows click on it


Image


Figure: Insert table


Method 2


  1. Click on the insert tab
  2. Click on Insert Table
  3. Enter the number of columns and rows for the table in the table dialog that appears


Image


Figure: Table columns and rows dialog box


Method 3


  1. Click on the insert tab
  2. Click on Draw Table
  3. Use the pencil cursor to draw your table



Merging cells


Merging enables you to join two or more cells together and make them one cell. To merge cells follow the steps below:


  1. Highlight the cells with the mouse.
  2. Right click on any of the selected cell
  3. Select merge cells in the options that show


Image


Figure: Merging cells


Borders & Shades


Removing table borders


  1. Click on any cell to show the table move handle at the upper left of the table
  2. Right-click on the table move handle and select Table Properties
  3. In the Table Properties dialog click on Borders & Shading
  4. In the borders tab select None and click Ok


Image

Figure: table move handle


Image


Figure: Table borders dialog box


Adding table borders


  1. Repeat steps 1-3
  2. In the borders tab select the desired border type (Box, All, Grid or Custom).


Shading Table Cell(s)


  1. Select the cell(s)
  2. Right-click in any of the selected cell(s)
  3. Select Table Properties
  4. Click on the Shading tab
  5. Select your appropriate color for the Fill
  6. Click Ok for the dialog boxes to disappear


Image


Figure: Table shading dialog box


Changing Text Direction Of Cell


  1. Right-click in the cell
  2. Click Text Direction
  3. Choose your desired orientation from the dialog box and click ok
  4. Adjust the text using the enter and space keys if necessary


Image


Figure: Text Direction option


Image


Figure: Text Directions 


Design the time table below


Image


Figure: Time table


Step 1


Create 8 columns 7 rows table and enter the names of the days in row 1 starting from column 2


Step 2


Merge the following cells

   

Sunday Column


  1. Column 2 row 2 to column 2 row 5
  2. Column 2 row 6 to column 2 row 7

  

Monday Column


  1. Column 3 row 2 to column 3 row 3
  2. Column 3 row 4 to column 3 row 5

   

Tuesday Column

   

  1. Column 4 row 2 to column 4 row 3
  2. Column 4 row 4 to column 4 row 5
  3. Column 4 row 6 to column 4 row 7

   

Wednesday Column

   

  1. Column 5 row 2 to column 5 row 3
  2. Column 5 row 4 to column 5 row 5
  3. Column 5 row 6 to column 5 row 7

   

Thursday Column

   

  1. Column 6 row 2 to column 6 row 3
  2. Column 6 row 4 to column 6 row 5
  3. Column 6 row 6 to column 6 row 7

   

Friday Column

   

  1. Column 7 row 2 to column 7 row 3
  2. Column 7 row 4 to column 7 row 5
  3. Column 7 row 6 to column 7 row 7

   

Saturday Column

   

Column 8 row 6 to column 8 row 7


Step 3


Color the appropriate cells


Step 4


Set the text direction for the texts in column 1


Writing Formula in table cell


You can use word document to write simple formula in table cell. To add formula to a cell follow the steps below:


  1. Click in the cell you want to write the formula
  2. Click on the Layout tab
  3. Click on formula
  4. Type the formula in the formula box after the = sign using the table cell numbers - Alphabets for columns and numbers for rows


Examples


Column 1 is A, column 2 is B, column 3 is C etc. Therefore column 1 row 1 will be A1, column 2 row 1 will be B1, column 1 row 2 will be A2 and column 2 row 2 will be B2 etc.


Examples


If you want to add column 1 row 2 (A2) and column 2 row 2 (B2) and place the result in column 3 row 2 (C2),

you can write any of these in the formula box while the cursor in cell C2:

=sum(A2,B2) or =A2+B2 or =sum(LEFT)


You can use positional arguments (LEFT, RIGHT, ABOVE, BELOW) with these functions:


  • AVERAGE
  • COUNT
  • MAX
  • MIN
  • PRODUCT
  • SUM 


Usage of the above formula


AVERAGE - Finds the average of the numbers

COUNT - count how many numbers are in cells

MAX - finds the maximum number

MIN - finds the minimum number

PRODUCT - finds the result of the multiplication of the numbers

SUM - adds the numbers


Updating formula field


After making changes to a value in table cell, word doesn't automatically update the result in the formula cell. You have to select the value and right-click on the value and select Update Field


Image


Figure: Update formula value


Writing a CV


  1. Use table for the personal information, educational background, work experience and or references
  2. Remove the borders of the tables used


Writing a cover letter


  1. Your address and date at the left
  2. Followed by the recipient's address at the left.
  3. Salutation/greeting e.g. Dear Hiring Manager, or name of the manager if you know
  4. Title of the letter bold, centered and in capital blocks
  5. Content of the letter
  6. Complimentary close e.g. Yours Sincerely,
  7. Signature space

SponsoredAdvertise