Project Description

Loading...

CEF Course Code: 21C05704-5
CEF Institution Code: 608
Welkin Course Code: COF

Course Features

Although Microsoft Office is the most commonly used software suite in the office, many users fail to benefit fully from its rich and powerful features. Time is wasted and productivity is compromised because it takes them longer time to accomplish tasks that can be more easily and effectively done.
This course provides you with the skills to tap into the power of individual Microsoft Office applications including Excel, Word, PowerPoint and Outlook. You will learn how to use the applications collaboratively to increase work efficiency and quality. The training equips you with the expertise that a competent Microsoft Office user is expected to demonstrate.

  • Course emcompassing 4 widely-used Office applications
  • Easy-to-follow, step-by-step instruction
  • Practical guidance, useful tips and tricks
  • Qualified and experienced instructors
  • Daytime and evening classes with Cantonese and English language options
By the end of the course you should have a great understanding of the features of Microsoft Excel, Word, PowerPoint and Outlook and be abe to apply the skills learned to everyday scenarios.

Learn from the Experts

What you can learn from Effective Use of Microsoft Office in Business?

Get Your Skills Certified

mos-certificate
Certify your Microsoft Office skills with Microsoft Office Specialist Certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.
Remark: The course fee does not include the certification exams.

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Excel with the CEF reimbursable course Business Analysis with Microsoft Excel.

Course Fee

$1500*

*after maximum 80% fee reimbursement from CEF. Full course fee is $7500, payable by monthly instalments.

Am I eligible for CEF subsidy?

Course Duration

48 Hours

Course Prerequisites

Course applicants should be at least 18 years old and have completed Form 5. They are also required to have elementary skills in emailing, Microsoft Windows, Word and Excel

Title of Award & Assessment Methods

There are a number of assignments in the course. The course certificate will be awarded to students who have satisfied the attendance requirement and passed in the assignments.

Schedule & Online Enrolment
Enquiry/Booking

You will pay the course fee ($7,500) by instalments unless your course finishes within one calendar month. The number of instalments is the number of calendar months that your course spans. At enrolment, you are required to pay only the first instalment, the amount of which is shown next to the “Enrol” button.

Sign up for your course by clicking the “Enrol” button, then proceed to checkout to finish course registration.

Effective Use of Microsoft Office in Business (Code: 21C05704-5)
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Course Fee 全期學費Enrol 報名
COFB-6D4CCantonese / PC / Central04-May22-JunSAT1000-1300;1400-170048 hours/ 16 sessions20190504$7,500

$3,750Enrol

COFB-6D11EEnglish / PC / Central11-May29-JunSAT1000-1300;1400-170048 hours/ 16 sessions20190511$7,500

$3,750Enrol

COFB-14D10KCantonese / PC / MongKok10/0608/07MON,THU0945-1245;1400-170048 hours/ 16 sessions20190610$7,500

$3,750Enrol

COFC-13C10CCantonese / PC / Central10/0605/08MON,WED1900-220048 hours/ 16 sessions20190610$7,500

$2,500Enrol

COFC-6D15KCantonese / PC / MongKok15/0603/08SAT1000-1300;1400-170048 hours/ 16 sessions20190615$7,500

$2,500Enrol

COFC-13C33KCantonese / PC / MongKok17/0612/08MON,WED1900-220048 hours/ 16 sessions20190617$7,500

$2,500Enrol

COFC-25C25EEnglish / PC / Central25/0616/08TUE,FRI1900-220048 hours/ 16 sessions20190625$7,500

$2,500Enrol

COFB-6D32CCantonese / PC / Central06/0724/08SAT1000-1300;1400-170048 hours/ 16 sessions20190706$7,500

$3,750Enrol

COFB-6D43EEnglish / PC / Central13/0731/08SAT1000-1300;1400-170048 hours/ 16 sessions20190713$7,500

$3,750Enrol

COFB-14D23KCantonese / PC / MongKok22/0715/08MON,THU0945-1245;1400-170048 hours/ 16 sessions20190722$7,500

$3,750Enrol

