Microsoft Office 全科課程 (CEF認可資助)

Loading...

Effective Use of Microsoft Office in Business

Learn how effective use of Office enhances productivity and work quality

CEF 課程編號: 21C05704-5
CEF 院校編號: 608
天行課程編號: COF

課程特點

Microsoft Office 可說是電腦中最普及的應用軟件。但往往最常見的就是你最忽略的。你能透徹的應用Office的各項功能，幫助自己在事業學業上發揮出色嗎？

本課程特別為辦公室行政人員而設計，教授如何利用 Microsoft Office 提升工作效率和質素。課程可以幫助學員將 Office 的功能特點充份發揮，提升桌面工作產力，妥善運用商業數據及優化工作流程。

課程覆蓋MS Office 四大最常用程式，並加強協作的能力

深入淺出，提供大量實例和實況練習，確保學習成效

課程內容不單是功能的傳授，更是快捷和方便技巧的集成，讓你更快更好的完成Office任務

導師具備豐富行業和教學經驗，亦具備Microsoft Office專家名銜

備有不同的上課時段(日/晚間、週日/週末)，亦可選擇以粵語或英語授課，切合你的學習需要

學員會學習使用 Microsoft Office 的中階和高階功能，涵蓋 Excel, Word, PowerPoint 及 Outlook 各個軟件。課程中的講授, 練習與作業會以 Microsoft Office 的功能為根據。

學習專家的做法

考取專業認證

mos-certificate

認證你的 Microsoft Office 技能，考取 Microsoft Office Specialist (MOS) 官方認證。留意此認證並不是完成此課程的必需要求，但我們高度建議學員在完成本課程後，考取此專業認證，為你的技能作出專業的肯定。

(註) 考試費用並不包括在課程費用之內

學費

$1500*

*全期學費為 $7500，並按照持續進修基金規定按月收費，合資格人士畢業後可獲持續進修基金發還最高八成學費，實際學費支出最低為 $1500

我可以申請持續進修基金嗎?

課程時間

48 小時

入學要求

參加者須年滿 18 歲，修畢中五，並對電郵、Microsoft Windows、Word 和 Excel 的操作有基本的認識。

獲頒證書及提交習作

學員須完成由導師指定的作業，成績及出席率合格的學員將獲得畢業證書。

課程時間及報名

查詢/預約

課程時間及報名

歡迎你在本網站報名留位。系統上展視和收取的學費可能因完成課程的時段長短而有所不同。根據學生資助辦事處指引我們會按月收取學費。只需按”Enrol”及後到”Checkout”頁面即可辦理留位及付款程序。

