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:
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: Learn how to do many things in Excel
Author: Office Admin
Rating 5 of 5 Des:
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 th...
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: INTRODUCTION TO MS-EXCEL (KEYPOINT)
Author: Office Admin
Rating 5 of 5 Des:
INTRODUCTION:   Excel is an application package that is design to handle numeric data (so many data) .e.g. Taxes, Sales, Payrolls a...

Power Point Layout (Key point)

WHAT IS POWER POINT: Power point is a graphic package that is used for the presentation of programs, to organize and present information very well and professionally for seminar, lectures and meetings. It can also be used for presentation like Firm show, advertisement etc.

HOW TO OPEN MS-POWER POINT:
Click on the start button and select all programs, click on Microsoft office from the box that will appear and select ms-power point. Or right click on the desktop icon containing ms-power point on the desktop and select open.
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: Power Point Layout (Key point)
Author: Office Admin
Rating 5 of 5 Des:
WHAT IS POWER POINT: Power point is a graphic package that is used for the presentation of programs, to organize and present information v...

SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office


Short cuts are keyboard aplied functions which ease you the stress of passing through several processes using the mouse to actualize a given command in the system

There are many keyboard short-cuts, but on this post, below are the available ones. do check back for more updates:

Ctrl A                     -           to select all
Ctrl B                     -           Bold
Ctrl C                     -           Copy
Ctrl D                     -           Duplicate
Ctrl E                     -           Centralize
Ctrl F                     -           Find & Replace
Ctrl G                     -           Find & Replace
Ctrl H                     -           Find & Replace
Ctrl I                      -           Italic a text
Ctrl J                      -           Justify
Ctrl K                     -           Insert Hyperlink or Break apart (Corel draw)
Ctrl L                     -           Align Left
Ctrl M                    -           Move indent to the right
Ctrl N                     -           Open new document
Ctrl O                    -           Open saved document
Ctrl P                     -           Print
Ctrl Q                    -           Move the indent back to the margin or convert to curve (Corel draw)
Ctrl R                     -           Align Right
Ctrl S                     -           Save
Ctrl T                     -           Move lower indent to the right
Ctrl U                     -           Underline
Ctrl V                     -           Paste
Ctrl W                    -           Close the current window
Ctrl X                     -           Cut
Ctrl Y                     -           Redo
Ctrl Z                     -           Undo
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office
Author: Office Admin
Rating 5 of 5 Des:
Short cuts are keyboard aplied functions which ease you the stress of passing through several processes using the mouse to actualize a gi...

HOW TO SAVE DOCUMENTS WITH A PASSWORD


1.      Click the Microsoft Office Button , and then click Save As.
2.      Click Tools, and then click General Options.
3.      Do one or both of the following:
§  If you want reviewers to enter a password before they can view the document, type a password in the Password to open box.
§ 
If you want reviewers to enter a password before they can save changes to the document, type a password in the Password to modify box.


 Notes 
§  Password to open   By default, this feature uses advanced encryption. Encryption is a standard method used to help make your file more secure.
§  Password to modify   This feature does not use any encryption method. It is designed so you can collaborate with content reviewers you trust. Is not designed to help make your file more secure. Both passwords   You can assign both passwords — one to access the file and one to provide specific reviewers with permission to modify its content. Make sure each password is different from the other.
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: HOW TO SAVE DOCUMENTS WITH A PASSWORD
Author: Office Admin
Rating 5 of 5 Des:
1.       Click the Microsoft Office Button , and then click Save As . 2.       Click...
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: How To Save A File (Word, Powerpoint, Excel)
Author: Office Admin
Rating 5 of 5 Des:
HOW TO SAVE IN MS-WORD Click the Microsoft Office Button or FILE  and then click Save A...

Understanding Microsoft Word functions bars



TITLE BAR:
the title bar displays the name of the package you are running, save and unsaved work, as well as the minimize button (-), restore down   (     ) and close button (X).

MENU BAR: the menu bar is the most important bar in Microsoft word, it displays the most essential and frequently used tools in ms word e.g. Home tab, Insert tab, Page layout tab, References tab, mailing tab, Review tab and the View tab. Later you will be taught how to make use of the above mentioned tools as we continue in this study
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: Understanding Microsoft Word functions bars
Author: Office Admin
Rating 5 of 5 Des:
TITLE BAR: the title bar displays the name of the package you are running, save and unsaved work, as well as the minimize butt...

INTRODUCTION TO WORD PROCESSING (MS-WORD)


Word processing is the use of software that aid in the composition, revision, filing and printing of text in the early days of computing, a word processor was an entire computer: dedicated to the task of word processing. Today, word processor commonly means software rather a dedicated computer.
  
The needs to create and manipulate document of different types have gained prominence in the business/ commercial world. Today’s W.P (Word Processing) systems can easily create and manipulate the following kind of document (s).
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: INTRODUCTION TO WORD PROCESSING (MS-WORD)
Author: Office Admin
Rating 5 of 5 Des:
Word processing is the use of software that aid in the composition, revision, filing and printing of text in the early days of computing,...

THE COMPUTER KEYBOARD AND FUNCTIONS

     

   
    Without taking much of your time, the computer keyboard has been fully reviewed and all its functions as related to your office usage are all stated below.
    
    But for a better understanding, you are required to get a keyboard close to yourself, as you identify the keys then follow the functions below. 

1.    ESCAPE (ESC): used to reject or cancel unwanted commands.
2.    FUNCTION KEYS: these set of keys are arranged from F1-F12 and their functions are as follows:
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: THE COMPUTER KEYBOARD AND FUNCTIONS
Author: Office Admin
Rating 5 of 5 Des:
              Without taking much of your time, the computer keyboard has been fully reviewed and all its functions as related to yo...

INTRODUCTION TO COMPUTER (KEY POINTS)


COMPUTER:
This is an electronic device which has the ability of accepting data, processing data and giving out information.  
When a subject is defined; or when something is being introduced, it is possible that there would be thesis, grammars or words that is used during the definition or introduction which may not be clear or self-explanatory. On this regard, I will take little time to throw more lights on the following; Electronic Device, Accepting Data & Processing Data; 
» » » Learn how to do many things in Excel » » INTRODUCTION TO MS-EXCEL (KEYPOINT) » » Power Point Layout (Key point) » » SIMPLE SHORT CUT APPLICATIONS IN Microsoft Office » » » HOW TO SAVE DOCUMENTS WITH A PASSWORD » » » How To Save A File (Word, Powerpoint, Excel) » » Understanding Microsoft Word functions bars » » » INTRODUCTION TO WORD PROCESSING (MS-WORD) » » » » » THE COMPUTER KEYBOARD AND FUNCTIONS » » » » INTRODUCTION TO COMPUTER (KEY POINTS)
Office Admin Office Admin Author
Title: INTRODUCTION TO COMPUTER (KEY POINTS)
Author: Office Admin
Rating 5 of 5 Des:
COMPUTER : This is an electronic device which has the ability of accepting data, processing data and giving out information.   When...
×