COFB-24C6CCantonese / PC / Central06/0826/09TUE,THU1900-220048 hours/ 16 sessions20190806$7,500

$3,750Enrol

COFB-24C6KCantonese / PC / MongKok06/0826/09TUE,THU1900-220048 hours/ 16 sessions20190806$7,500

$3,750Enrol

COFB-25D13CCantonese / PC / Central13/0806/09TUE,FRI0945-1245;1400-170048 hours/ 16 sessions20190813$7,500

$3,750Enrol

COFC-6D17KCantonese / PC / MongKok17/0812/10SAT1000-1300;1400-170048 hours/ 16 sessions20190817$7,500

$2,500Enrol

COFC-24C17EEnglish / PC / Central17/0912/11TUE,THU1900-220048 hours/ 16 sessions20190917$7,500

$2,500Enrol

COFC-6D14EEnglish / PC / Central21/0909/11SAT1000-1300;1400-170048 hours/ 16 sessions20190921$7,500

$2,500Enrol

COFB-25D6KCantonese / PC / MongKok24/0922/10TUE,FRI0945-1245;1400-170048 hours/ 16 sessions20190924$7,500

$3,750Enrol

COFC-35C33KCantonese / PC / MongKok25/0915/11WED,FRI1900-220048 hours/ 16 sessions20190925$7,500

$2,500Enrol

COFB-35C33CCantonese / PC / Central02/1022/11WED,FRI1900-220048 hours/ 16 sessions20191002$7,500

$3,750Enrol

COFC-6D25KCantonese / PC / MongKok19/1007/12SAT1000-1300;1400-170048 hours/ 16 sessions20191019$7,500

$2,500Enrol

COFB-13D33CCantonese / PC / Central21/1013/11MON,WED0945-1245;1400-170048 hours/ 16 sessions20191021$7,500

$3,750Enrol

COFC-25C23KCantonese / PC / MongKok23/0418/06TUE,FRI1900-220048 hours/ 16 sessions20190423$7,500

$2,500Enrol

COFB-35D24CCantonese / PC / Central24/0422/05WED,FRI0945-1245;1400-170048 hours/ 16 sessions20190424$7,500

$3,750Enrol

COFC-6D13KCantonese / PC / MongKok27/0415/06SAT1000-1300;1400-170048 hours/ 16 sessions20190427$7,500

$2,500Enrol

COFB-6D4CCantonese / PC / Central04/0522/06SAT1000-1300;1400-170048 hours/ 16 sessions20190504$7,500

$3,750Enrol

COFB-6D11EEnglish / PC / Central11/0529/06SAT1000-1300;1400-170048 hours/ 16 sessions20190511$7,500

$3,750Enrol

COFB-14D10KCantonese / PC / MongKok10/0608/07MON,THU0945-1245;1400-170048 hours/ 16 sessions20190610$7,500

$3,750Enrol

COFC-13C10CCantonese / PC / Central10/0605/08MON,WED1900-220048 hours/ 16 sessions20190610$7,500

$2,500Enrol

COFC-6D15KCantonese / PC / MongKok15/0603/08SAT1000-1300;1400-170048 hours/ 16 sessions20190615$7,500

$2,500Enrol

COFC-13C33KCantonese / PC / MongKok17/0612/08MON,WED1900-220048 hours/ 16 sessions20190617$7,500

$2,500Enrol

COFC-25C25EEnglish / PC / Central25/0616/08TUE,FRI1900-220048 hours/ 16 sessions20190625$7,500

$2,500Enrol

COFB-6D32CCantonese / PC / Central06/0724/08SAT1000-1300;1400-170048 hours/ 16 sessions20190706$7,500

$3,750Enrol

COFB-6D43EEnglish / PC / Central13/0731/08SAT1000-1300;1400-170048 hours/ 16 sessions20190713$7,500

$3,750Enrol

COFB-14D23KCantonese / PC / MongKok22/0715/08MON,THU0945-1245;1400-170048 hours/ 16 sessions20190722$7,500

$3,750Enrol

