Advanced Computer Skills – ICDL - Certificate

Pre-requirements:

English Proficiency
Basic knowledge of MS Word, MS Excel, MS PowerPoint and MS Access

Description:

Business today depends on several aspects of information technology. It’s almost impossible to get ahead without computer skills. If you have a wide range of these skills, you’ll be highly employable in a multitude of positions in any business.

Modules:

Advanced Word Processing

• Apply advanced text, paragraph, column and table formatting. Convert text to a table and vice versa
• Work with referencing features like footnotes, end-notes and captions. Create tables of contents, indexes and cross-references
• Enhance productivity by using fields, forms and templates
• Apply advanced mail merge techniques and work with automation features like macros
• Use linking and embedding features to integrate data
• Collaborate on and view documents. Work with master documents and sub-documents. Apply document security features
• Work with watermarks, sections, headers and footers in a document

Advanced Spreadsheets

• Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets
• Use functions such as those associated with logical, statistical, financial and mathematical operations
• Create charts and apply advanced chart formatting features
• Work with tables and lists and analyze, filter and sort data. Create and use scenarios
• Validate and audit spreadsheet data
• Enhance productivity by working with named cell ranges, macros and templates
• Use linking, embedding and importing features to integrate data
• Collaborate on and review spreadsheets. Apply spreadsheet security features

Advanced Presentations

• Understand target audience and venue considerations in presentation planning
• Create and modify templates and format slide backgrounds
• Enhance a presentation using built-in drawing and image tools
• Apply advanced chart formatting features and create and edit diagrams
• Insert movies and sound and apply built-in animation features
• Use linking, embedding, importing and exporting features to integrate data
• Work with custom slide shows, apply slide show settings, and control a slide show

Advanced Databases

• Understand key concepts of database development and usage
• Create a relational database using advanced table creation features and complex relationships between tables
• Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations
• Use control and sub-forms to enhance forms and improve functionality
• Create report controls to perform calculations. Create sub-reports and enhance report presentation
• Enhance productivity by working with macros and use linking and importing features to integrate data

Contact Details

Contact Person: 

Retha/Marzahn
Course Details

Course Delivery Method: 

In Class In Class

Presented Presented Courses

Course Duration: 

6 months

Cost: 

On request

Course fee Includes: 

ICDL skills card and exams