Certificate in Advanced IT Office Professional Package

Course details

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.

Course Outline

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 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 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

Advaned Microsoft Access 2010

• Advanced Tables
• Advanced Query
• Advanced Forms
• Advanced Reports
• Macros Basics

Academic Qualification

Basic IT knowledge with command of English

Proficiency Level

English at Primary level & above

Course Outcome

Certificate