Effective Use of Microsoft Office in Business (Code: 21C05704-5)
Course No. 課程編號	Info. 語言/系統/地點	Start 開課日	End 完課日	Day(s) 上課日	Time 上課時段	Duration 課程長度	Pa_count	Course Fee 全期學費	Enrol 報名
COFC-25C25E	English / PC / Central	25-Jun	16-Aug	TUE,FRI	1900-2200	48 hours/ 16 sessions	20190625	$7,500	$2,500Enrol
COFB-6D32C	Cantonese / PC / Central	06-Jul	24-Aug	SAT	1000-1300;1400-1700	48 hours/ 16 sessions	20190706	$7,500	$3,750Enrol
COFB-6D43E	English / PC / Central	13-Jul	31-Aug	SAT	1000-1300;1400-1700	48 hours/ 16 sessions	20190713	$7,500	$3,750Enrol
COFB-14D23K	Cantonese / PC / MongKok	22-Jul	15-Aug	MON,THU	0945-1245;1400-1700	48 hours/ 16 sessions	20190722	$7,500	$3,750Enrol
COFB-24C6K	Cantonese / PC / MongKok	06-Aug	26-Sep	TUE,THU	1900-2200	48 hours/ 16 sessions	20190806	$7,500	$3,750Enrol
COFB-25D13C	Cantonese / PC / Central	13-Aug	06-Sep	TUE,FRI	0945-1245;1400-1700	48 hours/ 16 sessions	20190813	$7,500	$3,750Enrol
COFC-24C17E	English / PC / Central	17-Sep	12-Nov	TUE,THU	1900-2200	48 hours/ 16 sessions	20190917	$7,500	$2,500Enrol
COFC-6D33C	Cantonese / PC / Central	21-Sep	09-Nov	SAT	1000-1300;1400-1700	48 hours/ 16 sessions	20190921	$7,500	$2,500Enrol
COFB-25D6K	Cantonese / PC / MongKok	24-Sep	29-Oct	TUE,FRI	0945-1245;1400-1700	48 hours/ 16 sessions	20190924	$7,500	$3,750Enrol
COFC-35C33K	Cantonese / PC / MongKok	25-Sep	15-Nov	WED,FRI	1900-2200	48 hours/ 16 sessions	20190925	$7,500	$2,500Enrol
COFB-35C33C	Cantonese / PC / Central	02-Oct	22-Nov	WED,FRI	1900-2200	48 hours/ 16 sessions	20191002	$7,500	$3,750Enrol
COFB-6D14E	English / PC / Central	12-Oct	30-Nov	SAT	1000-1300;1400-1700	48 hours/ 16 sessions	20191012	$7,500	$3,750Enrol
COFC-6D25K	Cantonese / PC / MongKok	19-Oct	07-Dec	SAT	1000-1300;1400-1700	48 hours/ 16 sessions	20191019	$7,500	$2,500Enrol
COFB-13D33C	Cantonese / PC / Central	21-Oct	13-Nov	MON,WED	0945-1245;1400-1700	48 hours/ 16 sessions	20191021	$7,500	$3,750Enrol
COFC-24C33K	Cantonese / PC / MongKok	12-Nov	09-Jan	TUE,THU	1900-2200	48 hours/ 16 sessions	20191112	$7,500	$2,500Enrol
COFC-6D33E	English / PC / Central	23-Nov	11-Jan	SAT	1000-1300;1400-1700	48 hours/ 16 sessions	20191123	$7,500	$2,500Enrol
COFB-13D26K	Cantonese / PC / MongKok	25-Nov	18-Dec	MON,WED	0945-1245;1400-1700	48 hours/ 16 sessions	20191125	$7,500	$3,750Enrol
COFC-35C34E	English / PC / Central	27-Nov	22-Jan	WED,FRI	1900-2200	48 hours/ 16 sessions	20191127	$7,500	$2,500Enrol
COFB-14C10C	Cantonese / PC / Central	02-Dec	27-Jan	MON,THU	1900-2200	48 hours/ 16 sessions	20191202	$7,500	$3,750Enrol
COFC-6D26K	Cantonese / PC / MongKok	21-Dec	08-Feb	SAT	1000-1300;1400-1700	48 hours/ 16 sessions	20191221	$7,500	$2,500Enrol
COFC-6D08K	Cantonese / PC / MongKok	03/08	12/10	SAT	1000-1300;1400-1700	48 hours/ 16 sessions	20190803	$7,500	$2,500Enrol

課程介紹

本課程特別為辦公室行政人員而設計，教授如何利用 Microsoft Office 提升工作效率和質素。課程可以幫助學員將 Office 的功能特點充份發揮，提升桌面工作產力，妥善運用商業數據及優化工作流程。學員會學習使用 Microsoft Office 的中階和高階功能，涵蓋 Excel, Word, PowerPoint, Access 及 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

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

申請手續

可使用網上報名或將填妥的報名表 (下載) 連同學費支票 (抬頭請寫 Welkin Computer Training) 郵寄至天行電腦培訓收。
持續進修基金申請者須填妥申請表格 (下載)，獲本公司核實資料並在表格上蓋章後，將表格連同身份證幅本郵寄至新界荃灣青山公路 388 號中染大廈 25 樓 07-11 室持續進修基金辦事處收。申請人亦可把申請文件放入設於長沙灣政府合署 12 樓的收集箱內。
申請人會於十四個工作天內收到持續進修基金辦事處發出的申請結果。