The course is designed specially for office professionals who want to improve their work performance and productivity through the effective use of Microsoft Office. It will help participants enhance desktop skills, better manage business data and streamline workflow. In the course, participants will learn a useful range of intermediate to advanced-level skills covering Excel, Word, PowerPoint, and Outlook. Lectures, hands-on practice and assignments will be based on the latest version of Microsoft Office.

• Creating professional documents with Microsoft Word
  • Text and paragraph formatting
  • Page layout and setup
  • Using styles
  • Using and formatting tables
  • Miscellaneous tips and tricks
• Creating user input forms with Microsoft Word
  • Using Microsoft form template
  • Using Form Content Controls
• Data analysis and management with Microsoft Excel
  • Using Excel functions: IF(), AND(), OR(), VLOOKUP(), database functions, etc
  • Formatting data and worksheets
  • Page setup and printing workbooks
  • Sorting and filtering data
  • Data management tools: data validation, consolidation, what-if analysis, etc
  • Creating charts
  • Analyzing data with Pivot Tables and Pivot Charts
• Microsoft PowerPoint for effective business presentations
  • Creating a presentation
  • Using master slide and themes to format your presentation
  • Creating transitions and animation effects
  • Working with graphic and audio-visual elements
  • Showing Excel worksheets and charts within a PowerPoint presentation
  • Delivering your presentation
• Using templates to standardize styles across documents
  • The benefits of using Microsoft Office templates
  • Creating and using templates in Excel, Word and PowerPoint
• Creating documents collaboratively for work effectiveness
  • Collaborating on Word documents
    • Adding comments co-authoring
    • Tracking document changes
    • Reviewing tracked changes
    • Combining reviewed documents
    • Using Document Inspector
  • Collaborating on Excel spreadsheets
    • Using Excel Services to share data
    • Exchanging workbooks with users of earlier versions
    • Allowing multiple users to edit a workbook
    • Distributing workbooks and consolidating data from multiple worksheets
    • Tracking and reviewing changes

1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to The Office of the Continuing Education Fund, Units 07-11, 25/F., CDW Building, 388 Castle Peak Road, Tsuen Wan, New Territories. Together with a photocopy of their HKID Card before course commencement. Applicants may also place their applications in the drop-in box on 12/F., Cheung Sha Wan Government Offices.