COFB-24C6CCantonese / PC / Central06/0826/09TUE,THU1900-220048 hours/ 16 sessions20190806$7,500

$3,750Enrol

COFB-24C6KCantonese / PC / MongKok06/0826/09TUE,THU1900-220048 hours/ 16 sessions20190806$7,500

$3,750Enrol

COFB-25D13CCantonese / PC / Central13/0806/09TUE,FRI0945-1245;1400-170048 hours/ 16 sessions20190813$7,500

$3,750Enrol

COFC-6D17KCantonese / PC / MongKok17/0812/10SAT1000-1300;1400-170048 hours/ 16 sessions20190817$7,500

$2,500Enrol

COFC-24C17EEnglish / PC / Central17/0912/11TUE,THU1900-220048 hours/ 16 sessions20190917$7,500

$2,500Enrol

COFC-6D14EEnglish / PC / Central21/0909/11SAT1000-1300;1400-170048 hours/ 16 sessions20190921$7,500

$2,500Enrol

COFB-25D6KCantonese / PC / MongKok24/0922/10TUE,FRI0945-1245;1400-170048 hours/ 16 sessions20190924$7,500

$3,750Enrol

COFC-35C33KCantonese / PC / MongKok25/0915/11WED,FRI1900-220048 hours/ 16 sessions20190925$7,500

$2,500Enrol

COFB-35C33CCantonese / PC / Central02/1022/11WED,FRI1900-220048 hours/ 16 sessions20191002$7,500

$3,750Enrol

COFC-6D25KCantonese / PC / MongKok19/1007/12SAT1000-1300;1400-170048 hours/ 16 sessions20191019$7,500

$2,500Enrol

COFB-13D33CCantonese / PC / Central21/1013/11MON,WED0945-1245;1400-170048 hours/ 16 sessions20191021$7,500

$3,750Enrol

COFC-25C23KCantonese / PC / MongKok23/0418/06TUE,FRI1900-220048 hours/ 16 sessions20190423$7,500

$2,500Enrol

COFB-35D24CCantonese / PC / Central24/0422/05WED,FRI0945-1245;1400-170048 hours/ 16 sessions20190424$7,500

$3,750Enrol

COFC-6D13KCantonese / PC / MongKok27/0415/06SAT1000-1300;1400-170048 hours/ 16 sessions20190427$7,500

$2,500Enrol

COFB-6D4CCantonese / PC / Central04/0522/06SAT1000-1300;1400-170048 hours/ 16 sessions20190504$7,500

$3,750Enrol

COFB-6D11EEnglish / PC / Central11/0529/06SAT1000-1300;1400-170048 hours/ 16 sessions20190511$7,500

$3,750Enrol

COFB-14D10KCantonese / PC / MongKok10/0608/07MON,THU0945-1245;1400-170048 hours/ 16 sessions20190610$7,500

$3,750Enrol

COFC-13C10CCantonese / PC / Central10/0605/08MON,WED1900-220048 hours/ 16 sessions20190610$7,500

$2,500Enrol

COFC-6D15KCantonese / PC / MongKok15/0603/08SAT1000-1300;1400-170048 hours/ 16 sessions20190615$7,500

$2,500Enrol

COFC-13C33KCantonese / PC / MongKok17/0612/08MON,WED1900-220048 hours/ 16 sessions20190617$7,500

$2,500Enrol

COFC-25C25EEnglish / PC / Central25/0616/08TUE,FRI1900-220048 hours/ 16 sessions20190625$7,500

$2,500Enrol

COFB-6D32CCantonese / PC / Central06/0724/08SAT1000-1300;1400-170048 hours/ 16 sessions20190706$7,500

$3,750Enrol

COFB-6D43EEnglish / PC / Central13/0731/08SAT1000-1300;1400-170048 hours/ 16 sessions20190713$7,500

$3,750Enrol

COFB-14D23KCantonese / PC / MongKok22/0715/08MON,THU0945-1245;1400-170048 hours/ 16 sessions20190722$7,500

$3,750Enrol

