Module 1 : Business English for Effective Communication
Contact Hours : 30 hours

1. Understand the purposes of business communication and its building blocks of effective messages;
   
2. The new 7Cs in business communication;
   
3. Internal and external office communication;
   
4. Messages, memos, meeting agenda, minutes, email, faxes and proposal;
   
5. Sales, ordering, marketing, delivery, products explanation and payment;
   
6. Letters of enquiry, reply, orders and acknowledgements and complaints;
   
7. Correct use of writing format and the notion of tone and style;
   
8. Common errors in business communication, and addressing concerns and problems previously encountered;
   
9. Discussions on sample correspondences, and inspiring confidence for application of the learned skills.

Back to Top

Module 2 :  Modern Word Processing Techniques
Contact Hours : 15 hours

1. Overview of basic word processing techniques using different layouts;
   
2. Chinese content formatting consideration;
   
3. Getting help and printing;
   
4. Advanced formatting techniques like Styles and Auto Formatting, etc.;
   
5. Automate Tasks like Recording, Editing and Using Simple Macros;
   
6. Proof-read a document for errors (e.g. keying-in, spelling, layout, grammar, punctuation);
   
7. Outlining and Organizing a long document by Create Index, Table of Content, Footnotes and Bookmarks;
   
8. Envelopes and Labels;
   
9. Using Word with Outlook;
   
10. Advanced Mail Merge, and Printing Document;
    
11. Integrate other objects into Word Documents (Graphics, Pictures, Diagrams, Charts, etc.);
    
12. Publishing a web page.

Back to Top

Module 3 : Modern Spreadsheet Processing (Excel)
Contact Hours : 15 hours

1. Introduction to Excel and its use in creating worksheets, graphs, databases and macros;
   
2. Introductory overview of basic commands of Excel, including creation and modification of worksheets, use of simple Range name, Formulas, Functions and development of charts;
   
3. Marco Recorder;
   
4. Creating and editing a macro;
   
5. Recording actions, making decision, and repeating an action with a macro;
   
6. Creating charts from database and lists management;
   
7. Using absolute/relative/mixed addressing technique;
   
8. Using Comments and Templates;
   
9. Use of Pivot Table;
   
10. Other powerful skills.

Back to Top

Module 4 : Business Graphics and Presentation (PowerPoint)
Contact Hours : 15 hours

1. Introduction to PowerPoint working environment;
   
2. Creating and producing presentations;
   
3. Customizing design templates with slide masters;
   
4. Inserting clip art and graphs, adding special effects and transitional effects;
   
5. Basic photo-retouching technique;
   
6. Capture, Import and Organize various media elements;
   
7. Synchronize media elements;
   
8. Using video transitions and effects;
   
9. Linking external information to the presentation;
   
10. Use PowerPoint "Wizards" to quickly create professional-looking presentation;
    
11. Publish and share the presentation on-line;
    
12. New features in PowerPoint;
    
13. Speaking skills, confidence and poise during presentation.

Back to Top

Module 5 :Database Software and Application (Access)
Contact Hours : 15 hours

1. File systems and database;
   
2. Table design, fields, data type, data entry, working with records;
   
3. Relationships, Queries, Forms, Reports, Macros;
   
4. Querying a database data search, and update query;
   
5. Maintaining a database relationship, index, referential integrity;
   
6. Presenting data reports and forms;
   
7. Advanced topics like macros and modules, GUI as menu;
   
8. Working with hyperlinks;
   
9. Introduction to Application Development;
   
10. Other useful tools like Importing and Exporting, Compact & Repair, Object Dependencies;
    
11. Database administration;
    
12. Database security.

Back to Top

Module 6 :Advanced Word Processing Techniques
Contact Hours : 15 hours

1. Automate the creation and formatting of business documents;
   
2. Create multiple-page reports with sections, alternating headers and footers, and utilize templates;
   
3. Automate tasks with Macros;
   
4. Time saver-wizard and thesaurus;
   
5. Forms and formatting;
   
6. Outlining and organizing a long document by Create Index, Table of Content, Footnotes and Bookmarks;
   
7. Mirror margins on odd and even pages to create a binding margin for duplex printing;
   
8. Integrate other objects into Word (like Graphics, Pictures, Diagrams, Charts, etc.);
   
9. Working with variables, operators, and built-in Word functions;
   
10. Creating custom menus, dialog boxes, and toolbars;
    
11. Building a simple custom program;
    
12. Protect and restrict document, Macros;
    
13. Controlling documents on the Internet;
    
14. Information sharing and online collaboration.

Back to Top

Module 7 : Advanced Spreadsheet Processing (Excel)
Contact Hours : 15 hours

1. Organizing business information;
   
2. Various formatting techniques and using of templates (style sheets);
   
3. Use of range names;
   
4. Analyzing business information;
   
5. Use of Pivot Table and Pivot Chart Report;
   
6. Excel macros/Visual Basic programming, essential techniques and application examples;
   
7. Useful Excel functions like financial formulas, date and time, lookup and reference, database, text, logical expressions, etc., and typical function use in selected cases;
   
8. Protecting worksheet style, contents and elements;
   
9. Essential conditional analysis, analyzing data with use of logical functions;
   
10. Managing business information;
    
11. Information sharing and online collaboration.

Back to Top

Module 8 : Office Procedures
Contact Hours : 30 hours

1. Office and its role in the organisation;
   
2. Current operating functions, practices and procedures;
   
3. Importance of interpersonal skills, work habits, and attitudes;
   
4. Oral and writing skills in modern business;
   
5. Office technology (machinery and equipment) in supporting the activity of organization;
   
6. Business graphics;
   
7. Web design and development for marketing;
   
8. Business documentation and payment procedures;
   
9. Information and record handling;
   
10. Meetings and travel arrangement.

Back to Top

Module 9 : Office Automation and Management
Contact Hours : 15 hours

1. Produce elegant report using Word and Excel;
   
2. Creating sophisticated presentation using PowerPoint with Word and Excel;
   
3. Custom Mail Merge using Word and Access;
   
4. Data Analysis using Excel with Access;
   
5. Using MS Outlook with other Office components;
   
6. Use of computerized equipment, software and communications technology;
   
7. Importance of office organization, teamwork and workplace ethics;
   
8. Discussion on office politics, colleagues with different personalities and conflict-resolution skills.

Back to Top

Module 10 : Practical Chinese for Business [實用商業中文]
Contact Hours : 35 hours

1. 課程簡介、錯別字、詞類、標點符號
   
2. 書面語和口語、病句修改、中文商業寫作概要
   
3. 商業書信
   
4. 電郵
   
5. 備忘
   
6. 開會通知及會議議程
   
7. 會議記錄
   
8. 報告
   
9. 新聞稿
   
10. 撰寫演講辭、個人演講訓練
    
11. 口語傳意的特點、口頭報告、指示
    
12. 示範、簡報、禮節語言

Back to Top