Learn how to do many things in Excel

HOW TO MERGE CELLS:  this command is used to join two or more cells to form one but big cell,

Process: highlight the cells and from the home tab, click on format and select format cell, click on alignment from the box that will appear, click on merge cell from the four Conner box and finally click OK.

HOW TO GIVE CELL BORDER: though excel have is like a table in times of description, but when printed out the border will not print together with the write-ups, for your you excel work to print together with the border you need to add cell borders to it. Now how can you add it? Follow the procedure very well:

1.      Highlight the areas you want to give borders

2.      then from the home tab, click on format and select format cell, click on Border from the box that will appear

3.      select the kind of border (style) you want by clicking on it

4.      and click on the outline and inside box then finally click ok

 Note that “none” means NO BORDER:

HOW TO DRAG THE CONTENTS OF A CELL

This may be needed when typing and it happens that the particular range of cells where you placed your text is no more required area for the worksheet, so you may be asked to reposition the write-ups.

Procedure:

1.      highlight the required area of the worksheet where the write-ups is

2.      place your mouse in the edge of the highlighted area

3.      drag to any area of your choice

THINGS TO KNOW ABOUT EXCEL:

1.      The rows are arrange numerically (123) 1-1048576

2.      The columns are arrange in alphabetical order (ABC) A-XFD

3.      The formula must start with an equal-to sign (=)

4.      You must know how to work with table

5.      Identification of cell address (cell references)

6.      You should also be calculative and statistical in nature

Etc.