Company Name: Chili Pepper IT Telephone: Fax: Cell Phone: Email: infochilipepperit.co.za Website:

Course Title:   Advanced Computers

Advanced Course 

Introduction 

Learners who attend this computer programme will acquire advanced skills in MS Excel, MS word, MS PowerPoint and MS Access. This programme is customized to meet specific needs of learners and may differ from learner to learner. The advanced course is divided into three modules and allows a learner to complete each module individually or as a complete three-module course, each module will be individually examined for competency and the results recorded with the ISETT SETA.

• Formatting skills
• Editing skills
• Graphic effects
• Working with tables and columns
• Managing large documents
• Working with templates
• Mail merge
• Preparing documents for the Internet

Microsoft® Excel Advanced (1 day course)

• Screen structures, menus and toolbars and how to find your way around
• Range names and cell referencing
• Working with multiple worksheets and linking workbooks
• Creation of charts, and pivot table
• Using of formulae and functions
• Using pivot tables

• Screen structures, menus and toolbars and how to find your way around
• Creating, editing, printing and saving the presentation.
• Setting up a presentation using formatting, images and clipart to create a quality presentation
• Manipulating text between slides
• Working with slide master
• Using animation features in a slide show

Slide shows automated and manual

• Screen structures, menus and toolbars and how to find your way around
• Creating and maintaining a database
• Using tables and methods of entering data
• Understanding and using queries effectively
• Database manipulation techniques
• Relational database, query joins, and cross tab queries
• Using per designed forms and designing forms
• Using pre designed reports and designing reports

Course Title 2 Advanced Computers Classification IT -> General -> General IT Advanced Course Requirements Learner requirements Learners, who wish to participate in a particular advanced course, must have Intermediate computer skills in the course applied for:- MS Word, MS Excel, MS PowerPoint or MS Access. Price Notes Qualification details Learners will receive an attendance certificate for each module successfully completed: Certificate in MS Excel Certificate in MS Word Certificate in MS PowerPoint Certificate in MS Access Course Manuals and other material All manuals, materials, refreshments and a light lunch are included in the fee. Examination A formal practical competency examination will be conducted after completion of each course. This examination will be held at a date to be arranged by the learner. We strongly recommend that this exam takes place within one month following the course. The pass percentage is 50%. Free Revision option Learners have a free 2 hours non-facilitated revision option, where they can come and use a computer for revision purposes. Free re-write option Learners who fail the examination may re-write the course free of charge within six months of completion of the course.

Course Information Location Gauteng - Edenvale Course Type Customised Start Dates Length of Course Final Registration Date

Contact Details Name management Phone +27 (011) 6098718 Email infochilipepperit.co.za