Human Resources

Areas Of Practice

Management Information Services

General Course Outline

Windows

1- Description of the Windows environment
2- Working with multiple Windows
3- Structure and principle in a Dialog Box
5- Description/ explanation of a hard disk
6- Working with folders
7- The folder hierarchy system ( directories)
8- Display options ( screen colours, screen savers )
9- Cut , Copy, Paste
10- Moving between applications
11- Create Shortcuts
12- Exercices

Word (Beginner )

1. Getting Started with Word
2. Word screen description
3. Using help in Word
4. Basic editing task
5. Documents: Save, Open
6. Cut , copy, paste
7. Format text and Special Characters
8. Tabs
9. Using the dictionary
10. Printing
11. Page break
12. Screen display option
13. Exercises

Word (Intermediate)

1- Review of basic tasks in Word
2- Detail page layout
3- Working with styles
4- Printer configuration
5- Using the drawing tool bar
6- Page numbering
7- Menu description
8- Cut , Copy and Paste
11- Word Art
10- Working with tables
13- Working with columns
14- Graphics insertion
15- Page Header And Footer
16- Exercises

Word (Advanced )

1. Revision of intermediate tasks in Word
2. Find and Replace Text
3. Working with multiple documents
4. Automatic Formating
5. Insertion of Files
6. Working in modification mode
7. Page and document notes
8. Creation of Templates
9. Mail Merging
10. Macros
11. Table Of Contents 12. Personalize Tool Bars
13. Exercises

Excel (Beginner )

1- Starting plus exiting Excel
2- Examining the Excel windows
3- Changing sizes of columns and rows
4- Entering data
5- Save and open worksheet
6- Cell format (money, date, whole numbers, fractions, decimal etc.. )
8- Printing documents
9- Mathematical operators
10- Work With The Most Useful Formula
11- Page Layout
12- Exercises

Excel (Intermediate)

1- Review of Basic Concepts of Excel
2- Presentation of graphs
3- Creation plus modification of graphs
4- Cut, Copy, Paste With Link
5- Protecting a cell and sheet
6- Insertion of comments in a cell
7- Excel's'configuration options
8- Images insertion
9- Personalize tool bar
10- Working with ranges
11- Exercises

Excel (Advanced )

1. Revisons of intermediate tasks
2. Conditional format
3. Data base presentation
4. Entering data
5. Using Automatic Filter
6. Using Elaborated Filter
7. Working with Audit functions
8. Create plus Execute Macros
9. Validation on a Cell
10. Exercises