Intermediate Computer Skills

This course aims to take candidates who have completed the basic computer course up to the next level in computer literacy.

Upon completion of this course, candidates will be ready to be employed in jobs requiring computer literacy.

Units covered in this course include:

Microsoft Word Advanced

• Automatic Features
• Autotext
• Tracking changes
• Labels
• Mail Merge
• Templates

Windows XP / Vista Advanced

• Desktop Features
• Control Panel
• Regional Settings & Hebrew Settings
• Using external storage devices
• Transferring images from a digital camera
• Using a scanner

Microsoft Outlook Advanced

• Mail options and settings
• Track email and automatic settings
• Advanced Contacts features
• Mail Merge
• Meetings and group scheduling
• Understanding Remote Mail and the use of a Blackberry

Microsoft Internet Explorer Advanced

• Using Autofill for forms
• Page Settings
• Social Networking Sites
• Using Photo websites
• Other useful websites

Microsoft Excel Advanced

• Advanced Calculations
• Conditional Formatting
• Relative and Absolute Cell References
• Lookup Tables
• Advanced Charting of Data

Microsoft Access

• Planning a Database
• Building the Structure of a Database
• Controlling Data Entry
• Querying a Database
• Designing Forms
• Producing Reports
• Creating Mailing Labels

Advanced Graphics

• Manipulating images with appropriate software
• Photoshop

Entry Requirements:

Candidates are required to have completed the Basic Computer Skills course or have previous experience and competence in IT.