Project Description
CEF 課程編號: 21C110426
CEF 院校編號: 548
天行課程編號: COF
課程特點
Microsoft Office 可說是電腦中最普及的應用軟件。但往往最常見的就是你最忽略的。你能透徹的應用Office的各項功能，幫助自己在事業學業上發揮出色嗎？
本課程特別為辦公室行政人員而設計，教授如何利用 Microsoft Office 提升工作效率和質素。課程可以幫助學員將 Office 的功能特點充份發揮，提升桌面工作產力，妥善運用商業數據及優化工作流程。
- 課程覆蓋MS Office 四大最常用程式，並加強協作的能力
- 深入淺出，提供大量實例和實況練習，確保學習成效
- 課程內容不單是功能的傳授，更是快捷和方便技巧的集成，讓你更快更好的完成Office任務
- 導師具備豐富行業和教學經驗，亦具備Microsoft Office專家名銜
- 備有不同的上課時段(日/晚間、週日/週末)，亦可選擇以粵語或英語授課，切合你的學習需要
學員會學習使用 Microsoft Office 的中階和高階功能，涵蓋 Excel, Word, PowerPoint 及 Outlook 各個軟件。課程中的講授, 練習與作業會以 Microsoft Office 的功能為根據。
學習專家的做法
考取專業認證
認證你的 Microsoft Office 技能，考取 Microsoft Office Specialist (MOS) 官方認證。留意此認證並不是完成此課程的必需要求，但我們高度建議學員在完成本課程後，考取此專業認證，為你的技能作出專業的肯定。
(註) 考試費用並不包括在課程費用之內
相關延伸課程
完成此課程的學員可以考慮學習更多相關技能培訓課程如 Business Analysis with Microsoft Excel.
系統預設展示和收取為全期學費。如果你希望按月繳費，請在結帳時選擇”到校付款”，我們的客戶服務主任很樂意為閣下辦理。CEF資助只須在課程完成時辦理即可。只需按”Enrol”及後到”Checkout”頁面即可辦理留位及付款程序。
| Course No. 課程編號 | Info. 語言/系統/地點 | Start 開課日 | End 完課日 | Day(s) 上課日 | Time 上課時段 | Duration 課程長度 | Enrol 報名 | |
|---|---|---|---|---|---|---|---|---|
| COFC-6B19K | Cantonese / PC / MongKok | 19/06 | 07/08 | SAT | 1000-1300;1400-1700 | 48 hours/ 16 sessions | 20210619 | $7,500Enrol |
| COFB-13C19K | Cantonese / PC / MongKok | 19/07 | 08/09 | MON,WED | 1900-2200 | 48 hours/ 16 sessions | 20210719 | $7,500Enrol |
| COFB-14C23K | Cantonese / PC / MongKok | 23/08 | 18/10 | MON,THU | 1900-2200 | 48 hours/ 16 sessions | 20210823 | $7,500Enrol |
| COFB-6D23K | Cantonese / PC / MongKok | 23/10 | 11/12 | SAT | 1000-1300;1400-1700 | 48 hours/ 16 sessions | 20211023 | $7,500Enrol |
本課程特別為辦公室行政人員而設計，教授如何利用 Microsoft Office 提升工作效率和質素。課程可以幫助學員將 Office 的功能特點充份發揮，提升桌面工作產力，妥善運用商業數據及優化工作流程。學員會學習使用 Microsoft Office 的中階和高階功能，涵蓋 Excel, Word, PowerPoint 及 Outlook 各個軟件。課程中的講授, 練習與作業會以 Microsoft Office 的功能為根據。
- Creating professional documents with Microsoft Word. 專業有效的建立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 在Microsoft Word中建立電子表格
- Using Microsoft form template
- Using Form Content Controls
- Microsoft Excel for data processing and analysis 以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 富感染力及商業傳意的方式建立Microsoft PowerPoint 演示
- 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 在Office裡實踐協力合作，共同完成任務
- 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
- Collaborating on Word documents
- 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
- Emailing with Outlook
- Microsoft Outlook for schedule, task and contact management
- Scheduling appointments with the Outlook calendar
- Meeting invitations
- Group calendar
- Adding and managing contacts
- Managing tasks
