About this Course

Objectives:

Upon completion of the course, students will be able to apply advanced texts, paragraphs, column and table formatting, use the spreadsheet application to produce advanced spreadsheet outputs, understand key database concepts and use a relational database application, to understand presentation planning and sign considerations and use the presentation application to produce advanced presentation outputs.

Advanced Microsoft Word 2010

• Controlling Screen View 

• Formatting Documents 

• Newspaper-Style Column 

• Working with Tables 

• Forms 

• File Security 

• Recording and Running Macros 

• Advanced Mail Merge 

• Wizard and Templates 

Advanced Microsoft Excel 2010

• Working with Workbook 

• Creating Formulas and Links 

• Creating Graphics Objects 

• Sorting and Filtering Data in a List 

• Changing how you view your worksheet 

• Protecting a Worksheet 

• Creating Forms 

• Working with Lookup Tables 

• Formatting Numbers 

• Using Pivot Table 

• Using Analysis Tools 

• Introducing Macro

Advanced Microsoft PowerPoint 2010

• Controls of Screen View 

• Working with Text and Labels 

• Using Drawing Tools 

• Applying Clipart 

• Applying Templates 

• Working with Charts 

• Animations and Sounds Effect  on Slide Show 

• Working with Word Art 

• Presenting the Show

Advanced Microsoft Access 2010

• Advanced Tables 

• Advanced Query 

• Advanced Forms 

• Advanced Reports 

• Macros Basics

Teacher-Student ratio is 1:10 / 1:8

Entry requirements

Minimum Age : 16 years

Academic qualification : Obtain Certificate in MS Office

Proficiency Level : At least a pass in P4 Level English with an mark of 40

Course Outcomes : Certificate

Duration : Part-time : 60 Hours

Mode of delivery : IT Room, Illustration, Demonstration, and hands-on

Rate this course:

Log in to submit

Comments