COFB-24C6CCantonese / PC / Central06/0826/09TUE,THU1900-220048 hours/ 16 sessions20190806$7,500

$3,750Enrol

COFB-24C6KCantonese / PC / MongKok06/0826/09TUE,THU1900-220048 hours/ 16 sessions20190806$7,500

$3,750Enrol

COFB-25D13CCantonese / PC / Central13/0806/09TUE,FRI0945-1245;1400-170048 hours/ 16 sessions20190813$7,500

$3,750Enrol

COFC-6D17KCantonese / PC / MongKok17/0812/10SAT1000-1300;1400-170048 hours/ 16 sessions20190817$7,500

$2,500Enrol

COFC-24C17EEnglish / PC / Central17/0912/11TUE,THU1900-220048 hours/ 16 sessions20190917$7,500

$2,500Enrol

COFC-6D14EEnglish / PC / Central21/0909/11SAT1000-1300;1400-170048 hours/ 16 sessions20190921$7,500

$2,500Enrol

COFB-25D6KCantonese / PC / MongKok24/0922/10TUE,FRI0945-1245;1400-170048 hours/ 16 sessions20190924$7,500

$3,750Enrol

COFC-35C33KCantonese / PC / MongKok25/0915/11WED,FRI1900-220048 hours/ 16 sessions20190925$7,500

$2,500Enrol

COFC-25C23KCantonese / PC / MongKok23/0418/06TUE,FRI1900-220048 hours/ 16 sessions20190423$7,500

$2,500Enrol

COFB-35D24CCantonese / PC / Central24/0422/05WED,FRI0945-1245;1400-170048 hours/ 16 sessions20190424$7,500

$3,750Enrol

COFC-6D13KCantonese / PC / MongKok27/0415/06SAT1000-1300;1400-170048 hours/ 16 sessions20190427$7,500

$2,500Enrol

COFB-6D4CCantonese / PC / Central04/0522/06SAT1000-1300;1400-170048 hours/ 16 sessions20190504$7,500

$3,750Enrol

COFB-6D11EEnglish / PC / Central11/0529/06SAT1000-1300;1400-170048 hours/ 16 sessions20190511$7,500

$3,750Enrol

COFB-14D10KCantonese / PC / MongKok10/0608/07MON,THU0945-1245;1400-170048 hours/ 16 sessions20190610$7,500

$3,750Enrol

COFC-13C10CCantonese / PC / Central10/0605/08MON,WED1900-220048 hours/ 16 sessions20190610$7,500

$2,500Enrol

COFC-6D15KCantonese / PC / MongKok15/0603/08SAT1000-1300;1400-170048 hours/ 16 sessions20190615$7,500

$2,500Enrol

COFC-13C33KCantonese / PC / MongKok17/0612/08MON,WED1900-220048 hours/ 16 sessions20190617$7,500

$2,500Enrol

COFC-25C25EEnglish / PC / Central25/0616/08TUE,FRI1900-220048 hours/ 16 sessions20190625$7,500

$2,500Enrol

COFB-6D32CCantonese / PC / Central06/0724/08SAT1000-1300;1400-170048 hours/ 16 sessions20190706$7,500

$3,750Enrol

COFB-6D43EEnglish / PC / Central13/0731/08SAT1000-1300;1400-170048 hours/ 16 sessions20190713$7,500

$3,750Enrol

COFB-14D23KCantonese / PC / MongKok22/0715/08MON,THU0945-1245;1400-170048 hours/ 16 sessions20190722$7,500

$3,750Enrol

COFB-24C6CCantonese / PC / Central06/0826/09TUE,THU1900-220048 hours/ 16 sessions20190806$7,500

$3,750Enrol

COFB-24C6KCantonese / PC / MongKok06/0826/09TUE,THU1900-220048 hours/ 16 sessions20190806$7,500

$3,750Enrol

COFB-25D13CCantonese / PC / Central13/0806/09TUE,FRI0945-1245;1400-170048 hours/ 16 sessions20190813$7,500

$3,750Enrol

COFC-6D17KCantonese / PC / MongKok17/0812/10SAT1000-1300;1400-170048 hours/ 16 sessions20190817$7,500

$2,500Enrol

COFC-24C17EEnglish / PC / Central17/0912/11TUE,THU1900-220048 hours/ 16 sessions20190917$7,500

$2,500Enrol

COFC-6D14EEnglish / PC / Central21/0909/11SAT1000-1300;1400-170048 hours/ 16 sessions20190921$7,500

$2,500Enrol

COFB-25D6KCantonese / PC / MongKok24/0922/10TUE,FRI0945-1245;1400-170048 hours/ 16 sessions20190924$7,500

$3,750Enrol

COFC-35C33KCantonese / PC / MongKok25/0915/11WED,FRI1900-220048 hours/ 16 sessions20190925$7,500

$2,500Enrol

COFB-35C33CCantonese / PC / Central02/1022/11WED,FRI1900-220048 hours/ 16 sessions20191002$7,500

$3,750Enrol

COFC-6D25KCantonese / PC / MongKok19/1007/12SAT1000-1300;1400-170048 hours/ 16 sessions20191019$7,500

$2,500Enrol

COFB-13D33CCantonese / PC / Central21/1013/11MON,WED0945-1245;1400-170048 hours/ 16 sessions20191021$7,500

$3,750Enrol

COFC-25C23KCantonese / PC / MongKok23/0418/06TUE,FRI1900-220048 hours/ 16 sessions20190423$7,500

$2,500Enrol

COFB-35D24CCantonese / PC / Central24/0422/05WED,FRI0945-1245;1400-170048 hours/ 16 sessions20190424$7,500

$3,750Enrol

COFC-6D13KCantonese / PC / MongKok27/0415/06SAT1000-1300;1400-170048 hours/ 16 sessions20190427$7,500

$2,500Enrol

COFB-6D4CCantonese / PC / Central04/0522/06SAT1000-1300;1400-170048 hours/ 16 sessions20190504$7,500

$3,750Enrol

COFB-6D11EEnglish / PC / Central11/0529/06SAT1000-1300;1400-170048 hours/ 16 sessions20190511$7,500

$3,750Enrol

COFB-14D10KCantonese / PC / MongKok10/0608/07MON,THU0945-1245;1400-170048 hours/ 16 sessions20190610$7,500

$3,750Enrol

COFC-13C10CCantonese / PC / Central10/0605/08MON,WED1900-220048 hours/ 16 sessions20190610$7,500

$2,500Enrol

COFC-6D15KCantonese / PC / MongKok15/0603/08SAT1000-1300;1400-170048 hours/ 16 sessions20190615$7,500

$2,500Enrol

COFC-13C33KCantonese / PC / MongKok17/0612/08MON,WED1900-220048 hours/ 16 sessions20190617$7,500

$2,500Enrol

COFC-25C25EEnglish / PC / Central25/0616/08TUE,FRI1900-220048 hours/ 16 sessions20190625$7,500

$2,500Enrol

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
  • Organizing and protecting Microsoft Office files
    • Protecting your Office files with passwords
    • Privacy information in your Word, Excel and PowerPoint files
    • Hiding and un-hiding Excel formulas
    • Range protection in Excel
  • Using Macros to automate repetitive tasks
    • Using macros in Word
    • Using macros in Excel
  • Publishing documents on the Web
    • Using hyperlinks in Word and Excel
    • Converting a Word document to a web page
    • Publishing your presentation to the web
  • Effective mailing and messaging with Microsoft Outlook and Microsoft Word
    • Emailing with Outlook
      • Composing email messages
      • Sending and receiving email messages
      • Locating Outlook messages
      • Organizing email messages
      • Using rules
    • Creating mail merge with Word
      • Preparing data for mail merge
      • Creating mail merge documents
      • Merging form and data
      • Using conditional information
  • Microsoft Outlook for schedule, task and contact management
    • Scheduling appointments with the Outlook calendar
    • Meeting invitations
    • Group calendar
    • Adding and managing contacts
    • Managing tasks
  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.

You may also be interested in